GPNL_PSLIP_SKEY(SQL Table) |
Index Back |
|---|---|
Payslip keysPayslip keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPNL_PAYSLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Default Value: JOB Prompt Table: PSRECDEFN |
| 3 | GPNL_FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name Sort Key Definition
Prompt Table: GP_PSRECFIELDVW |
| 4 | GPNL_PYSL_SK_ORD1 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 1
ASC=Ascending DESC=Descending |
| 5 | GPNL_FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 2
Prompt Table: GP_PSRECFIELDVW |
| 6 | GPNL_PYSL_SK_ORD2 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 2
ASC=Ascending DESC=Descending |
| 7 | GPNL_FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 3
Prompt Table: GP_PSRECFIELDVW |
| 8 | GPNL_PYSL_SK_ORD3 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 3
ASC=Ascending DESC=Descending |
| 9 | GPNL_FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 4
Prompt Table: GP_PSRECFIELDVW |
| 10 | GPNL_PYSL_SK_ORD4 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 4
ASC=Ascending DESC=Descending |
| 11 | GPNL_FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 5
Prompt Table: GP_PSRECFIELDVW |
| 12 | GPNL_PYSL_SK_ORD5 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 5
ASC=Ascending DESC=Descending |