WRK_TAX_CAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
9	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
10	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan
11	NLGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current No Limit Gross
12	TXGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Taxable Gross
13	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax
14	TAX_NOT_TAKEN	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Not Taken
15	UI_ER_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	EI Employer Rate
16	PY_CAN_PEN_EXEMPT	Number(10,2)	DECIMAL(9,2) NOT NULL	Canada Pension Plan or Quebec Pension Plan - Basic Annual Exemption Amount.
17	PY_F5A_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the periodic income.
18	PY_F5B_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the non-periodic payment.