Table: Paper T4 Information

Table: CTT4PD
View: CT0005
Record Length: 1781

Flags: A R 

Keys: 1

Title Flags Fields
Key Name SORTPARAM, SEQUENCE

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

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).