GP_PKG_IDGPFR_PAY_SLIP_IDASC=Asending
DESC=Desending
ASC=Asending
DESC=Desending
ASC=Asending
DESC=Desending
ASC=Asending
DESC=Desending
ASC=Asending
DESC=Desending
GPFR_PSPSK_NRAD(SQL Table) |
Index Back |
|---|---|
Playslip keysPlayslip keys |
| # | 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 | GPFR_PAY_SLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Payslip ID |
| 3 | GPFR_PIN_NUM | Number(8,0) | INTEGER NOT NULL | GPFR: YTD PIN |
| 4 | GPFR_PYSL_SK1_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 1 Asending/Desending
ASC=Asending DESC=Desending |
| 5 | GPFR_PIN_NUM1 | Number(8,0) | INTEGER NOT NULL | GPFR: Sort Key 2 |
| 6 | GPFR_PYSL_SK2_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 2 Asending/Desending
ASC=Asending DESC=Desending |
| 7 | GPFR_PIN_NUM2 | Number(8,0) | INTEGER NOT NULL | GPFR: Sort Key 3 |
| 8 | GPFR_PYSL_SK3_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 3 Asending/Desending
ASC=Asending DESC=Desending |
| 9 | GPFR_PIN_NUM3 | Number(8,0) | INTEGER NOT NULL | GPFR: Sort key 4 |
| 10 | GPFR_PYSL_SK4_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 4 Asending/Desending
ASC=Asending DESC=Desending |
| 11 | GPFR_PIN_NUM4 | Number(8,0) | INTEGER NOT NULL | GPFR: Sort Key 5 |
| 12 | GPFR_PYSL_SK5_AD | Character(4) | VARCHAR2(4) NOT NULL |
GPFR: SK 5 Asending/Desending
ASC=Asending DESC=Desending |