GPGB_PSLIP_BALS(SQL Table) |
Index Back |
---|---|
Payslip Defn. -- BalancesUK Payslip Definition -- Balance Accumulators |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(6) | VARCHAR2(6) NOT NULL |
Payslip ID
Default Value: GPGB Prompt Table: GPGB_PSLIP_HDR |
|
2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
3 | Number(6,0) | INTEGER NOT NULL |
Payslip Element Order
Default Value: 1 |
|
4 | GPGB_PSLIP_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Payslip Description |
5 | ENTRY_TYPE_ELEM2 | Character(3) | VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table: GP_ENT_USERK_VW |
6 | GPGB_PSLIP_DETAIL | Number(8,0) | INTEGER NOT NULL |
Payslip detail Pin
Prompt Table: %GP_EDIT_FLD3 |
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
Prompt Table: GP_PIN_AC0_VW |
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
Prompt Table: GP_PIN_AC0_VW |
11 | GPGB_PSLIP_UK2_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Display All Occurences User K2
Y/N Table Edit Default Value: N |
12 | GPGB_PSLIP_UK2_DIS | Character(1) | VARCHAR2(1) NOT NULL |
Display User Key2
Y/N Table Edit Default Value: N |