EOCF_TERM_CTX(SQL Table) |
Index Back |
---|---|
DL Term Context linkdata 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 |