GPGB_ELE_ORDERY/N Table Edit
Default Value: N
GPGB_PSLIP_BLVW(SQL View) |
Index Back |
|---|---|
UK Printed Payslips Bals defThis record is used in the printed payslips app engine process to hold the balanes definitions during the process. |
| SELECT GPGB_ELE_ORDER ,GPGB_PSLIP_DETAIL + 50000000 ,GPGB_PSLIP_DESCR ,GPGB_PIN_NUM_CUR + 50000000 ,GPGB_PIN_NUM_YTD + 50000000 ,GPGB_PSLIP_UK2_DIS FROM PS_GPGB_PSLIP_BL_D |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_ELE_ORDER |
Number(6,0) | INTEGER NOT NULL | Payslip Element Order |
| 2 | GPGB_PSLIP_DETAIL | Number(8,0) | INTEGER NOT NULL | Payslip detail Pin |
| 3 | GPGB_PSLIP_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Payslip Description |
| 4 | GPGB_PIN_NUM_CUR | Number(8,0) | INTEGER NOT NULL | Pin Number Current Value |
| 5 | GPGB_PIN_NUM_YTD | Number(8,0) | INTEGER NOT NULL | Pin Number Year to Date |
| 6 | GPGB_PSLIP_UK2_DIS | Character(1) | VARCHAR2(1) NOT NULL |
Display User Key2
Y/N Table Edit Default Value: N |