RA_LB_TERM_VW (SQL View)	Index Back
Audience Builder Valid Terms Get Terms that are valid for use in Audience selection

RA_LB_TERM_VW

(SQL View)

Audience Builder Valid Terms

Get Terms that are valid for use in Audience selection

SELECT T.EOCF_LIB_TERM_ID , T.EOCF_TERM_LABEL , T.EOCF_TERM_DATATYPE , T.EOCF_NUM_OF_VALUES , I.EOCF_IMPL_DATATYPE , I.EOCF_IS_SCALAR , I.EOCF_RES_MTHD_ID FROM PS_EOCF_TERM_DEFN T , PS_EOCF_TERM_CTX C , PS_EOCF_IMPL_DEFN I , PS_EOCF_IMPL_BINDS B WHERE C.EOCF_LIB_TERM_ID = T.EOCF_LIB_TERM_ID AND I.EOCF_IMPL_ID = C.EOCF_IMPL_ID AND B.EOCF_IMPL_ID = I.EOCF_IMPL_ID AND T.EOCF_TERM_STATUS = 'A' AND T.EOCF_TERM_DATATYPE IN ('DATE' , 'NUM' , 'STR' , 'TIME') AND T.EOCF_IS_CFG_FLAG = 'N' AND C.EOCF_CONTEXT_ID = 154612147449783446587987034567 AND C.EOCF_IMPL_CATEGORY = 'CON' AND C.EOCF_CTX_IMPL_TYPE = 'SPI' AND I.EOCF_RES_MTHD_ID IN (3180647498188772678863246040443, 3456892517835652971661668040443) AND I.EOCF_IMPL_DATATYPE IN ('ADAT' , 'ANUM' , 'ASTR' , 'ATIM' , 'DATE' , 'NUM' , 'STR' , 'TIME') AND B.EOCF_BIND_DATATYPE = '00' AND B.EOCF_BIND_ORDERNUM = 1 AND NOT EXISTS ( SELECT 'X' FROM PS_EOCF_IMPL_BINDS B2 WHERE B2.EOCF_IMPL_ID = B.EOCF_IMPL_ID AND B2.EOCF_BIND_ORDERNUM <> 1)

Related Language Record: RA_LB_TERM_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_LIB_TERM_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_TERM_LABEL Character(254) VARCHAR2(254) NOT NULL Term Label (display) field used in Term Definition

3 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

4 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

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_IS_SCALAR Character(1) VARCHAR2(1) NOT NULL does this term resolve to a scalar value

7 EOCF_RES_MTHD_ID Number(31,0) DECIMAL(31) NOT NULL data library - resolution method id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_LIB_TERM_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_TERM_LABEL	Character(254)	VARCHAR2(254) NOT NULL	Term Label (display) field used in Term Definition
3	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
4	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
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_IS_SCALAR	Character(1)	VARCHAR2(1) NOT NULL	does this term resolve to a scalar value
7	EOCF_RES_MTHD_ID	Number(31,0)	DECIMAL(31) NOT NULL	data library - resolution method id