GP_CNTRY_PSLP_MSGPrompt Table: GP_PSLP_CTRY_VW
GP_PSLP_MSG_NBRGP_PSLP_MSG_ADD(SQL View) |
Index Back |
|---|---|
Payslip Messages Add ViewPayslip messages |
| SELECT GP_CNTRY_PSLP_MSG , GP_PSLP_MSG_NBR FROM PS_GP_PSLP_MSG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_CNTRY_PSLP_MSG |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_PSLP_CTRY_VW |
| 2 | GP_PSLP_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, |