GPES_PSLIP_SKEY(SQL Table) |
Index Back |
|---|---|
Payslip keysPayslip keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPES_PAYSLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | GPES_FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL |
Payslip order by field name #1
Prompt Table: GP_PSRECFIELDVW |
| 5 | GPES_PYSL_SK_ORD1 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 1
ASC=Ascending DESC=Descending |
| 6 | GPES_FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL |
Payslip order by field name #2
Prompt Table: GP_PSRECFIELDVW |
| 7 | GPES_PYSL_SK_ORD2 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 2
ASC=Ascending DESC=Descending |
| 8 | GPES_FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL |
Payslip order by field name #3
Prompt Table: GP_PSRECFIELDVW |
| 9 | GPES_PYSL_SK_ORD3 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 3
ASC=Ascending DESC=Descending |
| 10 | GPES_FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL |
Payslip order by field name #4
Prompt Table: GP_PSRECFIELDVW |
| 11 | GPES_PYSL_SK_ORD4 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 4
ASC=Ascending DESC=Descending |
| 12 | GPES_FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL |
Payslip order by field name #5
Prompt Table: GP_PSRECFIELDVW |
| 13 | GPES_PYSL_SK_ORD5 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 5
ASC=Ascending DESC=Descending |