CAN_TAX_PRVDATA

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province Prompt Table: PROVINCE_NM_VW
5	CIT_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Net Claim Amount
6	TD1_ADJUST	Number(10,2)	DECIMAL(9,2) NOT NULL	TD1 Adjustment
7	CIT_PRESCR_AREA	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Prescibed Area Deduction
8	CIT_TAX_CREDITS	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Other Federal Tax Credits
9	CIT_SPECIAL_LTRS	Number(10,2)	DECIMAL(9,2) NOT NULL	Special Letters
10	CIT_FACTOR_Y	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Y Factor
11	CIT_FACTOR_TH	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT TH Factor
12	LCF_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	Labour Sponsored Shares Amount
13	CIT_F_FACTOR_EE	Number(10,2)	DECIMAL(9,2) NOT NULL	RPP/RRSP Limit
14	PIT_K3P_AMOUNT	Number(10,2)	DECIMAL(9,2) NOT NULL	Other Provincial Credits (K3P)
15	NON_INDEX_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Non-Indexed Amount
16	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %DATE