EOCF_TMIMPL_LVW(SQL View) |
Index Back |
---|---|
Term Impl viewTerm Impl view |
SELECT b.EOCF_TERM_DATATYPE , b.EOCF_NUM_OF_VALUES ,a.EOCF_IMPL_ID , a.LANGUAGE_CD ,a.EOCF_IMPL_NAME , a.DESCR50 FROM PS_EOCF_IMPDEN_LNG A , PS_EOCF_DTYPEXT_SY B , PS_EOCF_IMPL_DEFN C WHERE B.EOCF_IMPL_DATATYPE = C.EOCF_IMPL_DATATYPE AND A.EOCF_IMPL_ID = C.EOCF_IMPL_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | EOCF_NUM_OF_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
Data Library - This field would identify whether a term would return a list of values or single value.
1=One 2=Many |
3 | EOCF_IMPL_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value uniquely identifying a term implementation |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | EOCF_IMPL_NAME | Character(50) | VARCHAR2(50) NOT NULL | the name of the Implementation in the library |
6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |