EOCF_TMIMPL_LVW (SQL View)	Index Back
Term Impl view Term Impl view

EOCF_TMIMPL_LVW

(SQL 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

#	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