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 is 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 is 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(12,2) DECIMAL(11,2) NOT NULL Low Gross

5 EXEMPTION_AMT Number(9,0) DECIMAL(9) 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(12,2)	DECIMAL(11,2) NOT NULL	Low Gross
5	EXEMPTION_AMT	Number(9,0)	DECIMAL(9) NOT NULL	Exemption Amount