PSARCH_IDPSARCH_BATCHNUMEMPLIDCAL_RUN_IDGP_PSLP_SRCPRODUCTGP_PSLP_IDMDFY=Modified
ORIG=Original
VDEL=Void Deleted
VDIS=Void Displayed
VHID=Void Hidden
GP_SS_P_GDE_HST(SQL Table) |
Index Back |
|---|---|
Payslip Self ServicePayslip Self Service |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | GP_PSLP_SRCPRODUCT |
Character(6) | VARCHAR2(6) NOT NULL | Name of product providing payslips to ePay Payslip process. |
| 6 | GP_PSLP_ID |
Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
| 7 | PYMT_DT | Date(10) | DATE | Payment Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 10 | NET_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Net Pay |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 13 | 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 |
| 14 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 15 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 16 | GP_PSLP_FILEURLID | Character(30) | VARCHAR2(30) NOT NULL | URL ID used to store and retrieve payslip pdfs. |