STATE_TAXRT_TBL (SQL Table)	Index Back
State/Federal Tax Rate Table This record is used to store tax rates for state and federal withholding taxes by tax status. Data in this record is maintained by PeopleSoft.

STATE_TAXRT_TBL

(SQL Table)

State/Federal Tax Rate Table

This record is used to store tax rates for state and federal 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 LOW_TAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Low Tax

6 TAX_RT Signed Number(12,10) DECIMAL(10,10) NOT NULL Tax Rate (after form)

7 CREDIT_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Credit 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	LOW_TAX	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Low Tax
6	TAX_RT	Signed Number(12,10)	DECIMAL(10,10) NOT NULL	Tax Rate (after form)
7	CREDIT_AMOUNT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Credit Amount