GPGB_PSLIP_SECTIONGPGB_ELE_ORDERGPGB_PSLIP_EDVW(SQL View) |
Index Back |
|---|---|
UK Printed Payslips Earn defThis record is used in the printed payslips app engine process to hold the earnings definitions during the process. |
| SELECT GPGB_PSLIP_SECTION ,GPGB_ELE_ORDER ,GPGB_PSLIP_DETAIL + 50000000 ,GPGB_PSLIP_DESCR ,GPGB_PIN_NUM_CUR + 50000000 ,GPGB_PIN_NUM_YTD + 50000000 FROM PS_GPGB_PSLIP_ED_D |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_PSLIP_SECTION |
Character(3) | VARCHAR2(3) NOT NULL | Printed Payslips Section identifier |
| 2 | GPGB_ELE_ORDER |
Number(6,0) | INTEGER NOT NULL | Payslip Element Order |
| 3 | GPGB_PSLIP_DETAIL | Number(8,0) | INTEGER NOT NULL | Payslip detail Pin |
| 4 | GPGB_PSLIP_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Payslip Description |
| 5 | GPGB_PIN_NUM_CUR | Number(8,0) | INTEGER NOT NULL | Pin Number Current Value |
| 6 | GPGB_PIN_NUM_YTD | Number(8,0) | INTEGER NOT NULL | Pin Number Year to Date |