CAN_TAX_BALANCE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID Prompt Table: BALANCE_ID_TBL
4	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year Prompt Table: BALANCE_YR_VW
5	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan Prompt Table: WAGELS_PLAN_TBL
6	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
7	BALANCE_QTR	Number(3,0)	SMALLINT NOT NULL	Balances for Quarter Prompt Table: BALANCE_ID_QTR
8	BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Balances for Period Prompt Table: BALANCE_ID_DEF
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	NLGRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross YTD
11	NLGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross QTD
12	NLGRS_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross MTD
13	TXGRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross YTD
14	TXGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross QTD
15	TXGRS_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross MTD
16	TAX_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax YTD
17	TAX_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax QTD
18	TAX_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax MTD