EOCF_TERMD_LVW(SQL View) | 
Index Back | 
|---|---|
Term definition Rel LanguageCLAF Data Library term definition Related Language record | 
| SELECT EOCF_LIB_TERM_ID ,LANGUAGE_CD ,EOCF_LIB_TERM_NAME ,EOCF_TERM_LABEL ,DESCR50 ,DESCRLONG FROM PS_EOCF_TERMD_LNG | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework 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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | EOCF_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library | 
| 4 | EOCF_TERM_LABEL | Character(254) | VARCHAR2(254) NOT NULL | Term Label (display) field used in Term Definition | 
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 | 
| 6 | DESCRLONG | Long Character | CLOB | Long Description |