GP_SS_PSLP_1_VW

(SQL View)
 Index Back

Slips for Self Service - DFLT

This view will select Payslips from guide table that meet the default availability setting in Payslip Options page

SELECT %subrec(GP_SS_PSLP_SBR, A) , COUNTRY B FROM PS_GP_SS_PSLP_GDE A , PS_GP_SS_PSLP_OPT B WHERE (A.GP_SS_PSLP_STATUS <> 'VHID' AND A.GP_SS_PSLP_STATUS <> 'VDEL') AND %DateDiff(A.PYMT_DT,%CurrentDateIn) >= B.GP_PSLP_BGNSSDFLT AND NOT EXISTS ( SELECT 'X' FROM PS_GP_SS_PSLP_OPT1 B2 WHERE B2.COUNTRY = B.COUNTRY AND B2.RUN_TYPE = A.RUN_TYPE) AND (B.COUNTRY IN ( SELECT DISTINCT R.COUNTRY FROM PS_GP_PYGRP P , PS_JOB J , PS_GP_CAL_RUN_DTL D ,PS_REG_REGION_TBL R WHERE D.CAL_RUN_ID = A.CAL_RUN_ID AND J.EMPLID = A.EMPLID AND P.GP_PAYGROUP = J.GP_PAYGROUP AND P.GP_PAYGROUP = D.GP_PAYGROUP AND J.REG_REGION = R.REG_REGION) OR B.COUNTRY IN ( SELECT DISTINCT R1.COUNTRY FROM PS_GP_PYGRP P1 , PS_JOB J1 , PS_GP_CAL_RUN_OFF D1 , PS_GP_PYENT E1 ,PS_REG_REGION_TBL R1 WHERE D1.CAL_RUN_ID = A.CAL_RUN_ID AND J1.EMPLID = A.EMPLID AND P1.GP_PAYGROUP = J1.GP_PAYGROUP AND P1.GP_PAYGROUP = D1.GP_PAYGROUP AND J1.REG_REGION = R1.REG_REGION)) AND NOT EXISTS ( SELECT 'Y' FROM PS_GP_SS_PSLP_2_VW G WHERE A.EMPLID = G.EMPLID AND A.CAL_RUN_ID = G.CAL_RUN_ID AND A.GP_PSLP_SRCPRODUCT = G.GP_PSLP_SRCPRODUCT AND A.GP_PSLP_ID = G.GP_PSLP_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 GP_PSLP_SRCPRODUCT Character(6) VARCHAR2(6) NOT NULL Name of product providing payslips to ePay Payslip process.
4 GP_PSLP_ID Character(40) VARCHAR2(40) NOT NULL Payslip Identifier
5 PYMT_DT Date(10) DATE Payment Date
6 PRD_END_DT Date(10) DATE Pay Period End Date
7 PRD_BGN_DT Date(10) DATE Period Begin Date
8 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
11 GP_SS_PSLP_STATUS Character(4) VARCHAR2(4) NOT NULL This status field is used to indicate in Global Payroll Self Service Payslips (ePay) the status of an online payslip for the purposes of changes such as those made for retro/reversals. The status is displayed in Self Service and depending upon the status may control payslip by payslip whether or not a payslip is visible in ePay.
MDFY=Modified
ORIG=Original
VDEL=Void Deleted
VDIS=Void Displayed
VHID=Void Hidden
12 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
13 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
14 GP_PSLP_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve payslip pdfs.
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country