GPFR_PSPSK_NRVW(SQL View) |
Index Back |
|---|---|
Playslip keys NPR ViewPlayslip keys |
| SELECT GPFR_PAY_SLIP_ID , GPFR_PIN_NUM + 50000000 , GPFR_PYSL_SK1_AD , GPFR_PIN_NUM1 + 50000000 , GPFR_PYSL_SK2_AD , GPFR_PIN_NUM2 + 50000000 , GPFR_PYSL_SK3_AD , GPFR_PIN_NUM3 + 50000000 , GPFR_PYSL_SK4_AD , GPFR_PIN_NUM4 + 50000000 , GPFR_PYSL_SK5_AD FROM PS_GPFR_P_SLIP_SK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPFR_PAY_SLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Payslip ID |
| 2 | GPFR_PIN_NUM | Number(8,0) | INTEGER NOT NULL |
GPFR: YTD PIN
Prompt Table: GP_PIN_SY0PI_VW |
| 3 | GPFR_PYSL_SK1_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 1 Asending/Desending
ASC=Asending DESC=Desending |
| 4 | GPFR_PIN_NUM1 | Number(8,0) | INTEGER NOT NULL |
GPFR: Sort Key 2
Prompt Table: GP_PIN_SY0PI_VW |
| 5 | GPFR_PYSL_SK2_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 2 Asending/Desending
ASC=Asending DESC=Desending |
| 6 | GPFR_PIN_NUM2 | Number(8,0) | INTEGER NOT NULL |
GPFR: Sort Key 3
Prompt Table: GP_PIN_SY0PI_VW |
| 7 | GPFR_PYSL_SK3_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 3 Asending/Desending
ASC=Asending DESC=Desending |
| 8 | GPFR_PIN_NUM3 | Number(8,0) | INTEGER NOT NULL |
GPFR: Sort key 4
Prompt Table: GP_PIN_SY0PI_VW |
| 9 | GPFR_PYSL_SK4_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 4 Asending/Desending
ASC=Asending DESC=Desending |
| 10 | GPFR_PIN_NUM4 | Number(8,0) | INTEGER NOT NULL |
GPFR: Sort Key 5
Prompt Table: GP_PIN_SY0PI_VW |
| 11 | GPFR_PYSL_SK5_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 5 Asending/Desending
ASC=Asending DESC=Desending |