HRS_SRCH_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	FILE_DIRECTORY	Character(80)	VARCHAR2(80) NOT NULL	File Directory
5	ER_PS_HOME	Character(80)	VARCHAR2(80) NOT NULL	PS Home
6	SEARCH_MODE	Character(1)	VARCHAR2(1) NOT NULL	Resume Search Collection C=Create New U=Update Existing
7	APP_DT_FROM	Date(10)	DATE	From Application Date
8	APP_DT_THROUGH	Date(10)	DATE	Through Application Date
9	HRS_SCH_IDX_NAME	Character(64)	VARCHAR2(64) NOT NULL	Collection Name
10	HRS_SEGMENT_SZ	Number(6,0)	INTEGER NOT NULL	Segment Size
11	ATTACH_ROOT_DIR	Character(100)	VARCHAR2(100) NOT NULL	Attachment Root Directory
12	RUN_COUNT	Number(2,0)	SMALLINT NOT NULL	Run count
13	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text