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 |