UPG_GP1_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
10	EMPL_RCD_ACUM	Number(3,0)	SMALLINT NOT NULL	Accumulator Empl record
11	ACM_FROM_DT	Date(10)	DATE	From Date
12	ACM_THRU_DT	Date(10)	DATE	Through Date
13	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
14	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
15	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
16	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
17	USER_KEY3	Character(25)	VARCHAR2(25) NOT NULL	User Key 3
18	USER_KEY4	Character(25)	VARCHAR2(25) NOT NULL	User Key 4
19	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number