EOCF_TERM_CTX

(SQL Table)
Index Back

DL Term Context link

data library - Term - Context link table, this table also specify data extraction parameters that belongs to the Term context level.

# 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

Prompt Table: EOCF_CONTEXT

3 EOCF_IMPL_ID Number(31,0) DECIMAL(31) NOT NULL the ID value uniquely identifying a term implementation

Prompt Table: EOCF_IMPL_DEFN

4 EOCF_IMPL_CATEGORY Character(3) VARCHAR2(3) NOT NULL Data Library - Implementation Category, possible values are Default, Contextual
CON=Contextual
DEF=Non-contextual
5 EOCF_CACHE_OPT Character(1) VARCHAR2(1) NOT NULL data library term status, possible values are Active, Inactive, Under Construction
C=Component
G=Global
N=Do not cache
T=Trigger Point
6 EOCF_CTX_IMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Data Library - Context-Implementation Type, possiblr values are Specialized Implementation, Context Variable
CTX=Context Variable
SPI=Implementation
7 EOCF_CTXVAR_ALIAS Character(30) VARCHAR2(30) NOT NULL Context Variable Mapped Alias field in the library.

Prompt Table: EOCF_CTX_VARSNW

8 EOCF_CONTEXT_VAR Number(3,0) SMALLINT NOT NULL seqnum for context variables
9 EOCF_EXTRACT_TYPE Character(2) VARCHAR2(2) NOT NULL Data Extraction Parms Type
01=None
02=Record.Field
03=Field
04=Position
05=Record
10 EOCF_EXTRACT_TBL Character(15) VARCHAR2(15) NOT NULL DATA LIBRARY - Data Extraction Table

Prompt Table: EOCF_SQLTBL_VW

11 EOCF_EXTRACT_FLD Character(18) VARCHAR2(18) NOT NULL Data Library, Name of the data extraction field

Prompt Table: %EDITTABLE

12 EOCF_EXTRACT_POS Number(3,0) SMALLINT NOT NULL data library - data extraction position field