GPES_PSLIP_SKEY

(SQL Table)
Index Back

Payslip keys

Payslip 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