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]