GP_SS_PSLP2_AET(SQL Table) |
Index Back |
|---|---|
temporary guide datatemporary guide data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | GP_PSLP_PROCNAME | Character(12) | VARCHAR2(12) NOT NULL |
ePay Procedure Name
COPY=Reprint Payslip Copy GEN=Generate Payslip RGEN=Regenerate Payslip RNUM=Renumber Payslip |
| 5 | GP_PSLP_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | This field is the job or process instance used internally by the processes in the Payslip Job Definition and ePay. |
| 6 | GP_PSLP_DATAINST | Number(10,0) | DECIMAL(10) NOT NULL | This field is the job instance used internally by the processes in the Payslip Job Definition |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 9 | GP_PSLP_SRCPRODUCT |
Character(6) | VARCHAR2(6) NOT NULL | Name of product providing payslips to ePay Payslip process. |
| 10 | GP_PSLP_ID |
Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
| 11 | PYMT_DT | Date(10) | DATE | Payment Date |
| 12 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 13 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 14 | NET_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Net Pay |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 17 | 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 |
| 18 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 19 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 20 | GP_PSLP_FILEURLID | Character(30) | VARCHAR2(30) NOT NULL | URL ID used to store and retrieve payslip pdfs. |
| 21 | GP_PSLP_BGNPGNBR | Number(8,0) | INTEGER NOT NULL | Begin page number of individual payslip in the large payslip PDF |
| 22 | GP_PSLP_ENDPGNBR | Number(8,0) | INTEGER NOT NULL | End page number of individual payslip in the large payslip PDF |
| 23 | GP_SS_PSLP_PRCACTN | Character(4) | VARCHAR2(4) NOT NULL |
ePay Payslip process action
DEL=Delete INS=Insert INSH=Insert Header UPD=Update |
| 24 | GP_SS_PSLP_TMPSTAT | Character(4) | VARCHAR2(4) NOT NULL |
Status of temporary data during self service payslip processing
ERRD=Error INSD=Inserted SPLT=Split UPDT=Updated |