Table: Paper T4 Information

Table: CTT4PD
View: CT0005
Record length: 1711
Flags: A R

Keys: 1

Title	Flags	Fields

Key Name		SORTPARAM, SEQUENCE

Fields: 95

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
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
FISHNET	BCD*10.3
FISHSHARE	BCD*10.3
OFFICEREXP	BCD*10.3
EMPAGENCY	BCD*10.3	Pay Year
TAXIDRIVER	BCD*10.3	Selection List
BARBER	BCD*10.3	From Employee
HEALTHPLAN	BCD*10.3	To Employee
EMPCODE	String*2	Employer Name
OTHBOX1	String*2	Sort By
OTHAMT1	BCD*10.3	Then By
OTHBOX2	String*2	Class
OTHAMT2	BCD*10.3	Employer Address 1
OTHBOX3	String*2	Employer Address 2
OTHAMT3	BCD*10.3	Employer Address 3
OTHBOX4	String*2	Employer Address 4
OTHAMT4	BCD*10.3	Employer City
OTHBOX5	String*2	Employer Province
OTHAMT5	BCD*10.3	Employer Postal Code
OTHBOX6	String*2	Employer Account Number
OTHAMT6	BCD*10.3	EI Rate 1
OTHBOX7	String*2	EI Rate 2
OTHAMT7	BCD*10.3	EI Rate 3
OTHBOX8	String*2	EI Rate 4
OTHAMT8	BCD*10.3	EI Rate 5
OTHBOX9	String*2	All EI Rates
OTHAMT9	BCD*10.3	EI Exempt
OTHBOX10	String*2	Paper
OTHAMT10	BCD*10.3
OTHBOX11	String*2
OTHAMT11	BCD*10.3
OTHBOX12	String*2
OTHAMT12	BCD*10.3

This page was generated on 2008-May-02