GPUS_TAX_ST_TBL

(SQL Table)
Index Back

State Tax Rates

State Tax Rates

# 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_TAX_ANN_MTHD Character(2) VARCHAR2(2) NOT NULL Calculation for Annualized
01=Wage Bracket
03=FWT Wage Bracket
04=FWT Credit
05=FWT Credit Specific Allowance
06=FWT Credit (2nd method)
07=Percent of FWT
08=FICA Credit
09=Special Multiplier
10=Special Exemption
11=Standard Deduction Threshold
12=Special Personal Credit
13=Annual Exemption Amount
14=Additional Allowance Number
15=Percent of Taxable Gross (AZ)
16=FWT Credit (OR)

Default Value: 01

4 GPUS_TAX_REG_MTHD Character(2) VARCHAR2(2) NOT NULL Paid with Regular Wages
00=Not Applicable
01=Aggregate
02=Percent of Taxable Gross
03=Percent of FWT
04=Multiple Rates
05=Aggregate-No Annualize
06=Aggregate-No Tax else Percent
07=Special Table
08=Percent of Taxable Gross (AZ)

Default Value: 01

5 GPUS_TAX_SEP_MTHD Character(2) VARCHAR2(2) NOT NULL Separate Payment
00=Not Applicable
01=Aggregate
02=Percent of Taxable Gross
03=Percent of FWT
04=Multiple Rates
05=Aggregate-No Annualize
06=Aggregate-No Tax else Percent
07=Special Table
08=Percent of Taxable Gross (AZ)

Default Value: 01

6 GPUS_TAX_FICA_MTHD Character(2) VARCHAR2(2) NOT NULL FICA Method
01=None
02=Prorate

Default Value: 01

7 GPUS_TAX_PCT Number(7,3) DECIMAL(6,3) NOT NULL Tax Percent
8 GPUS_TAX_PCT_SPC Number(6,2) DECIMAL(5,2) NOT NULL Tax Special Percent
9 GPUS_TAX_STATE_EIC Number(6,2) DECIMAL(5,2) NOT NULL State EIC Percent
10 GPUS_TAX_ROUND Character(1) VARCHAR2(1) NOT NULL Round to Nearest Whole Dollar

Y/N Table Edit

Default Value: N