EOCF_TERM_BINDS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_LIB_TERM_ID	Number(31,0)	DECIMAL(31) NOT NULL	a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
2	EOCF_SEQNUM	Number(3,0)	SMALLINT NOT NULL	sequence number for line item rows Default Value: 1
3	EOCF_USER_BINDS	Character(30)	VARCHAR2(30) NOT NULL	the name of a specific bind parameter
4	EOCF_BIND_DATATYPE	Character(2)	VARCHAR2(2) NOT NULL	the type of SCALAR parameter that can be fed to a bind variable. 00=Number 01=String 02=Date 03=Datetime 04=Time 05=Object
5	EOCF_PROMPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data library - prompt type, Possible values are Prompt Edit, Translate, Dropdown and Custom. This field would be used to specify prompt table details, if any, for the term, bind, so that end users would be able to select valid values to fill in functional binds at rule/phrase design time. Custom prompt type would be used to specify a custom app class when the prompt list has to be constrained by user specified filters. 1=Prompt With Edit 2=Translate Table 3=Dropdown List 4=Custom Prompt
6	EOCF_IS_SETID	Character(1)	VARCHAR2(1) NOT NULL	data library - is setid
7	EOCF_PROMPT_TBL	Character(15)	VARCHAR2(15) NOT NULL	DATA LIBRARY - Prompt Table Prompt Table: EOCF_SQLTBL_VW
8	EOCF_PROMPT_FLD	Character(18)	VARCHAR2(18) NOT NULL	Data Library, Name of the Prompt field/translate field Prompt Table: %EDITTABLE
9	EOCF_PROMPT_OPTFLD	Character(18)	VARCHAR2(18) NOT NULL	Data Library, Name of the Prompt field/translate field Prompt Table: %EDITTABLE
10	EOCF_APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	data library - aplication class id Prompt Table: EOCF_APPCLAS_VW
11	EOCF_APPCLASS_PATH	Character(167)	VARCHAR2(167) NOT NULL	Application Class Full Path Prompt Table: EOCF_APPPATH_VW