TRW_PY_TMP_CTAX

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRW_STMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Reward Statement ID
2	TRW_DATASRC_ID	Character(15)	VARCHAR2(15) NOT NULL	Total rewards statement - Reward Data Source ID
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
5	PAY_END_DT	Date(10)	DATE	Pay Period End Date
6	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
7	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
8	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
9	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	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
14	TRW_CUR_EE_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Employee Current Deduction
15	TRW_CUR_ER_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Employer Current Amount
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
18	CHECK_DT	Date(10)	DATE	Check date.
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country