EOCF_LIB_TERM_IDDATE=Date
DTTM=Datetime
NUM=Number
OTHR=Other
REC=Record
RSET=Rowset
STR=String
TIME=Time
Default Value: STR
EOCF_TRMPR_VW(SQL View) |
Index Back |
|---|---|
Term defn prompt viewTerm defn prompt view |
| SELECT EOCF_LIB_TERM_ID , EOCF_LIB_TERM_NAME , EOCF_TERM_LABEL , EOCF_TERM_DATATYPE FROM PS_EOCF_TERM_DEFN WHERE EOCF_TERM_STATUS = '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_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library |
| 3 | EOCF_TERM_LABEL | Character(254) | VARCHAR2(254) NOT NULL | Term Label (display) field used in Term Definition |
| 4 | EOCF_TERM_DATATYPE | Character(4) | VARCHAR2(4) NOT NULL |
data library term return data type, possible values are scalar,composite
DATE=Date DTTM=Datetime NUM=Number OTHR=Other REC=Record RSET=Rowset STR=String TIME=Time Default Value: STR |