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 | 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 | LANGUAGE_CD | 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 |