GPDE_AL_01_MSG

(SQL Table)
Index Back

Pay Slip Messages

Pay Slip Messages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_AL_CPAY_ENDDT Date(10) DATE NOT NULL Current Pay End Date
2 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

Default Value: 1

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUSUNIT_HR_VW

9 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description