OPRIDRUN_CNTL_IDCAL_RUN_IDPrompt Table: GP_PSLP_CAL2_VW
EMPLIDPYMT_IDPrompt Table: GP_PYMT_ID_DEFN
PYMT_NBRPrompt Table: GP_PYMT_BNK_VW
MDFY=Modified
ORIG=Original
VDEL=Void Deleted
VDIS=Void Displayed
VHID=Void Hidden
10=Active
20=Inactive
GP_PSLP_RC_RNUM(SQL Table) |
Index Back |
|---|---|
Payment Renumbering PayslipsThis is a child run control record for Payment Renumbering process to call for payslips to be printed on new payments and to change the sattus of old payslips that contained the payment that was renumbered. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_PSLP_CAL2_VW |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | PYMT_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Payment Identification
Prompt Table: GP_PYMT_ID_DEFN |
| 6 | PYMT_NBR |
Number(18,0) | DECIMAL(18) NOT NULL |
Payment Number
Prompt Table: GP_PYMT_BNK_VW |
| 7 | PMT_GRP_ID | Number(3,0) | SMALLINT NOT NULL | Group Id for grouping payment |
| 8 | GP_PSLP_ID | Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
| 9 | 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 |
| 10 | GP_PSLP_GDE_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Payslip Guide Status
10=Active 20=Inactive |