CMP007_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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
6	FROMDATE	Date(10)	DATE	From Date
7	THRUDATE	Date(10)	DATE	End Date
8	DATE_TO	Date(10)	DATE	Previous Period Date To
9	EFFDT	Date(10)	DATE	Effective Date
10	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
11	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
12	NO_REVIEW	Character(1)	VARCHAR2(1) NOT NULL	Review Required
13	FROM_DT	Date(10)	DATE	From Date
14	THRU_DATE	Date(10)	DATE	Thru Date
15	BAL_ID_FOR_CAL_YR	Character(2)	VARCHAR2(2) NOT NULL	Balance ID for Calendar Year
16	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
18	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
19	JOB_EFFDT	Date(10)	DATE	Job Effective Date
20	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
21	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
22	INCREM_MONTHS	Number(3,0)	SMALLINT NOT NULL	Months to Next Step Increment
23	NEW_EFFDT	Date(10)	DATE	New Benefit Program Effdt
24	PROCESS_BY	Character(1)	VARCHAR2(1) NOT NULL	Used by the RUNCTL_SENPAY run control panel. A=All G=Group ID J=Jobcode L=Sal Admin Plan P=Paygroup R=Rate Code S=Sal Plan/Grade
25	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
26	ASOFDATE	Date(10)	DATE	As of Date
27	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number
28	UPD_FUTURE_ROW_SW	Character(1)	VARCHAR2(1) NOT NULL	Update Future Rows N=No Y=Yes
29	SP_INCREM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Plan Salaries, increment type D=Date Based E=Hours and Date Based H=Hours Based
30	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
31	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
32	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country