PY_SSP_MAXVN_VW

(SQL View)
 Index Back

Payslip Self Service

Payslip Self Service max version number

SELECT A.EMPLID , A.PYMT_DT , A.PAYCHECK_NBR , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.PY_PSLP_VER_NO , A.PY_SS_PSLP_STATUS , A.PY_SS_PSLP_PRV_STA FROM PS_PY_SS_PSLP_GDE A WHERE A.PY_PSLP_VER_NO = ( SELECT MAX(A1.PY_PSLP_VER_NO) FROM PS_PY_SS_PSLP_GDE A1 WHERE A.EMPLID = A1.EMPLID AND A.PYMT_DT = A1.PYMT_DT AND A.PAYCHECK_NBR = A1.PAYCHECK_NBR AND A.OFF_CYCLE = A1.OFF_CYCLE AND A.PAGE_NUM = A1.PAGE_NUM AND A.LINE_NUM = A1.LINE_NUM AND A.SEPCHK = A1.SEPCHK)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PYMT_DT Date(10) DATE NOT NULL Payment Date
3 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
8 PY_PSLP_VER_NO Number(3,0) SMALLINT NOT NULL The Payslip ID Version number

Default Value: 0

9 PY_SS_PSLP_STATUS Character(4) VARCHAR2(4) NOT NULL This status field is used to indicate in online Paycheck Self Service Payslips (ePay) the status of an online payslip.
ADJS=Adjustment
CHNG=Changed
DNDS=Do Not Display
ORIG=Original
10 PY_SS_PSLP_PRV_STA Character(4) VARCHAR2(4) NOT NULL This status field is used to indicate in online Paycheck Self Service Payslips (ePay) the status of an online payslip.
ADJS=Adjustment
CHNG=Changed
DNDS=Do Not Display
ORIG=Original