GP_PKG_IDGPGB_PSLIP_IDEFFDTGPGB_ELE_ORDERGPGB_PSPNI_NRAD(SQL Table) |
Index Back |
|---|---|
Payslip Definition -- NIUK Payslip Definition -- National Insurance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPGB_PSLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Payslip ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GPGB_ELE_ORDER |
Number(6,0) | INTEGER NOT NULL | Payslip Element Order |
| 5 | GPGB_PSLIP_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Payslip Description |
| 6 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 7 | GPGB_PIN_CODE_CUR | Character(21) | VARCHAR2(21) NOT NULL | Pin Code Current Value |
| 8 | GPGB_PIN_NUM_CUR | Number(8,0) | INTEGER NOT NULL | Pin Number Current Value |
| 9 | GPGB_PIN_CODE_YTD | Character(21) | VARCHAR2(21) NOT NULL | Pin Code Year to Date |
| 10 | GPGB_PIN_NUM_YTD | Number(8,0) | INTEGER NOT NULL | Pin Number Year to Date |