GPFR_PAY_SLIP_IDPrompt Table: GPFR_PAY_SLIP_H
GPFR_ELEMENT_ORDERPIN_NUMPrompt Table: GP_PIN
GPFR_SPSL_ED_VW(SQL View) |
Index Back |
|---|---|
GPFRA - Simplified PayslipGPFRA - Simplified Payslip - Non rules View |
| SELECT GPFR_PAY_SLIP_ID , GPFR_ELEMENT_ORDER , PIN_NUM + 50000000 , PIN_NM FROM PS_GPFR_SPSLP_ED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_PAY_SLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Payslip ID
Prompt Table: GPFR_PAY_SLIP_H |
| 2 | GPFR_ELEMENT_ORDER |
Number(9,2) | DECIMAL(8,2) NOT NULL | Print Order of the element in payslip |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GP_PIN |
| 4 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |