EMPLIDCAL_RUN_IDGP_PSLP_SRCPRODUCTGP_PSLP_IDMDFY=Modified
ORIG=Original
VDEL=Void Deleted
VDIS=Void Displayed
VHID=Void Hidden
GP_SS_PSLP_2_VW(SQL View) |
Index Back |
|---|---|
Select Slips for Self ServiceThis view will select Payslips from guide table that meet the availability by Run type 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_OPT1 B WHERE (A.GP_SS_PSLP_STATUS <> 'VHID' AND A.GP_SS_PSLP_STATUS <> 'VDEL') AND %DateDiff(A.PYMT_DT,%CurrentDateIn) >= B.GP_PSLP_BGNSSOVRD AND A.RUN_TYPE = B.RUN_TYPE AND (B.COUNTRY IN ( SELECT DISTINCT J.REG_REGION FROM PS_GP_PYGRP P , PS_JOB J , PS_GP_CAL_RUN_DTL D WHERE D.CAL_RUN_ID = A.CAL_RUN_ID AND J.EMPLID = A.EMPLID AND P.GP_PAYGROUP = J.GP_PAYGROUP AND P.PAY_ENTITY = D.PAY_ENTITY AND P.GP_PAYGROUP = D.GP_PAYGROUP) OR B.COUNTRY IN ( SELECT DISTINCT J1.REG_REGION FROM PS_GP_PYGRP P1 , PS_JOB J1 , PS_GP_CAL_RUN_OFF D1 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) ) |
| # | 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 |