!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| |