CAL_RUN_IDPrompt Table: GP_CAL_RUN_SRCH
GPSG_MSG_NBR10=All
20=Group Build
30=Group List
Prompt Table: GPSG_GROUP_VW
Prompt Table: GP_GRP_LIST_VW
GPSG_PSLP_MSG(SQL Table) |
Index Back |
|---|---|
GPSG - Payslip MsgsGP Singapore - Payslip 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: GP_CAL_RUN_SRCH |
| 2 | GPSG_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 | GPSG_MSG_LVL | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to identify the level of the message that will be used on the on-line and hard-copy payslips.
10=All 20=Group Build 30=Group List |
| 4 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GPSG_GROUP_VW |
| 5 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List ID
Prompt Table: GP_GRP_LIST_VW |
| 6 | GPSG_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | This field will be used to store the message that will be included on the on-line and hard-copy payslip |