EOCF_TBINDDEFVW (SQL View)	Index Back
DL - Term Bind Mapping Data Library, Term Bind Mapping

EOCF_TBINDDEFVW

(SQL View)

DL - Term Bind Mapping

Data Library, Term Bind Mapping

SELECT EOCF_LIB_TERM_ID , EOCF_CONTEXT_ID , EOCF_BIND_ORDERNUM , EOCF_TMAP_BIND_SRC , EOCF_TMAP_ALIAS , EOCF_TMAP_CTXVAR , EOCF_TMAP_FUNCVAR , EOCF_TMAP_VALUE FROM PS_EOCF_TBIND_MAP WHERE EOCF_CONTEXT_ID = 1

# 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.
Prompt Table: EOCF_CXALIAS_VW

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.

#	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. Prompt Table: EOCF_CXALIAS_VW
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.