EOCF_TRMPR_VW (SQL View)	Index Back
Term defn prompt view Term defn prompt view

EOCF_TRMPR_VW

(SQL View)

Term 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'

Related Language Record: EOCF_TRMPR_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_LIB_TERM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Active Analytics Framework 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