CAL_RUN_IDPrompt Table: GPNL_PSLIP_R_VW
GPNL_MSG_NBRPrompt Table: GPNL_PYGRP_VW
Prompt Table: GPNL_PYENT_VW
Prompt Table: SETID_TBL
Prompt Table: DEPT_TBL
Prompt Table: PERS_SRCH_GBL
GPNL_PSLIP_MSG(SQL Table) |
Index Back |
|---|---|
Payslip MessagesPayslip messages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPNL_PSLIP_R_VW |
| 2 | GPNL_MSG_NBR |
Number(5,0) | INTEGER NOT NULL | This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips, |
| 3 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GPNL_PYGRP_VW |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GPNL_PYENT_VW |
| 5 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department Set ID
Prompt Table: SETID_TBL |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 8 | GPNL_MSGTEXT | Character(100) | VARCHAR2(100) NOT NULL | Payslip Message definition |