GPGB_PSLIP_IDDefault Value: GPGB
Prompt Table: GPGB_PSLIP_HDR
EFFDTDefault Value: %date
GPGB_ELE_ORDERDefault Value: 1
Prompt Table: GP_PIN_AC0_VW
Prompt Table: GP_PIN_AC0_VW
GPGB_PSPBS_NRVW(SQL View) |
Index Back |
|---|---|
Payslip Defn. -- Bala NPR ViewUK Payslip Definition -- Balance Accumulators |
| SELECT GPGB_PSLIP_ID , EFFDT , GPGB_ELE_ORDER , GPGB_PSLIP_DESCR , ENTRY_TYPE_ELEM2 , GPGB_PSLIP_DETAIL , GPGB_PIN_CODE_CUR , GPGB_PIN_NUM_CUR + 50000000 , GPGB_PIN_CODE_YTD , GPGB_PIN_NUM_YTD + 50000000 , GPGB_PSLIP_UK2_ALL , GPGB_PSLIP_UK2_DIS FROM PS_GPGB_PSLIP_BALS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_PSLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Payslip ID
Default Value: GPGB Prompt Table: GPGB_PSLIP_HDR |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPGB_ELE_ORDER |
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 |
| 6 | GPGB_PSLIP_DETAIL | Number(8,0) | INTEGER NOT NULL | Payslip detail Pin |
| 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 |
| 12 | GPGB_PSLIP_UK2_DIS | Character(1) | VARCHAR2(1) NOT NULL | Display User Key2 |