| Field Name | Type | Lgth | Dec. | Indx | Description |
| EMP_ID | C | 12 | N | Employee identification | |
| DEPT | C | 1 | N | Employee's normal department | |
| FNAME | C | 15 | N | Employee's first name | |
| INIT | C | 1 | N | Employee's second name initial | |
| SNAME | C | 15 | N | Employee's surname | |
| ADD | C | 30 | N | Street part of employee's address | |
| ADD2 | C | 30 | N | 2nd line of address | |
| CTY | C | 25 | N | City of address | |
| PROV | C | 20 | N | Province of address | |
| COUNTRY | C | 3 | N | Country code | |
| PC | C | 7 | N | Postal code | |
| TEL | C | 12 | N | Employee's telephone no. | |
| SIN | N | 9 | N | Employee's social insurance number | |
| POS | C | 15 | N | Position | |
| ECDE | C | 2 | N | Employment code | |
| HPP | N | 5 | 2 | N | Employee's holiday pay percentage |
| ROP | N | 8 | 2 | N | Employee's rate of pay |
| UNIT | C | 1 | N | Employee's unit of pay | |
| DYH | N | 5 | 2 | N | Daily work hours |
| MMADV | N | 9 | 2 | N | Mid Month Advance |
| OSADV | N | 9 | 2 | N | Outstanding Advances |
| EXM | N | 8 | 2 | N | Total Federal Tax Credit per TD1 |
| TCEX | L | 1 | N | Income Tax excemption per TD1 | |
| I1 | N | 9 | 2 | N | Total Renumeration per TD1X |
| EXP | N | 9 | 2 | N | Revised Expense Amount per TD1X |
| HD | N | 8 | 2 | N | Living in Prescribed Zone per TD1 |
| K3 | N | 8 | 2 | N | Other Federal Tax Credit |
| TD3 | N | 7 | 2 | N | Tax deduction per TD3 Form |
| NR | L | 1 | N | Non-residents Indicator per TD1 | |
| NR90 | L | 1 | N | Non-residents 90% rule Indicator per
TD1 |
|
| F1 | N | 8 | 2 | N | Child Care or Alimony Payments Deduction |
| F2 | N | 8 | 2 | N | Alimony or Maintence to be deducted from Source (Pay Slip) |
| PY | N | 8 | 2 | N | Provincial "Y" factor. Ontario & Manitoba only. |
| CPPEX | C | 1 | N | Canadian pension plan exemption | |
| UIEX | C | 1 | N | Unemployment insurance exemption | |
| MTB | N | 7 | 2 | N | Estimated monthly tax benefits |
| MTBUIEX | N | 7 | 2 | N | Estimated monthly tax benefits no UI deduction |
| MTBCPPX | N | 7 | 2 | N | Estimated monthly tax benefits
no CPP deduction |
| PPNO | C | 8 | N | Registered pension plan no | |
| PPP | N | 5 | 2 | N | Pension plan percentage |
| MPA1 | N | 6 | 2 | N | Medical Deduction #1 |
| MPA2 | N | 6 | 2 | N | Medical Deduction #2 |
| DPA | N | 6 | 2 | N | Dental Deduction |
| OPA1 | N | 8 | 2 | N | Other Deduction #1 |
| OPA2 | N | 8 | 2 | N | Other Deduction #2 |
| RDA1 | N | 8 | 2 | N | Recurring Debt Deduction #1 |
| RDB1 | N | 9 | 2 | N | Recurring Debt Balance #1 |
| RDT1 | N | 9 | 2 | N | Recurring Debt Total #1 |
| RDA2 | N | 8 | 2 | N | Recurring Debt Deduction #2 |
| RDB2 | N | 9 | 2 | N | Recurring Debt Balance #2 |
| RDT2 | N | 9 | 2 | N | Recurring Debt Total #2 |
| UND | N | 7 | 2 | N | Union dues deduction |
| UND2 | N | 7 | 2 | N | Union dues deduction #2 |
| UNPER | N | 6 | 3 | N | Union dues deduction Period |
| UNION | C | 10 | N | Union Code | |
| FDW | D | 8 | N | First day employee worked for employer | |
| SD | D | 8 | N | Seniority Date | |
| BD | D | 8 | N | Employee's birthday | |
| LDW | D | 8 | N | Last day worked | |
| RED | D | 8 | N | Rate of Pay Effective Date | |
| POE | C | 3 | N | Employee's province of employment | |
| TCP | N | 8 | 2 | N | Total Provincial Tax Credit
per Provincial TD1xx |
| TCPEX | L | 1 | N | Provincial Income Tax excemption
per Provincial TD1xx |
|
| K3P | N | 8 | 2 | N | Other Provincial Tax Credit |
| CC | N | 2 | N | Number of Under 18 Dependents. Ontario only | |
| SRATE | N | 7 | 3 | N | Skill Rate |
| YRT | N | 9 | 2 | N | Regular time earnings |
| YOT | N | 9 | 2 | N | Overtime earnings |
| YDT | N | 9 | 2 | N | Double time earnings |
| YHRS | N | 7 | 2 | N | Total hours worked |
| YCOM | N | 9 | 2 | N | Commission earnings |
| YHP | N | 9 | 2 | N | Holiday pay paid |
| YHPB | N | 9 | 2 | N | Holiday pay bank unpaid |
| YDLH | D | 8 | N | Date last holiday paid | |
| YOP | N | 9 | 2 | N | Other earnings |
| YNT | N | 9 | 2 | N | Non taxable reimbursements |
| YGROSS | N | 9 | 2 | N | Gross pay |
| YINTAX | N | 9 | 2 | N | Income tax deducted |
| YCPP | N | 7 | 2 | N | Canada Pension Plan deducted |
| YQPP | N | 7 | 2 | N | Quebec Pension Plan deducted |
| YCPPEX | N | 9 | 2 | N | C.P.P. exempt Earnings |
| YQPPEX | N | 9 | 2 | N | Q.P.P. exempt Earnings |
| YUI | N | 7 | 2 | N | Unemployment insurance deducted |
| YUIE | N | 8 | 2 | N | Unemployment insurable earnings |
| YUIW | N | 7 | 4 | N | Unemployment insurable weeks |
| YPEN | N | 9 | 2 | N | Pension deductions |
| YMP1 | N | 9 | 2 | N | Medical #1 deducted |
| YMP2 | N | 9 | 2 | N | Medical #2 deducted |
| YDP | N | 9 | 2 | N | Dental Plan deducted |
| YUN | N | 9 | 2 | N | Union deducted |
| YPQT | N | 9 | 2 | N | Quebec income tax deducted |
| YOD1 | N | 9 | 2 | N | Other Deductions #1 deducted |
| YOD2 | N | 9 | 2 | N | Other Deductions #2 deducted |
| YMTCE | N | 9 | 2 | N | Maintenance Deducted |
| YOD | N | 9 | 2 | N | Other deductions |
| YTB | N | 10 | 2 | N | Taxable benefits |
| YTIPS | N | 10 | 2 | N | Tips |
| YWKS | N | 7 | 4 | N | Total employed weeks |
| Field Name | Type | Lgth | Dec. | Indx | Description |
| YHPHRS | N | 7 | 2 | N | Vacation Pay Hours |
| YSHHRS | N | 7 | 2 | N | Statuary Holiday Hours |
| YSPHRS | N | 7 | 2 | N | Sick Pay Hours |
| YLTHRS | Lieu Hours [Only used with
Job Costing] |
||||
| AHP | C | 1 | N | Accumulated Holiday Pay code | |
| PTYPE | C | 1 | N | Pay Type (see HREMPE.dbf) |
[Home]
[Top] [Overview]
[Operations] [Appendix]