GPUS_TAX_ST_ALL

(SQL Table)
Index Back

State Tax Allowances/Exemption

State Tax Allowances and Exemptions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: GPUS_STATE_VW

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 GPUS_SWT_MAR_STAT Character(1) VARCHAR2(1) NOT NULL SWT Marital Status

Prompt Table: GPUS_SWT_MAR_ST

4 GPUS_TAX_ALL_TYP Character(2) VARCHAR2(2) NOT NULL Allowance Definition
01=Allowance Amount
02=2nd Allowance Amount
03=Additional Allowances
04=Low Income Exemption
05=Percent Below Limit
06=Percent Above Limit
07=Threshold Below Limit
08=Allowance Limit
09=Max SWT Base
10=Max FWT Exemption
11=Max SWT Base more than 2
12=Max FICA Exemption
13=Optional Deduction
14=Standard Deducton Allowable
15=3rd and Subsequent Allowance

Default Value: 01

5 GPUS_TAX_AMT Signed Number(17,6) DECIMAL(15,6) NOT NULL Tax Amount
6 GPUS_TAX_PCT Number(7,3) DECIMAL(6,3) NOT NULL Tax Percent