HR_EMRGBR_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	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	LIST_OPTION_BRA	Character(1)	VARCHAR2(1) NOT NULL	List Option 1=All Establishments & Employees 2=By Establishment ID 3=By Employee ID 4=Select Group ID 5=Select Pay Group 6=Hire Date 7=Changes Only
10	BEGIN_DT	Date(10)	DATE	Begin Date
11	END_DT	Date(10)	DATE	end date
12	CHG_DEP_BRA	Character(1)	VARCHAR2(1) NOT NULL	Report changes on department
13	CHG_EST_BRA	Character(1)	VARCHAR2(1) NOT NULL	Report changes on establishment
14	CHG_JOBCD_BRA	Character(1)	VARCHAR2(1) NOT NULL	Report changes on job code
15	CHG_JOBPOS_BRA	Character(1)	VARCHAR2(1) NOT NULL	Report changes on job position
16	CHG_SAL_BRA	Character(1)	VARCHAR2(1) NOT NULL	Report changes on salary
17	COMMENTS_OPT_BRA	Character(1)	VARCHAR2(1) NOT NULL	Comments Options => Employee Registry BRA 1=No Comments 2=Print Comments 3=Print Box 4=Print Comments and Box
18	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
19	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
20	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code