EOCF_CTX_VARSNW

(SQL Table)
Index Back

context variable

context variable definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOCF_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework ID value for a configured context
2 EOCF_CONTEXT_VAR Number(3,0) SMALLINT NOT NULL Active Analytics Framework sequence number for context variables
3 EOCF_CTX_ALIAS Character(18) VARCHAR2(18) NOT NULL context variable alias
4 EOCF_BIND_DATATYPE Character(2) VARCHAR2(2) NOT NULL the type of SCALAR parameter that can be fed to a bind variable.
00=Number
01=String
02=Date
03=Datetime
04=Time
05=Object
5 EOCF_CTX_PARENTVAR Number(3,0) SMALLINT NOT NULL context variable parent field
6 EOCF_CTX_VAR_TYPE Character(4) VARCHAR2(4) NOT NULL context variable type
CVAL=Constant Value
PAGE=Online Page Variable
TERM=Term
7 EOCF_CTX_CONSTANT Character(50) VARCHAR2(50) NOT NULL constant values for constant context variables
8 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework 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

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

Prompt Table: EOCF_SUBJECT

10 EOCF_CTX_FLD_LVL Number(1,0) SMALLINT NOT NULL Field Level
11 EOCF_CTX_FLD_REC Character(18) VARCHAR2(18) NOT NULL scroll record for level one of context variables
12 EOCF_CTX_FLD_FIELD Character(18) VARCHAR2(18) NOT NULL scroll record for level one of context variables
13 EOCF_CTX_SCROLL Character(100) VARCHAR2(100) NOT NULL EOCF - This field is used in context definition page.
14 EOCF_LOG_FLG Character(1) VARCHAR2(1) NOT NULL L0Key

Y/N Table Edit

Default Value: N

15 EOCF_COMPFLD_TYPE Character(1) VARCHAR2(1) NOT NULL Component Field Type - Rowset/Record/Field
1=Rowset
2=Record
3=Field