Wiki: HL$UPDIF

Disbursement Interface - Canada (HL)#

Interface Type: Disbursement File
File Structure as created

Structure#

Record#	Field#	Name	Beg	End	Type	Variable	Format Mask	Constant
10	1	Record Type Code	1	3	Char			10
10	2	Entity Code	4	19	Char	0050 Entity Code
10	3	Pay Destination	20	49	Char	0001 Pay Destination
10	4	Department	50	65	Char	0002 Department Code
10	5	Full Name	66	125	Char	0003 Full Name
10	6	Person Code	126	141	Char	0006 Person Code
10	7	Pay Number	142	145	Number	0051 Pay Number
10	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date	DD-Mon-YYYY
10	9	Number of Checks	157	160	Number	0052 Number of Checks
10	10	Number of Deposits	161	164	Number	0053 Number of Deposits
10	11	Check Number	165	174	Number	0160 Check Number
10	12	Amount	175	200	Number	0068 Check/Deposit Amount	00000009.99
10	13	String	201	249	Char	0069 Amount String
10	14	PRENOTE	250	251	Char	0070 PreNote
20	1	Record Type Code	1	3	Char			20
20	2	Entity Code	4	19	Char	0050 Entity Code
20	3	Pay Destination	20	49	Char	0001 Pay Destination
20	4	Department	50	65	Char	0002 Department Code
20	5	Full Name	66	125	Char	0003 Full Name
20	6	Person Code	126	141	Char	0006 Person Code
20	7	Pay Number	142	145	Number	0051 Pay Number
20	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
20	9	Number of Checks	157	160	Number	0052 Number of Checks
20	10	Number of Deposits	161	164	Number	0053 Number of Deposits
20	11	Check Number	165	174	Number	0160 Check Number
20	12	Department Name	175	200	Char	0034 Department Name
20	13	Locality	201	249	Char	0014 City
20	14	State	250	299	Char	0021 State
20	15	Net Pay	300	325	Number	0064 CTD Net Pay
20	16	Pay Number	326	330	Number	0051 Pay Number
20	17	Taxes	331	350	Number	0193 CTD Taxes Withheld
20	18	Deductions (Except Taxes)	351	370	Number	0194 CTD Deductions Excl Taxes
20	19	Taxes YTD	371	390	Number	0195 YTD Taxes Withheld
30	1	Record Type Code	1	3	Char			30
30	2	Entity Code	4	19	Char	0050 Entity Code
30	3	Pay Destination	20	49	Char	0001 Pay Destination
30	4	Department	50	65	Char	0002 Department Code
30	5	Full Name	66	125	Char	0003 Full Name
30	6	Person Code	126	141	Char	0006 Person Code
30	7	Pay Number	142	145	Number	0051 Pay Number
30	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
30	9	Number of Checks	157	160	Number	0052 Number of Checks
30	10	Number of Deposits	161	164	Number	0053 Number of deposits
30	11	Check Number	165	174	Number	0160 Check Number
30	12	FED TD1 Amount	175	194	Number	0168 Fed TD1 Amount
30	13	Federal Addn Tax PP	195	214	Number	0169 Fed Add Tax PP
30	14	Federal Filing Status	215	244	Char	0171 Fed Filing Status LEX
30	15	Federal Tax Method	245	274	Char	0173 Fed Tax Method LEX
30	16	Provincial Num Dependents	275	280	Number	0174 Prov # Dependents
30	17	Provincial Add Tax PP	281	291	Number	0175 Prov Add Tax PP
30	18	Provincial Tax Method	292	321	Char	0177 Prov Tax Method LEX
30	19	Provincial Filing Status	322	351	Char	0179 Prov Filing Status LEX
30	20	Provincial Claim Amount	351	380	Number	0180 Prov Claim Amount
41	1	3	1	3	Char			41
41	2	Entity Code	4	19	Char	0050 Entity Code
41	3	Pay Destination	20	49	Char	0001 Pay Destination
41	4	Department	50	65	Char	0002 Department
41	5	Full Name	66	125	Char	0003 Full Name
41	6	Person Code	126	141	Char	0006 Person Code
41	7	Pay Number	142	145	Char	0051 Pay Number
41	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
41	9	Number of Checks	157	160	Char	0052 Number of Checks
41	10	Number of Deposits	161	164	Char	0053 Number of Deposits
41	11	Check Number	165	174	Char	-1060 Check Number
41	12	PC Code	175	178	Char	0087 PC Code
41	13	Rate	179	198	Char	0092 Rate
41	14	Rate Basis Code	199	200	Char	0093 Rate Basis
41	15	Rate Basis LEX	201	220	Char	0094 Rate Basis LEX
41	16	Time	221	240	Char	0095 Associated Time
45	1	Record Type Code	1	3	Char			45
45	2	Entity Code	4	19	Char	0050 Entity Code
45	3	Pay Destination	20	49	Char	0001 Pay Destination
45	4	Department	50	65	Char	0002 Department
45	5	Full Name	66	125	Char	0003 Full Name
45	6	Person Code	126	141	Char	0006 Person Code
45	7	Pay Number	142	145	Number	0051 Pay Number
45	8	Pay Issue Date	146	156	Date	0007 Pay Issue date
45	9	Number of Checks	157	160	number	0052 Number of Checks
45	10	Number of Deposits	161	164	Number	0053 Number of Deposits
45	11	Check Number	165	174	Number	0160 Check Number
45	12	PC	175	178	Char	0087 PC Code
45	13	Abbrev	179	200	Char	PC Abbreviation
45	14	Amount	201	220	Char	0111 Amount
45	15	Task	221	236	Char	0115 Pay Point Task LEX
45	16	Reference	237	286	Char	0166 Reference
50	1	Record Type Code	1	3	Char			50
50	2	Entity Code	4	19	Char	0050 Entity Code
50	3	Pay Destination	20	49	Char	0001 Pay Destination
50	4	Department	50	65	Char	0002 Department
50	5	Full Name	66	125	Char	0003 Full Name
50	6	Person Code	126	141	Char	0006 Person Code
50	7	Pay Number	142	145	Number	0051 Pay Number
50	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
50	9	Number of Checks	157	160	Number	0052 Number of Checks
50	10	Number of Deposits	161	164	Number	0053 Number of Deposits
50	11	Check Number	165	174	Number	0160 Check Number
50	12	PC	175	180	Char	0087 PC Code
50	13	Abbrev	181	200	Char	0088 PC Abbreviation
50	14	Deduction Amount	201	221	Number	0090 Current Value
50	15	YTD	222	241	Number	0091 YTD Value
60	1	Record Type Code	1	3	Char			60
60	2	Entity Code	4	19	Char	0050 Entity Code
60	3	Pay Destination	20	49	Char	0001 Pay Destination
60	4	Department	50	65	Char	0002 Department Code
60	5	Full Name	66	125	Char	0003 Full Name
60	6	Person Code	126	141	Char	0006 Person Code
60	7	Pay Number	142	145	Number	0051 Pay Number
60	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
60	9	Number of Checks	157	160	Number	0052 Number of Checks
60	10	Number of Deposits	161	164	Number	0053 Number of Deposits
60	11	Check Number	165	174	Number	0160 Check Number
70	1	Record Type Code	1	3	Char			70
70	2	Entity Code	4	19	Char	0050 Entity Code
70	3	Pay Destination	20	49	Char	0001 Pay Destination
70	4	Department	50	65	Char	0002 Department Code
70	5	Full Name	66	125	Char	0003 Full Name
70	6	Person Code	126	141	Char	0006 Person Code
70	7	Pay Number	142	145	Number	0051 Pay Number
70	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date	DD-Mon-YYYY
70	9	Number of Checks	157	160	Number	0052 Number of Checks
70	10	Number of Deposits	161	164	Number	0053 Number of Deposits
70	11	Check Number	165	174	Number	0160 Check Number
80	1	Record Type Code	1	3	Char			80
80	2	Entity Code	4	19	Char	0050 Entity Code
80	3	Pay Destination	20	49	Char	0001 Pay Destination
80	4	Department	50	65	Char	0002 Department Name
80	5	Full Name	66	125	Char	0003 Full Name
80	6	Person Code	126	141	Char	0006 Person Code
80	7	Pay Number	142	145	Number	0051 Pay Number
80	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
80	9	Number of Checks	157	160	Number	0052 Number of Checks
80	10	Number of Deposits	161	164	Number	0053 Number of Deposits
80	11	Check Number	165	174	Number	0160 Check Number
80	12	PC	175	180	Char	0087 PC Code
80	13	Amout	181	200	Char	0132 Arrears Amount
80	14	Reference	201	251	Char	0133 Arrears Reference
90	1	Record Type Code	1	3	Char			90
90	2	Entity Code	4	19	Char	0050 Entity Code
90	3	Pay Destination	20	49	Char	0001 Pay Destination
90	4	Department	50	65	Char	0002 Department Code
90	5	Full Name	66	125	Char	0003 Full Name
90	6	Person Code	126	141	Char	0006 Person Code
90	7	Pay Number	142	145	Number	0051 Pay Number
90	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
90	9	Number of Checks	157	160	Number	0052 Number of Checks
90	10	Number of Deposits	161	164	Number	0053 Number of Deposits
90	11	Check Number	165	174	Number	0160 Check Number
100	1	Record Type Code	1	3	Char			100
100	2	Entity Code	4	19	Char	0050 Entity Code
100	3	Pay Destination	20	49	Char	0001 Pay Destination
100	4	Department	50	65	Char	0002 Department Code
100	5	Full Name	66	125	Char	0003 Full Name
100	6	Person Code	126	141	Char	0006 Person Code
100	7	Pay Number	142	145	Number	0051 Pay Number
100	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date