EMPLIDCAL_RUN_IDGP_PSLP_SRCPRODUCTGP_PSLP_IDPrompt Table: GP_RUN_TYPE
MDFY=Modified
ORIG=Original
VDEL=Void Deleted
VDIS=Void Displayed
VHID=Void Hidden
GP_SS_PSLP_GDVW(SQL View) |
Index Back |
|---|---|
Payslip Self ServicePayslip Self Service |
| SELECT EMPLID , CAL_RUN_ID , GP_PSLP_SRCPRODUCT , GP_PSLP_ID , PYMT_DT , PRD_END_DT , PRD_BGN_DT , NET_PAY , DESCR , RUN_TYPE , GP_SS_PSLP_STATUS , ATTACHSYSFILENAME , ATTACHUSERFILE , GP_PSLP_FILEURLID FROM PS_GP_SS_PSLP_GDE |
| # | 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
Prompt Table: GP_RUN_TYPE |
| 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. |