EOCF_ELEM_SUBJ (SQL Table)	Index Back
Terms in a Phrase Terms in a Phrase

EOCF_ELEM_SUBJ

(SQL Table)

Terms in a Phrase

# 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

2 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.

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

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

#	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
2	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.
3	EOCF_SUBJECT_ID	Number(31,0)	DECIMAL(31) NOT NULL	Library Subject Id
4	EOCF_ORDERNUM	Number(3,0)	SMALLINT NOT NULL	sequence number for line item rows