WRK_LCL_TAX_VW

(SQL View)
 Index Back

EE Worked Local Tax View

This view is used for ADP Connection to record employee tax data for each locality in which the employee works and for which tax withholding is required. Returns a row where there is a matching entry in TAX_DISTRIB and LOCAL_TAX_DATA. ADP Connection view used by ADP and not in export.

SELECT M.EMPLID ,C.COMPANY ,M.EFFDT ,C.STATE ,C.LOCALITY ,C.RESIDENT ,C.LWT_ALLOWANCES ,C.LWT_AMT ,C.LWT_PCT ,C.LOCALITY_LINK ,C.SPECIAL_LWT_STATUS ,C.LWT_MAR_STATUS ,M.DIST_PCT FROM PS_LOCAL_TAX_DATA C ,PS_TAX_DISTRIB M WHERE C.EMPLID = M.EMPLID AND M.EMPL_RCD=0 AND C.STATE = M.STATE AND C.LOCALITY = M.LOCALITY

  • Parent record: PERSONAL_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 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    6 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident
    7 LWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Local Withholding Allowances
    8 LWT_AMT Number(8,2) DECIMAL(7,2) NOT NULL Additional Amount
    9 LWT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Additional Percentage
    10 LOCALITY_LINK Character(10) VARCHAR2(10) NOT NULL Other Work Locality.
    11 SPECIAL_LWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special Tax Status
    E=Do not maintain Taxable Gross
    G=Maintain Tax Gross, LWT zero
    N=None
    12 LWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL LWT Marital/Tax Status
    13 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution