HL$UPDIF_CDN

Disbursement Interface - Canada (HL)#

Interface Type: Disbursement File

File Structure as created

This interface definition is intended to be modified by the end users as required by their receiving system.

Structure#

Record#Field#NameBegEndTypeVariableFormat MaskConstant
101Record Type Code13Char 10
102Entity Code419Char0050 Entity Code
103Pay Destination2049Char0001 Pay Destination
104Department5065Char0002 Department Code
105Full Name66125Char0003 Full Name
106Person Code126141Char0006 Person Code
107Pay Number142145Number0051 Pay Number
108Pay Issue Date146156Date0007 Pay Issue DateDD-Mon-YYYY
109Number of Checks157160Number0052 Number of Checks
1010Number of Deposits161164Number0053 Number of Deposits
1011Check Number165174Number0160 Check Number
1012Amount175200Number0068 Check/Deposit Amount00000009.99
1013String201249Char0069 Amount String
1014PRENOTE250251Char0070 PreNote
201Record Type Code13Char 20
202Entity Code419Char0050 Entity Code
203Pay Destination2049Char0001 Pay Destination
204Department5065Char0002 Department Code
205Full Name66125Char0003 Full Name
206Person Code126141Char0006 Person Code
207Pay Number142145Number0051 Pay Number
208Pay Issue Date146156Date0007 Pay Issue Date
209Number of Checks157160Number0052 Number of Checks
2010Number of Deposits161164Number0053 Number of Deposits
2011Check Number165174Number0160 Check Number
2012Department Name175200Char0034 Department Name
2013Locality201249Char0014 City
2014State250299Char0021 State
2015Net Pay300325Number0064 CTD Net Pay
2016Pay Number326330Number0051 Pay Number
2017Taxes331350Number0193 CTD Taxes Withheld
2018Deductions (Except Taxes)351370Number0194 CTD Deductions Excl Taxes
2019Taxes YTD371390Number0195 YTD Taxes Withheld
301Record Type Code13Char 30
302Entity Code419Char0050 Entity Code
303Pay Destination2049Char0001 Pay Destination
304Department5065Char0002 Department Code
305Full Name66125Char0003 Full Name
306Person Code126141Char0006 Person Code
307Pay Number142145Number0051 Pay Number
308Pay Issue Date146156Date0007 Pay Issue Date
309Number of Checks157160Number0052 Number of Checks
3010Number of Deposits161164Number0053 Number of deposits
3011Check Number165174Number0160 Check Number
3012FED TD1 Amount175194Number0168 Fed TD1 Amount
3013Federal Addn Tax PP195214Number0169 Fed Add Tax PP
3014Federal Filing Status215244Char0171 Fed Filing Status LEX
3015Federal Tax Method245274Char0173 Fed Tax Method LEX
3016Provincial Num Dependents275280Number0174 Prov # Dependents
3017Provincial Add Tax PP281291Number0175 Prov Add Tax PP
3018Provincial Tax Method292321Char0177 Prov Tax Method LEX
3019Provincial Filing Status322351Char0179 Prov Filing Status LEX
3020Provincial Claim Amount351380Number0180 Prov Claim Amount
411313Char 41
412Entity Code419Char0050 Entity Code
413Pay Destination2049Char0001 Pay Destination
414Department5065Char0002 Department
415Full Name66125Char0003 Full Name
416Person Code126141Char0006 Person Code
417Pay Number142145Char0051 Pay Number
418Pay Issue Date146156Date0007 Pay Issue Date
419Number of Checks157160Char0052 Number of Checks
4110Number of Deposits161164Char0053 Number of Deposits
4111Check Number165174Char-1060 Check Number
4112PC Code175178Char0087 PC Code
4113Rate179198Char0092 Rate
4114Rate Basis Code199200Char0093 Rate Basis
4115Rate Basis LEX201220Char0094 Rate Basis LEX
4116Time221240Char0095 Associated Time
451Record Type Code13Char 45
452Entity Code419Char0050 Entity Code
453Pay Destination2049Char0001 Pay Destination
454Department5065Char0002 Department
455Full Name66125Char0003 Full Name
456Person Code126141Char0006 Person Code
457Pay Number142145Number0051 Pay Number
458Pay Issue Date146156Date0007 Pay Issue date
459Number of Checks157160number0052 Number of Checks
4510Number of Deposits161164Number0053 Number of Deposits
4511Check Number165174Number0160 Check Number
4512PC175178Char0087 PC Code
4513Abbrev179200CharPC Abbreviation
4514Amount201220Char0111 Amount
4515Task221236Char0115 Pay Point Task LEX
4516Reference237286Char0166 Reference
501Record Type Code13Char 50
502Entity Code419Char0050 Entity Code
503Pay Destination2049Char0001 Pay Destination
504Department5065Char0002 Department
505Full Name66125Char0003 Full Name
506Person Code126141Char0006 Person Code
507Pay Number142145Number0051 Pay Number
508Pay Issue Date146156Date0007 Pay Issue Date
509Number of Checks157160Number0052 Number of Checks
5010Number of Deposits161164Number0053 Number of Deposits
5011Check Number165174Number0160 Check Number
5012PC175180Char0087 PC Code
5013Abbrev181200Char0088 PC Abbreviation
5014Deduction Amount201221Number0090 Current Value
5015YTD222241Number0091 YTD Value
601Record Type Code13Char 60
602Entity Code419Char0050 Entity Code
603Pay Destination2049Char0001 Pay Destination
604Department5065Char0002 Department Code
605Full Name66125Char0003 Full Name
606Person Code126141Char0006 Person Code
607Pay Number142145Number0051 Pay Number
608Pay Issue Date146156Date0007 Pay Issue Date
609Number of Checks157160Number0052 Number of Checks
6010Number of Deposits161164Number0053 Number of Deposits
6011Check Number165174Number0160 Check Number
701Record Type Code13Char 70
702Entity Code419Char0050 Entity Code
703Pay Destination2049Char0001 Pay Destination
704Department5065Char0002 Department Code
705Full Name66125Char0003 Full Name
706Person Code126141Char0006 Person Code
707Pay Number142145Number0051 Pay Number
708Pay Issue Date146156Date0007 Pay Issue DateDD-Mon-YYYY
709Number of Checks157160Number0052 Number of Checks
7010Number of Deposits161164Number0053 Number of Deposits
7011Check Number165174Number0160 Check Number
801Record Type Code13Char 80
802Entity Code419Char0050 Entity Code
803Pay Destination2049Char0001 Pay Destination
804Department5065Char0002 Department Name
805Full Name66125Char0003 Full Name
806Person Code126141Char0006 Person Code
807Pay Number142145Number0051 Pay Number
808Pay Issue Date146156Date0007 Pay Issue Date
809Number of Checks157160Number0052 Number of Checks
8010Number of Deposits161164Number0053 Number of Deposits
8011Check Number165174Number0160 Check Number
8012PC175180Char0087 PC Code
8013Amout181200Char0132 Arrears Amount
8014Reference201251Char0133 Arrears Reference
901Record Type Code13Char 90
902Entity Code419Char0050 Entity Code
903Pay Destination2049Char0001 Pay Destination
904Department5065Char0002 Department Code
905Full Name66125Char0003 Full Name
906Person Code126141Char0006 Person Code
907Pay Number142145Number0051 Pay Number
908Pay Issue Date146156Date0007 Pay Issue Date
909Number of Checks157160Number0052 Number of Checks
9010Number of Deposits161164Number0053 Number of Deposits
9011Check Number165174Number0160 Check Number
1001Record Type Code13Char 100
1002Entity Code419Char0050 Entity Code
1003Pay Destination2049Char0001 Pay Destination
1004Department5065Char0002 Department Code
1005Full Name66125Char0003 Full Name
1006Person Code126141Char0006 Person Code
1007Pay Number142145Number0051 Pay Number
1008Pay Issue Date146156Date0007 Pay Issue Date
1009Number of Checks157160Number0052 Number of Checks
10010Number of Deposits161164Number0053 Number of Deposits
10011Check Number165174Number0160 Check Number
1101Record Type Code13Char 110
1102Entity Code419Char0050 Entity Code
1103Pay Destination2049Char0001 Pay Destination
1104Department5065Char0002 Department Code
1105Full Name66125Char0003 Full name
1106Person Code126141Char0006 Person Code
1107Pay Nubmber142145Number0051 Pay Number
1108Pay Issue Date146156Date0007 Pay Issue date
1109Number of Checks157160Number0052 Number of Checks
11010Number of Deposits161164Number0053 Number of Deposits
11011Check Number165174Number0160 Check Number
11012Message175374Char0158 Message
1201Person Code110Char0006 Person Code
1202Pay Number1114Char0051 Pay Number



Notes#

Click to create a new notes page