FED_ST_TAX_VW

(SQL View)
 Index Back

EE U.S. Federal State Tax Vw

This record is used to record and maintain federal tax information that the system will use to calculate federal taxes for employees. The tax data is defined by company.

SELECT DISTINCT M.EMPLID ,M.EMPL_RCD ,M.EFFDT ,B.COMPANY ,B.EFFDT ,B.SPECIAL_FWT_STATUS ,B.FWT_MAR_STATUS ,B.FWT_ALLOWANCES ,B.FWT_ADDL_AMT ,B.FWT_ADDL_PCT ,B.FUT_EXEMPT ,B.EIC_STATUS ,B.STATUTORY_EE ,B.DECEASED ,B.PENSION_PLAN ,B.LEGAL_REP ,B.DEFERRED_COMP ,B.LAST_ACTION ,C.STATE ,C.SPECIAL_SWT_STATUS ,C.SWT_MAR_STATUS ,C.SWT_ALLOWANCES ,C.SWT_ADDL_ALLOWNCES ,C.SWT_ADDL_AMT ,C.SWT_ADDL_PCT ,C.ADDL_AMT_ADJ ,C.ANNL_EXEMPTION_AMT ,C.PERCENT_OF_FWT ,M.STATE ,D.SPECIAL_SWT_STATUS ,D.SWT_MAR_STATUS ,D.SWT_ALLOWANCES ,D.SWT_ADDL_ALLOWNCES ,D.SWT_ADDL_AMT ,D.SWT_ADDL_PCT ,D.ADDL_AMT_ADJ ,D.ANNL_EXEMPTION_AMT ,D.PERCENT_OF_FWT ,D.NON_RES_DECLARED ,D.UI_JURISDICTION ,D.WAGE_PLAN_CD ,D.SDI_STATUS ,D.SUT_EXEMPT ,M.DIST_PCT FROM PS_FED_TAX_DATA B ,PS_STATE_TAX_DATA C ,PS_STATE_TAX_DATA D ,PS_TAX_DISTRIB M WHERE C.EMPLID=B.EMPLID AND C.EFFDT=B.EFFDT AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_STATE_TAX_DATA CC WHERE CC.EMPLID = C.EMPLID) AND C.COMPANY=B.COMPANY AND C.RESIDENT='Y' AND D.EMPLID=B.EMPLID AND D.EFFDT=B.EFFDT AND D.COMPANY=B.COMPANY AND D.STATE IN ( SELECT K.STATE FROM PS_TAX_DISTRIB K WHERE K.EMPLID=D.EMPLID AND K.EFFDT = ( SELECT MAX(KK.EFFDT) FROM PS_TAX_DISTRIB KK WHERE K.EMPLID=KK.EMPLID AND K.EMPL_RCD=KK.EMPL_RCD)) AND M.EMPLID=D.EMPLID AND D.STATE = M.STATE AND M.EFFDT = ( SELECT MAX(MM.EFFDT) FROM PS_TAX_DISTRIB MM WHERE M.EMPLID = MM.EMPLID AND M.EMPL_RCD=MM.EMPL_RCD)

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 TAX_EFFDT Date(10) DATE Tax Effective Date
    6 SPECIAL_FWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special FWT Status
    A=Non-Resident Alien
    E=Exempt (not subject to FIT)
    G=Maintain gross (no tax WH)
    N=None
    7 FWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL FWT Marital Status
    M=Married
    S=Single
    8 FWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL FWT Allowances
    9 FWT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL FWT Additional Amount
    10 FWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL FWT Additional Percentage
    11 FUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from FUT
    12 EIC_STATUS Character(1) VARCHAR2(1) NOT NULL Earned Income Credit Status
    M=Married, both spouses filing
    N=Not applicable
    S=Single,or Head of Household
    U=Married without spouse filing
    13 STATUTORY_EE Character(1) VARCHAR2(1) NOT NULL Statutory Employee
    14 DECEASED Character(1) VARCHAR2(1) NOT NULL Deceased
    15 PENSION_PLAN Character(1) VARCHAR2(1) NOT NULL Retirement Plan
    16 LEGAL_REP Character(1) VARCHAR2(1) NOT NULL Legal Representative
    17 DEFERRED_COMP Character(1) VARCHAR2(1) NOT NULL Deferred Compensation
    18 LAST_ACTION Character(1) VARCHAR2(1) NOT NULL Last Action
    C=System
    D=Hire Process
    O=Online User
    S=Supplier Deduction File
    W=Employee Self Service User
    19 RES_STATE Character(6) VARCHAR2(6) NOT NULL Resident State
    20 RES_SWT_STATUS Character(1) VARCHAR2(1) NOT NULL Res State Withholding Status
    21 RES_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Res State Tax Calc Status
    22 RES_ALLOW Number(3,0) SMALLINT NOT NULL Resident State Allowances
    23 RES_ADDL_ALLOW Number(3,0) SMALLINT NOT NULL Res State Addl Allowances
    24 RES_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL Res State Addl Tax Amount
    25 RES_ADDL_PCT Signed Number(7,3) DECIMAL(5,3) NOT NULL Res State Addl Tax Percent
    26 RES_ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Res State Addl Amt Adjustment
    27 RES_EXEMPT_AMT Number(5,0) INTEGER NOT NULL Res State tax exempt Amt
    28 RES_PCT_FWT Signed Number(7,3) DECIMAL(5,3) NOT NULL Res State Tax Percent of FWT
    29 WRK_STATE Character(6) VARCHAR2(6) NOT NULL Payroll Work State
    30 WRK_SWT_STATUS Character(1) VARCHAR2(1) NOT NULL Work State Taxibility Status
    31 WRK_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Work State Tax Calc Status
    32 WRK_ALLOW Number(3,0) SMALLINT NOT NULL Work State SWT Allowance
    33 WRK_ADDL_ALLOW Number(3,0) SMALLINT NOT NULL Work State SWT Addl Allow
    34 WRK_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL Work State Addl Tax Amount
    35 WRK_ADDL_PCT Signed Number(7,3) DECIMAL(5,3) NOT NULL Work State Addl Tax Pct
    36 WRK_ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Wrk State Addl Amt Adjustment
    37 WRK_EXEMPT_AMT Number(5,0) INTEGER NOT NULL Work State Exemption Amount
    38 WRK_PCT_FWT Signed Number(7,3) DECIMAL(5,3) NOT NULL Work State Percent of FWT
    39 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed
    40 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction
    41 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
    42 SDI_STATUS Character(1) VARCHAR2(1) NOT NULL SDI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Disability Plan
    Y=Subject
    43 SUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt From SUT
    44 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution