ST_OTH_TAX_TBL

(SQL Table)
Index Back

State Special Tax Rate Table

This record is used to store contants required for payroll calculation of unemployment, disability, and certain other special state taxes. This table 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_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

    Prompt Table: PY_TAX_CLASS

    4 TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Calculation Type
    G=Percent of Taxable Gross
    N=Not Applicable
    U=Use ER Wage for EE Tax

    Default Value: G

    5 TAXGR_BASE Character(1) VARCHAR2(1) NOT NULL Tax Gross Base
    D=Disability
    H=Withholding
    P=Paid Benefit
    U=Unemployment

    Default Value: U

    6 TAX_RT Signed Number(12,10) DECIMAL(10,10) NOT NULL Tax Rate (after form)
    7 MAX_GROSS Number(8,0) INTEGER NOT NULL Maximum Gross
    8 MAXIMUM_TAX Number(8,2) DECIMAL(7,2) NOT NULL Maximum Tax
    9 PERIOD_MAX Character(1) VARCHAR2(1) NOT NULL Period Maximum

    Y/N Table Edit

    Default Value: N

    10 SELF_ADJ Character(1) VARCHAR2(1) NOT NULL Self Adjust

    Y/N Table Edit

    Default Value: N

    11 EE_ER_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Employee / Employer / Both
    B=Empl and Emplr Tax
    E=Employee Tax Only
    M=Memo Tax Only
    R=Employer Tax Only

    Default Value: R

    12 TIPS_DELAY_WTHLD Character(1) VARCHAR2(1) NOT NULL Delay Withholding of Taxes

    Y/N Table Edit

    Default Value: N

    13 PNA_WA_RATIO Signed Number(12,10) DECIMAL(10,10) NOT NULL FLI/MLI Percent ratio for Washington