EOCF_TERM_SR_VW (SQL View)	Index Back
Term search view CLAF Data Library term search view

EOCF_TERM_SR_VW

(SQL View)

Term search view

CLAF Data Library term search view

SELECT A.EOCF_LIB_TERM_ID , A.EOCF_LIB_TERM_NAME , A.EOCF_TERM_TYPE , A.EOCF_TERM_LABEL , A.EOCF_TERM_DATATYPE , A.EOCF_NUM_OF_VALUES , A.EOCF_DATA_SOURCE , A.EOCF_TERM_STATUS ,A.EOCF_IS_CFG_FLAG , A.EOCF_IS_SCALAR FROM PS_EOCF_TERM_DEFN A WHERE A.EOCF_TERM_STATUS = 'A'

Related Language Record: EOCF_TRM_SR_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_ELEMENT_ID Number(31,0) DECIMAL(31) NOT NULL a 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_TYPE Character(3) VARCHAR2(3) NOT NULL data library term type, possible values are constant,variable
CON=Constant
VAR=Variable

4 EOCF_TERM_LABEL Character(254) VARCHAR2(254) NOT NULL Term Label (display) field used in Term Definition

5 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

6 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
Default Value: 1

7 EOCF_DATA_SOURCE Character(4) VARCHAR2(4) NOT NULL which product line the source comes from
CRM=Customer Relationship Mgmt
EPM=Enterprise Performance Mgmt
FSM=Financial Services Mgmt
HCM=Human Capital Mgmg
SCM=Supply Chain Mgmt

8 EOCF_TERM_STATUS Character(1) VARCHAR2(1) NOT NULL data library term status, possible values are Active, Inactive, Under Construction
A=Active
I=Inactive
U=In Design
Default Value: U

9 EOCF_IS_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Do Actions of this Action Type need to be configured
Y/N Table Edit
Default Value: N

10 EOCF_IS_SCALAR Character(1) VARCHAR2(1) NOT NULL does this term resolve to a scalar value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_ELEMENT_ID	Number(31,0)	DECIMAL(31) NOT NULL	a 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_TYPE	Character(3)	VARCHAR2(3) NOT NULL	data library term type, possible values are constant,variable CON=Constant VAR=Variable
4	EOCF_TERM_LABEL	Character(254)	VARCHAR2(254) NOT NULL	Term Label (display) field used in Term Definition
5	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
6	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 Default Value: 1
7	EOCF_DATA_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	which product line the source comes from CRM=Customer Relationship Mgmt EPM=Enterprise Performance Mgmt FSM=Financial Services Mgmt HCM=Human Capital Mgmg SCM=Supply Chain Mgmt
8	EOCF_TERM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	data library term status, possible values are Active, Inactive, Under Construction A=Active I=Inactive U=In Design Default Value: U
9	EOCF_IS_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Do Actions of this Action Type need to be configured Y/N Table Edit Default Value: N
10	EOCF_IS_SCALAR	Character(1)	VARCHAR2(1) NOT NULL	does this term resolve to a scalar value