EOCF_LIB_TERM_IDEOCF_CONFIG_IDEOCF_TERM_SEQNUM00=Constant
01=Context Variable
EOCF_TERMCFG_VW(SQL View) |
Index Back |
|---|---|
Terms Bind ConfigurationFunctional bind configuration of terms. |
| SELECT A.EOCF_LIB_TERM_ID , A.EOCF_CONFIG_ID , A.EOCF_TERM_SEQNUM , A.EOCF_TCFG_CFGTYPE , A.EOCF_BINDPARM_TEXT , A.EOCF_CONTEXT_ID , A.EOCF_CONTEXT_VAR , A.EOCF_CTX_ALIAS FROM PS_EOCF_TERM_CFG A |
| # | 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_CONFIG_ID |
Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
| 3 | EOCF_TERM_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
| 4 | EOCF_TCFG_CFGTYPE | Character(2) | VARCHAR2(2) NOT NULL |
type of configured bind value -- context var or constant
00=Constant 01=Context Variable |
| 5 | EOCF_BINDPARM_TEXT | Character(254) | VARCHAR2(254) NOT NULL | the textual representation of a bind parameter |
| 6 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
| 7 | EOCF_CONTEXT_VAR | Number(3,0) | SMALLINT NOT NULL | seqnum for context variables |
| 8 | EOCF_CTX_ALIAS | Character(18) | VARCHAR2(18) NOT NULL | context variable alias |