STATE_TAX_DATA

(SQL Table)
 Index Back

EE U.S. State Tax Data

This record is used to define an employee's status for state tax purposes. If an employee works in multiple states or lives in a state other than the state of employment, a record for each state must be maintained. A view W3PY_W4_STX_VW based on this record has been created for the purpose of WEB-enabled W4 update. Changes made to the record STATE_TAX_DATA would need to be analyzed and made to W3PY_W4_STX_VW, if necessary.

  • Parent record: FED_TAX_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: CO_STATETAX_TBL

    5 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident

    Y/N Table Edit

    Default Value: Y

    6 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed

    Y/N Table Edit

    Default Value: N

    7 SPECIAL_SWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special Tax Status
    A=Non-Resident Alien; Fed Rules
    E=Exempt
    G=Maintain gross
    N=None
    8 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status

    Prompt Table: SWT_MARSTAT_TBL

    9 SWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Withholding Allowances
    10 SWT_ADDL_ALLOWNCES Number(3,0) SMALLINT NOT NULL Additional Allowances
    11 WAGE_PLAN_CD Character(1) VARCHAR2(1) NOT NULL Wage Plan Code
    A=None/State
    J=State/Exempt
    L=Voluntary/Exempt
    P=None/None
    R=DI Exempt/State
    S=State/State
    U=Voluntary/State

    Default Value: S

    12 ANNL_EXEMPTION_AMT Number(5,0) INTEGER NOT NULL MS Annual Exemption Amount
    13 PERCENT_OF_FWT Number(6,3) DECIMAL(5,3) NOT NULL AZ Withholding Percent
    14 SWT_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Additional Amount
    15 SWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL SWT Additional Percentage
    16 SDI_STATUS Character(1) VARCHAR2(1) NOT NULL SDI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Disability Plan
    Y=Subject
    17 SUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt From SUT

    Y/N Table Edit

    Default Value: COMPANY_TBL.SUT_EXEMPT

    18 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction

    Y/N Table Edit

    Default Value: N

    19 ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Additional Amount Adjustment
    D=Decrease Additional Amount
    I=Increase Additional Amount

    Default Value: I

    20 WT4A_FILED Character(1) VARCHAR2(1) NOT NULL Designates that Form WT-4A has been filed to allow the addiitonal amount to be used as a standing Flat Tax Amount. As such, Reciprocity rules are enforced.

    Y/N Table Edit

    21 LOCK_IN_RECVD Character(1) VARCHAR2(1) NOT NULL Lock-In Letter Received

    Y/N Table Edit

    Default Value: N

    22 LOCK_IN_LIMIT Number(3,0) SMALLINT NOT NULL Limit On Allowances
    23 RETIREMENT_PLAN Character(1) VARCHAR2(1) NOT NULL PR Retirement Plan

    Y/N Table Edit

    Default Value: N

    24 EIC_STATUS_ST Character(1) VARCHAR2(1) NOT NULL Earned Income Credit

    Y/N Table Edit

    Default Value: N

    25 HLTH_COV_IND Character(1) VARCHAR2(1) NOT NULL VT Health Coverage Indicator
    A=Eligible/Accepted
    B=Eligible/Not Accepted/Covered
    C=Eligible/Not Accepted/No Cover
    D=Not Eligible
    N=Not Applicable
    S=Seasonal

    Default Value: N

    26 CREATION_DT Date(10) DATE Creation Date

    Default Value: %DATE

    27 PNA_FLI_STATUS Character(1) VARCHAR2(1) NOT NULL FLI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Plan
    Y=Subject

    Default Value: N

    28 RES_ADDL_ALLOW Number(3,0) SMALLINT NOT NULL Number of Qualifying Children