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(4,0)	SMALLINT NOT NULL	Page #
6	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
7	SEPCHK	Number(1,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) CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan 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) QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan 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