PY_W4_LOC_VW

(SQL View)
 Index Back

WEB-PayChk Rvw Pay Chk Summary

View created to support WEB-enabled Paycheck Review. It is based on the PAY_CHECK record. It contains the summary of the result of the payroll confirmation process.

SELECT A.EMPLID , A.COMPANY , B.STATE , B.LOCALITY , C.LOCALITY_NAME , B.RESIDENT , B.SPECIAL_LWT_STATUS , B.LWT_MAR_STATUS , B.LWT_ALLOWANCES , B.LWT_AMT , B.LWT_PCT FROM PS_FED_TAX_DATA A ,PS_LOCAL_TAX_DATA B , PS_LOCAL_TAX_TBL C, PS_STATE_TAX_DATA D WHERE A.EMPLID = B.EMPLID AND A.COMPANY = A.COMPANY AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_FED_TAX_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.COMPANY = A.COMPANY AND A1.EFFDT <= %CurrentDateIn) AND A.EFFDT = B.EFFDT AND B.STATE = C.STATE AND B.LOCALITY = C.LOCALITY AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_LOCAL_TAX_TBL C1 WHERE C1.STATE = C.STATE AND C1.LOCALITY = C.LOCALITY AND C1.EFF_STATUS = 'A' AND C1.EFFDT <= %CurrentDateIn) AND (C.TAX_CLASS = 'H' AND B.STATE <> 'NM') AND A.EMPLID = D.EMPLID AND A.COMPANY = D.COMPANY AND D.EMPLID = B.EMPLID AND D.COMPANY = B.COMPANY AND D.STATE = B.STATE AND D.EFFDT = A.EFFDT

  • Parent record: PAY_LINE

    • # 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 STATE Character(6) VARCHAR2(6) NOT NULL State
    4 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    5 LOCALITY_NAME Character(40) VARCHAR2(40) NOT NULL Locality Name
    6 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident
    7 SPECIAL_LWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special Tax Status
    E=No taxable gross; no tax taken
    G=Maintain taxable gross
    N=None
    8 LWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL LWT Marital/Tax Status
    9 LWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Local Withholding Allowances
    10 LWT_AMT Number(8,2) DECIMAL(7,2) NOT NULL Additional Amount
    11 LWT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Additional Percentage