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