HR_SPLIB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	SP_PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
10	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
11	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
12	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
13	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
14	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
15	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
16	STEP	Number(2,0)	SMALLINT NOT NULL	Step
17	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
18	BUDGET_START_DT	Date(10)	DATE	Budget Period Start Date
19	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
20	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
21	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
22	RECORD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Record Name
23	CMP_DONT_ABSORB	Character(1)	VARCHAR2(1) NOT NULL	Don't Absorb Changes N=No Y=Yes
24	UPD_FUTURE_ROW_SW	Character(1)	VARCHAR2(1) NOT NULL	Update Future Rows N=No Y=Yes
25	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name