EOSF_ADD_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
2	PORTAL_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
3	EOSF_SEARCH_ID	Character(65)	VARCHAR2(65) NOT NULL	Search ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
7	EOSF_FIELD_ORDER	Number(3,0)	SMALLINT NOT NULL	Criteria/Results Field Order
8	EOSF_SRCH_KEY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Search Key field flag
9	EOSF_USE_IN_ADD	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
10	EOSF_ADD_FLD_VISIB	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
11	EOSF_ADD_FLD_GREY	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
12	EOSF_ADD_ORDER	Number(1,0)	SMALLINT NOT NULL	Criteria/Results Field Order
13	EOSF_PRMP_EDITTYPE	Character(1)	VARCHAR2(1) NOT NULL	Promopt Edit Type 0=No Prompt Edit 1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No Default Value: 0
14	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table Prompt Table: PSRECDEFN
15	EOSF_DROPDOWN_DESC	Character(18)	VARCHAR2(18) NOT NULL	Description Field
16	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name Prompt Table: PSRECFIELDDB
17	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Set As Default N=No Y=Yes
18	EOSF_DEFAULT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Set As Default Y/N Table Edit Default Value: N
19	EOSF_DEF_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Default Field Name