JOBINSTANCEGP_PAYGROUP10=Current and Deltas
20=Current and Adjustment
30=One Line
Default Value: 30
GPNL_PS_PIN_TMP(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 | JOBINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 4 | GPNL_PAYSLIP_ID | Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
| 5 | GPNL_PIN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Element Type |
| 6 | GPNL_ELEMENT_ORD | Number(9,2) | DECIMAL(8,2) NOT NULL | Print Order of the element in payslip |
| 7 | GPNL_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Retro Type
10=Current and Deltas 20=Current and Adjustment 30=One Line Default Value: 30 |