STAT_TX_CLS_TBL

(SQL Table)
Index Back

State Tax Class Table

Contains tax classes grouped by tax type for a state. Used by the US Tax Extract program.

# 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_GRP_TYPE Character(10) VARCHAR2(10) NOT NULL Tax Type
4 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

Prompt Table: PY_TAX_CLASS