GPJP_PAYSLIP_IDPrompt Table: GPJP_PP_TMPL
EFFDTDefault Value: %date
GPJP_POSITIONPrompt Table: GPJP_PP_POS
Prompt Table: GPJP_ENT_PP_VW
Prompt Table: %GP_EDIT_FLD1
GPJP_NRP_PPD_VW(SQL View) |
Index Back |
|---|---|
NRP: Pay Slip Template DetailTracks the definition of the pay slip template. |
| SELECT A.GPJP_PAYSLIP_ID , A.EFFDT , A.GPJP_POSITION , A.ENTRY_TYPE_ELEM , A.PIN_NUM + 50000000 , A.GPJP_HEADING FROM PS_GPJP_PP_DTL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPJP_PAYSLIP_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Assigns a unique ID to a template used to generate pay slips.
Prompt Table: GPJP_PP_TMPL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPJP_POSITION |
Character(6) | VARCHAR2(6) NOT NULL |
Tracks the position of an element on a pay slip. The first two digits indicate the section that the element is displayed, the next two indicate the row, and the last two indicate the column.
Prompt Table: GPJP_PP_POS |
| 4 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GPJP_ENT_PP_VW |
| 5 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 6 | GPJP_HEADING | Character(16) | VARCHAR2(16) NOT NULL | This value is displayed on the pay slip as the heading for the associated element. |