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 |