WRK_ST_TAX_VW

(SQL View)
 Index Back

EE U.S. State Tax Data

Used for ADP Connection for Worked and Other State Tax Records.

SELECT A.EMPLID ,A.COMPANY ,A.EFFDT ,A.STATE ,A.RESIDENT ,A.NON_RES_DECLARED ,A.SPECIAL_SWT_STATUS ,A.SWT_MAR_STATUS ,A.SWT_ALLOWANCES ,A.SWT_ADDL_ALLOWNCES ,A.WAGE_PLAN_CD ,A.ANNL_EXEMPTION_AMT ,A.PERCENT_OF_FWT ,A.SWT_ADDL_AMT ,A.SWT_ADDL_PCT ,A.SDI_STATUS ,A.SUT_EXEMPT ,A.UI_JURISDICTION ,A.ADDL_AMT_ADJ ,A.LOCK_IN_RECVD ,A.LOCK_IN_LIMIT ,M.DIST_PCT FROM PS_STATE_TAX_DATA A ,PS_TAX_DISTRIB M WHERE A.EMPLID = M.EMPLID AND M.EMPL_RCD=0 AND A.STATE = M.STATE AND M.LOCALITY = ' '

  • 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
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 EFFDT Date(10) DATE Effective Date
    4 STATE Character(6) VARCHAR2(6) NOT NULL State
    5 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident
    6 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed
    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
    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
    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
    18 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction
    19 ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Additional Amount Adjustment
    D=Decrease Additional Amount
    I=Increase Additional Amount
    20 LOCK_IN_RECVD Character(1) VARCHAR2(1) NOT NULL Lock-In Letter Received
    21 LOCK_IN_LIMIT Number(3,0) SMALLINT NOT NULL Limit On Allowances
    22 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution