EOCF_TBIND_MAP

(SQL Table)
Index Back

DL - Term Bind Mapping

Data Library, Term Bind Mapping

# 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_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL the ID value for a configured context
3 EOCF_BIND_ORDERNUM Number(3,0) SMALLINT NOT NULL bind order number

Prompt Table: EOCF_IMPL_BINDS

4 EOCF_TMAP_BIND_SRC Character(3) VARCHAR2(3) NOT NULL Data Library - Bind Source, if Impl Category is Contextual then possible values are Technical, Constant, Context var and Functional. If Impl Category is Default then values are Technical, Constant, and Functional. Term Definition page has dynamic dropdown for the above.
CON=Constant
COV=System
FUN=User
TEC=System
5 EOCF_TMAP_ALIAS Character(30) VARCHAR2(30) NOT NULL Bind Map Alias field in the library, Alias field represents bind source type of Technical.
6 EOCF_TMAP_CTXVAR Number(5,0) INTEGER NOT NULL Mapped seqnum for CtxVar in the library, CtxVar field represents bind source type of Context variable.

Prompt Table: EOCF_CTX_VARSNW

7 EOCF_TMAP_FUNCVAR Number(5,0) INTEGER NOT NULL Mapped seqnum for Functional Variable in the library, FuncVar field represents bind source type of Functional.
8 EOCF_TMAP_VALUE Character(80) VARCHAR2(80) NOT NULL Bind Map value in the library, Value field represents bind source type of Constant.