CAL_RUN_IDPrompt Table: GP_CAL_RUN_SRCH
GPIN_MSG_NBRA=All
G=Group Build
P=Payee List
Default Value: A
Prompt Table: GPIN_GROUP_VW
Prompt Table: GP_GRP_LIST_VW
GPIN_PSLP_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: GP_CAL_RUN_SRCH |
| 2 | GPIN_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 | GPIN_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.
A=All G=Group Build P=Payee List Default Value: A |
| 4 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GPIN_GROUP_VW |
| 5 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List ID
Prompt Table: GP_GRP_LIST_VW |
| 6 | GPIN_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 |