EOCF_ELEMENT_TYPE01=Term
02=Phrase
Default Value: 01
EOCF_HIERARCHY_ID0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
EOCF_ELEM_HIER(SQL Table) |
Index Back |
|---|---|
Element HeirarchyElement Heirarchy Refernec table |
| # | 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_HIERARCHY_ID |
Number(31,0) | DECIMAL(31) NOT NULL | EOCF subject area hierarchy |
| 3 | EOCF_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer Default Value: 2 |
| 4 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |