Table: Paper T4 Information

Table: CTT4PD
View: CT0005
Record Length: 1781

Flags: A R 

Keys: 1

Title Flags Fields

Key Name SORTPARAMSEQUENCE

Fields: 102

Field Type Title Presentation

SORTPARAM String*94 Sort Parameter
SEQUENCE Integer Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
EMPLRACCNO String*15 Employer Account Number
EMPLRNAME String*60 Employer Name
EMPLRADDR1 String*60 Employer Address 1
EMPLRADDR2 String*60 Employer Address 2
EMPLRADDR3 String*60 Employer Address 3
EMPLRADDR4 String*60 Employer Address 4
EMPLRCITY String*30 Employer City
EMPLRSTATE String*30 Employer Province
EMPLRZIP String*20 Employer Postal Code
EMPLOYEE String*12 Employee ID
SSN String*11 Employee SIN Mask: %-3d-%-3d-%-3d
LASTNAME String*20 Employee Last Name
FIRSTNAME String*15 Employee First Name
MIDDLENAME String*15 Employee Middle Name
ADDRESS1 String*60 Employee Address 1
ADDRESS2 String*60 Employee Address 2
ADDRESS3 String*60 Employee Address 3
ADDRESS4 String*60 Employee Address 4
CITY String*30 Employee City
STATE String*30 Employee Province
ZIP String*20 Employee Postal Code
WAGESTIPS BCD*10.3 Employee Income
CPENSIONC BCD*10.3 Pension Contributions - Canada plan
QPENSIONC BCD*10.3 Pension Contributions - Quebec plan
UIPREMIUM BCD*10.3 EI Premium
RPENSIONC BCD*10.3 Registered Pension Plan Deduction
INCOMETAX BCD*10.3 Income Tax Deducted
UIEARNING BCD*10.3 EI Insurable Earnings
CPPEARNING BCD*10.3 CPP Pensionable Earnings
HOUSINGBEN BCD*10.3 Housing, Board, Lodging
TRAVELBEN BCD*10.3 Travel in Designated Areas
COAUTOBEN BCD*10.3 Personal Use of Employer's Auto
LOANBEN BCD*10.3 Interest Free/Low Interest Loans
STOCKBEN BCD*10.3 Stock Option Benefits
OTHERBEN BCD*10.3 Other Taxable Allowances/Benefits
COMMISSION BCD*10.3 Employment Commissions
UNIONDUES BCD*10.3 Unions Dues Deduction
CHARITYDED BCD*10.3 Charitable Contribution Deductions
PENSIONADJ BCD*10.3 Pension Plan Adjustment
STOCKBEND BCD*10.3 Stock Option and Shares Ded(110(1)(d))
STOCKBEND1 BCD*10.3 Stock Option and Shares Ded(110(1)(d.1))
INDIANPAY BCD*10.3 Status Indian
EXEMPTCPP Boolean Exempt CPP/QPP
EXEMPTUI Boolean Exempt EI
RPPID String*9 Pension Plan Registration Number (RPP)
EMPPROV String*2 Province of Employment
HRLBEN BCD*10.3 Employee Home-relocation Loan
NOTES String*250 Notes
COUNTRY String*30 Country
WCBREPAID BCD*10.3 WCB Repaid
RCPENSION BCD*10.3 Employer's CPP Contributions
RUIPREMIUM BCD*10.3 Employer's UI premiums
PPIPTAX BCD*10.3 Provincial Parental Insurance Plan
PPIPEARN BCD*10.3 PPIP Insurable Earnings
EXEMPTPPIP Boolean Exempt PPIP
MEDITRAVEL BCD*10.3 Medical Travel
TRANSPASS BCD*10.3 Public Transit Pass
FISHGROSS BCD*10.3 Fishers, Gross Income
FISHNET BCD*10.3 Fishers, Net Income
FISHSHARE BCD*10.3 Fishers, Shared Income
OFFICEREXP BCD*10.3 Officer's expense Allowance
EMPAGENCY BCD*10.3 Employment Agency
TAXIDRIVER BCD*10.3 Taxi Driver
BARBER BCD*10.3 Barbers and Hairdressers
HEALTHPLAN BCD*10.3 Private Health Plan
EMPCODE String*2 Employment Code
OTHBOX1 String*2 Other Box 1
OTHAMT1 BCD*10.3 Other Amount 1
OTHBOX2 String*2 Other Box 2
OTHAMT2 BCD*10.3 Other Amount 2
OTHBOX3 String*2 Other Box 3
OTHAMT3 BCD*10.3 Other Amount 3
OTHBOX4 String*2 Other Box 4
OTHAMT4 BCD*10.3 Other Amount 4
OTHBOX5 String*2 Other Box 5
OTHAMT5 BCD*10.3 Other Amount 5
OTHBOX6 String*2 Other Box 6
OTHAMT6 BCD*10.3 Other Amount 6
OTHBOX7 String*2 Other Box 7
OTHAMT7 BCD*10.3 Other Amount 7
OTHBOX8 String*2 Other Box 8
OTHAMT8 BCD*10.3 Other Amount 8
OTHBOX9 String*2 Other Box 9
OTHAMT9 BCD*10.3 Other Amount 9
OTHBOX10 String*2 Other Box 10
OTHAMT10 BCD*10.3 Other Amount 10
OTHBOX11 String*2 Other Box 11
OTHAMT11 BCD*10.3 Other Amount 11
OTHBOX12 String*2 Other Box 12
OTHAMT12 BCD*10.3 Other Amount 12
ELIGRET BCD*10.3 Eligible retiring allowances
NOELIGRET BCD*10.3 Non-eligible retiring allowances
XELIGRET BCD*10.3 Status Indian (exempt income) - Eligible retiring allowances
XNOELIGRET BCD*10.3 Status Indian (exempt income) - Non-eligible retiring allowances
FRFIGHTER BCD*10.3 Emergency services volunteer exempt amount
SPWORKSITE BCD*10.3 Special Working Site