EOCF_TBIND_MAP(SQL Table) |
Index Back |
---|---|
DL - Term Bind MappingData 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. |