EOSF_ADVSRC_DEF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EOSF_SEARCH_ID	Character(65)	VARCHAR2(65) NOT NULL	Search ID
3	EOSF_SAVESRCH_CD	Character(30)	VARCHAR2(30) NOT NULL	Saved Search Code
4	EOSF_SRCH_FIELDNM1	Character(65)	VARCHAR2(65) NOT NULL	Field Name
5	EOSF_SRCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type E=Search S=Standard Search
6	EOSF_PREVIEW_YN	Character(1)	VARCHAR2(1) NOT NULL	Search Filter - value yes no Y/N Table Edit Default Value: N
7	EOSF_CRITERIA_ID	Number(2,0)	SMALLINT NOT NULL	Criteria ID
8	EOSF_SEARCH_OPER	Character(4)	VARCHAR2(4) NOT NULL	Search Filter operator BET=between BGN=begins with CT=contains EQ== GE=>= GT=> LE=<= LT=< NE=not = PH=having phrase
9	EOSF_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Search Filter - value
10	EOSF_NDVAL	Character(254)	VARCHAR2(254) NOT NULL	Search filter- value
11	EOSF_VALUE_PROMPT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt Prompt Table: %EDITTABLE2
12	EOSF_NDVAL_PROMPT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt Prompt Table: %EDITTABLE2
13	EOSF_VALUE_NEPRMT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt without Edit
14	EOSF_NDVAL_NEPRMT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt without edit
15	EOSF_VALUE_XLAT	Character(4)	VARCHAR2(4) NOT NULL	Search Filter - value xlat Prompt Table: EOSF_XLATPR_VW
16	EOSF_VALUE_YESNO	Character(1)	VARCHAR2(1) NOT NULL	Search Filter - value yes no N=No Y=Yes Default Value: Y
17	EOSF_VALUE_DATE	Date(10)	DATE	Search Filter - value date
18	EOSF_NDVAL_DATE	Date(10)	DATE	Search Filter - value date
19	EOSF_VALUE_TIME	Time(15)	TIMESTAMP	Search Filter - value time
20	EOSF_NDVAL_TIME	Time(15)	TIMESTAMP	Search Filter - value time