GP_PKG_IDGPFR_PAY_SLIP_IDGPFR_PYSL_B_AA=Annex
B=Pay-slip
GPFR_ELEMENT_ORDEREE=Employee Element
ER=Employer Element
TX=Description
10=Current and Deltas
20=Current and Adjustment
30=One Line
GPFR_PSLP1_NRAD(SQL Table) |
Index Back |
|---|---|
Payslip setup body (ern/ded)Setup for the body of the payslip (earnings or deductions) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPFR_PAY_SLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Payslip ID |
| 3 | GPFR_PYSL_B_A |
Character(1) | VARCHAR2(1) NOT NULL |
Payslip or Annex
A=Annex B=Pay-slip |
| 4 | GPFR_ELEMENT_ORDER |
Number(9,2) | DECIMAL(8,2) NOT NULL | Print Order of the element in payslip |
| 5 | GPFR_DESCR_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Source for the description of an element in payslip
EE=Employee Element ER=Employer Element TX=Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GPFR_PIN_NUM_EE | Number(8,0) | INTEGER NOT NULL | Employer PIN for Payslip |
| 8 | GPFR_PIN_TYPE_EE | Character(3) | VARCHAR2(3) NOT NULL | Element Type |
| 9 | GPFR_PIN_NUM_ER | Number(8,0) | INTEGER NOT NULL | Employer PIN for payslip |
| 10 | GPFR_PIN_TYPE_ER | Character(3) | VARCHAR2(3) NOT NULL | Element Type |
| 11 | GPFR_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
GPFR: Retro Type
10=Current and Deltas 20=Current and Adjustment 30=One Line |
| 12 | GPFR_DET_INSTANCES | Character(1) | VARCHAR2(1) NOT NULL | Show the different instances detailled in the payslip |
| 13 | GPFR_LINES_BEFORE | Number(2,0) | SMALLINT NOT NULL | Number of lines before the element in payslip |
| 14 | GPFR_LINES_AFTER | Number(2,0) | SMALLINT NOT NULL | Number of lines after the element in payslip |