GPGB_PSPBS_NRAD(SQL Table) |
Index Back |
---|---|
Payslip Defn. -- BalancesUK Payslip Definition -- Balance Accumulators |
# | 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_ELEM2 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
7 | GPGB_PSLIP_DETAIL | Number(8,0) | INTEGER NOT NULL | Payslip detail Pin |
8 | GPGB_PIN_CODE_CUR | Character(21) | VARCHAR2(21) NOT NULL | Pin Code Current Value |
9 | GPGB_PIN_NUM_CUR | Number(8,0) | INTEGER NOT NULL | Pin Number Current Value |
10 | GPGB_PIN_CODE_YTD | Character(21) | VARCHAR2(21) NOT NULL | Pin Code Year to Date |
11 | GPGB_PIN_NUM_YTD | Number(8,0) | INTEGER NOT NULL | Pin Number Year to Date |
12 | GPGB_PSLIP_UK2_ALL | Character(1) | VARCHAR2(1) NOT NULL | Display All Occurences User K2 |
13 | GPGB_PSLIP_UK2_DIS | Character(1) | VARCHAR2(1) NOT NULL | Display User Key2 |