UPG_GPDE801_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EFFDT	Date(10)	DATE	Effective Date
4	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	GPDE_AE_COMMIT_OVD	Character(1)	VARCHAR2(1) NOT NULL	AE Commit Override Flag
9	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
12	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
16	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
17	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
18	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
19	GPDE_AB_ENTITLEMNT	Character(10)	VARCHAR2(10) NOT NULL	Entitlement Plan
20	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
21	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
22	GPDE_PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
23	GPDE_ER_DD_PER_WK	Number(1,0)	SMALLINT NOT NULL	Work Days per Week
24	AGE1	Number(3,0)	SMALLINT NOT NULL	Between Age
25	AGE2	Number(3,0)	SMALLINT NOT NULL	and Age
26	SERVICE_YEARS1	Number(3,0)	SMALLINT NOT NULL	Between Service Years
27	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
28	GPDE_GR_SEQ	Number(3,0)	SMALLINT NOT NULL	Garnishment Priority
29	GPDE_GR_RECEIVE_DT	DateTime(26)	TIMESTAMP	Garnishment Received Date
30	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
31	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
32	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
33	DESCRLONG	Long Character	CLOB	Long Description