EOCF_CTX_IMPDTL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BCSCROLLNAME Character(60) VARCHAR2(60) NOT NULL Scroll name
2 EOCF_CTX_SCROLL Character(100) VARCHAR2(100) NOT NULL EOCF - This field is used in context definition page.
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
6 EOCF_COMPFLD_TYPE Character(1) VARCHAR2(1) NOT NULL Component Field Type - Rowset/Record/Field
1=Rowset
2=Record
3=Field
7 EOCF_PICK_FIELD Character(1) VARCHAR2(1) NOT NULL Select Component Field
8 EOCF_CTX_FIELD_FLG Character(1) VARCHAR2(1) NOT NULL Context Field

Y/N Table Edit

Default Value: Y

9 EOCF_LOG_FLG Character(1) VARCHAR2(1) NOT NULL L0Key

Y/N Table Edit

10 EOCF_CTX_ALIAS Character(18) VARCHAR2(18) NOT NULL context variable alias
11 EOCF_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL the ID value for a configured context
12 EOCF_SUBJECT_ID Number(31,0) DECIMAL(31) NOT NULL Library Subject Id

Prompt Table: EOCF_SUBJECT

13 EOCF_SUBJECT_NAME Character(30) VARCHAR2(30) NOT NULL the name of the subject under which things are filed in the library
14 EOCF_CTX_TERM_OPTN Character(1) VARCHAR2(1) NOT NULL Options for creating terms from Context Import
0=None
1=Create NewTerm
2=Modify Existing Term

Default Value: 1

15 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: %EDITTABLE

16 EOCF_LIB_TERM_NAME Character(80) VARCHAR2(80) NOT NULL the name of the Term in the library
17 SHOW_ITEM_DTL_PB Character(1) VARCHAR2(1) NOT NULL Show Item Details
18 TREECTLEVENT Character(46) VARCHAR2(46) NOT NULL Tree Control Event