STATE_ADDL_B (SQL Table)	Index Back
CT Table B Credits This record is used to store tax rates for Connecticut tax credits by tax status. Data in this record is maintained by PeopleSoft.

STATE_ADDL_B

(SQL Table)

CT Table B Credits

This record is used to store tax rates for Connecticut tax credits 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(10,2) DECIMAL(9,2) NOT NULL Low Gross

5 TAX_RT Signed Number(8,6) DECIMAL(6,6) NOT NULL Tax Rate (after form)

#	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	TAX_RT	Signed Number(8,6)	DECIMAL(6,6) NOT NULL	Tax Rate (after form)