EOCF_SUBTERM_VW (SQL View)	Index Back
DL SubjectTerm ID View Data Library Subject Term ID view

EOCF_SUBTERM_VW

(SQL View)

DL SubjectTerm ID View

Data Library Subject Term ID view

SELECT EOCF_ELEMENT_TYPE , EOCF_SUBJECT_ID ,EOCF_ELEMENT_ID , EOCF_ORDERNUM FROM PS_EOCF_ELEM_SUBJ WHERE EOCF_ELEMENT_TYPE = '01'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_ELEMENT_TYPE Character(2) VARCHAR2(2) NOT NULL element definition
01=Term
02=Phrase
Default Value: 01

2 EOCF_SUBJECT_ID Number(31,0) DECIMAL(31) NOT NULL Library Subject Id

3 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.
Prompt Table: EOCF_TERM_DEFN

4 EOCF_ORDERNUM Number(3,0) SMALLINT NOT NULL sequence number for line item rows
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_ELEMENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	element definition 01=Term 02=Phrase Default Value: 01
2	EOCF_SUBJECT_ID	Number(31,0)	DECIMAL(31) NOT NULL	Library Subject Id
3	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. Prompt Table: EOCF_TERM_DEFN
4	EOCF_ORDERNUM	Number(3,0)	SMALLINT NOT NULL	sequence number for line item rows Default Value: 0