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

EOCF_TMIMPL_VW

(SQL View)

Term Impl view

SELECT b.EOCF_TERM_DATATYPE , b.EOCF_NUM_OF_VALUES ,a.EOCF_IMPL_ID ,a.EOCF_IMPL_NAME , b.EOCF_IMPL_DATATYPE ,a.EOCF_RES_MTHD_ID , a.DESCR50 FROM PS_EOCF_IMPL_DEFN A , PS_EOCF_DTYPEXT_SY B WHERE B.EOCF_IMPL_DATATYPE = A.EOCF_IMPL_DATATYPE

Related Language Record: EOCF_TMIMPL_LVW

# 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 EOCF_IMPL_NAME Character(50) VARCHAR2(50) NOT NULL the name of the Implementation in the library

5 EOCF_IMPL_DATATYPE Character(4) VARCHAR2(4) NOT NULL data library IMPl return data type, possible values are scalar,composite
A2AN=Array2 of Any
ADAT=Date Array
ADTT=Datetime Array
ANUM=Number Array
ARAN=Array of Any
ASTR=String Array
ATIM=Time Array
DATE=Date
DTTM=Datetime
NUM=Number
OTHR=Other
REC=Record
RSET=Rowset
STR=String
TIME=Time

6 EOCF_RES_MTHD_ID Number(31,0) DECIMAL(31) NOT NULL data library - resolution method id
Prompt Table: EOCF_RES_METHD

7 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	EOCF_IMPL_NAME	Character(50)	VARCHAR2(50) NOT NULL	the name of the Implementation in the library
5	EOCF_IMPL_DATATYPE	Character(4)	VARCHAR2(4) NOT NULL	data library IMPl return data type, possible values are scalar,composite A2AN=Array2 of Any ADAT=Date Array ADTT=Datetime Array ANUM=Number Array ARAN=Array of Any ASTR=String Array ATIM=Time Array DATE=Date DTTM=Datetime NUM=Number OTHR=Other REC=Record RSET=Rowset STR=String TIME=Time
6	EOCF_RES_MTHD_ID	Number(31,0)	DECIMAL(31) NOT NULL	data library - resolution method id Prompt Table: EOCF_RES_METHD
7	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50