CAN_TAX_PROV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
3	CIT_V	Number(7,5)	DECIMAL(6,5) NOT NULL	Tax Rate (V)
4	CIT_V1A	Number(7,5)	DECIMAL(6,5) NOT NULL	Surtax Rate (V1A)
5	CIT_V1B	Number(10,2)	DECIMAL(9,2) NOT NULL	Threshold Amount (V1A)
6	CIT_V2	Number(7,5)	DECIMAL(6,5) NOT NULL	Flat Tax on Net Income (V2)
7	CIT_V3	Number(7,5)	DECIMAL(6,5) NOT NULL	Flat Tax on Taxable Income(V3)
8	CIT_V4	Number(8,2)	DECIMAL(7,2) NOT NULL	Net Income Tax Surtax (V4)
9	CIT_S	Number(8,2)	DECIMAL(7,2) NOT NULL	Tax Reduction (S)
10	CIT_N1	Number(6,4)	DECIMAL(5,4) NOT NULL	Constant (N1)
11	CIT_N2	Number(10,2)	DECIMAL(9,2) NOT NULL	Constant (N2)
12	CIT_NCA	Number(10,2)	DECIMAL(9,2) NOT NULL	Net Claim Amount Threshold
13	CIT_TH	Number(8,2)	DECIMAL(7,2) NOT NULL	Threshold Amount (TH)
14	HEALTH_INS_RT	Number(8,6)	DECIMAL(7,6) NOT NULL	Health Insurance Rate
15	WCB_LIMIT	Number(10,2)	DECIMAL(9,2) NOT NULL	WCB Limit
16	PST_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Provincial Sales Tax Percent
17	PAYROLL_TAX_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	Payroll Tax Rate
18	PSTI_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	Province Sales Tax - Insurance
19	LCP_MAX	Number(8,2)	DECIMAL(7,2) NOT NULL	Prov Labour Sponsd Tx Cred Max
20	LCP_RT	Number(6,5)	DECIMAL(5,5) NOT NULL	Prov Labour Sponsd Tx Cred Rt
21	HST_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	Harmonized Sales Tax
22	CIT_V1A2	Number(7,5)	DECIMAL(6,5) NOT NULL	Surtax Rate (V1B)
23	CIT_V1B2	Number(10,2)	DECIMAL(9,2) NOT NULL	Threshold Amount (V1B)
24	HP_STATS_PROV_CD	Character(5)	VARCHAR2(5) NOT NULL	Stats Can Province Code Default Value: 99999
25	PIT_K1P	Number(7,5)	DECIMAL(6,5) NOT NULL	Prov Tax Credit Rate (K1P)
26	PIT_TCP	Number(10,2)	DECIMAL(9,2) NOT NULL	Basic Tax Credit Amount (TCP)