JOBINSTANCEGP_PAYGROUPPrompt Table: GPFR_PAY_SLIP_H
A=Annex
B=Pay-slip
Default Value: B
10=Current and Deltas
20=Current and Adjustment
30=One Line
GPFR_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 | GPFR_PAY_SLIP_ID | Character(6) | VARCHAR2(6) NOT NULL |
Payslip ID
Prompt Table: GPFR_PAY_SLIP_H |
| 5 | GPFR_PYSL_B_A | Character(1) | VARCHAR2(1) NOT NULL |
Payslip or Annex
A=Annex B=Pay-slip Default Value: B |
| 6 | GPFR_ELEMENT_ORDER | Number(9,2) | DECIMAL(8,2) NOT NULL | Print Order of the element in payslip |
| 7 | GPFR_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
GPFR: Retro Type
10=Current and Deltas 20=Current and Adjustment 30=One Line |