EOCF_TMIMPL_LVW

(SQL View)
Index Back

Term Impl view

Term 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

  • Related Language Record for EOCF_TMIMPL_VW
  • # 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