EOCF_TERMCTX_VW(SQL View) |
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. |
| SELECT EOCF_LIB_TERM_ID , EOCF_CONTEXT_ID , EOCF_IMPL_ID , EOCF_IMPL_CATEGORY , EOCF_CACHE_OPT , EOCF_CTX_IMPL_TYPE , EOCF_CTXVAR_ALIAS , EOCF_CONTEXT_VAR , EOCF_EXTRACT_TYPE , EOCF_EXTRACT_TBL , EOCF_EXTRACT_FLD , EOCF_EXTRACT_POS FROM PS_EOCF_TERM_CTX WHERE EOCF_IMPL_CATEGORY = 'CON' |
| # | 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_VW |
| 3 | EOCF_IMPL_ID | Number(31,0) | DECIMAL(31) NOT NULL |
the ID value uniquely identifying a term implementation
Prompt Table: EOCF_TMIMPL_VW |
| 4 | EOCF_IMPL_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Data Library - Implementation Category, possible values are Default, Contextual
CON=Contextual DEF=Non-contextual Default Value: CON |
| 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 Default Value: T |
| 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 Default Value: SPI |
| 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
Prompt Table: EOCF_CTXVRN1_VW |
| 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 |