STATE_ADDL_A (SQL Table)	Index Back
CT Table A Exemption Rates This record is used to store tax rates for Connecticut withholding taxes by tax status. Data in this record will be maintained by PeopleSoft.

STATE_ADDL_A

(SQL Table)

CT Table A Exemption Rates

This record is used to store tax rates for Connecticut withholding taxes by tax status. Data in this record will be maintained by PeopleSoft.

Parent record: STATE_TAX_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE Character(6) VARCHAR2(6) NOT NULL State

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 TAX_STATUS Character(1) VARCHAR2(1) NOT NULL Tax Status

4 LOW_GROSS Number(10,2) DECIMAL(9,2) NOT NULL Low Gross

5 EXEMPTION_AMT Number(5,0) INTEGER NOT NULL Exemption Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	TAX_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Tax Status
4	LOW_GROSS	Number(10,2)	DECIMAL(9,2) NOT NULL	Low Gross
5	EXEMPTION_AMT	Number(5,0)	INTEGER NOT NULL	Exemption Amount