PY_SSP_PYCHK_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 DISTINCT GVW.PY_SSP_BURST_VALUE , A.EMPLID , A.PAY_END_DT , A.PAYCHECK_NBR , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.NET_PAY FROM PS_PY_SS_PSLP_GDE GVW , PS_PAY_CHECK A WHERE GVW.OFF_CYCLE NOT IN ('N', 'Y') AND GVW.PAGE_NUM = 0 AND GVW.LINE_NUM = 0 AND A.EMPLID = GVW.EMPLID AND A.PAYCHECK_NBR = GVW.PAYCHECK_NBR AND A.PAY_END_DT = GVW.PRD_END_DT AND A.OFF_CYCLE IN ('N', 'Y') AND A.PAYCHECK_STATUS = 'F' AND A.PAYCHECK_OPTION IN ('C', 'A', '&', 'M') AND A.NET_PAY = GVW.NET_PAY

  • Parent record: PAY_LINE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_SSP_BURST_VALUE Character(40) VARCHAR2(40) NOT NULL This field can be use to identify individual self service paychecks
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 PAY_END_DT Date(10) DATE Pay Period End Date
    4 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    5 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    6 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    7 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay