EOCF_CTXVARN_VW

(SQL View)
 Index Back

context variable VIEW

This is prompt view used in Term defn page for prompting term bind mapping if bind source is system. context variable definition

SELECT EOCF_CONTEXT_ID , EOCF_CONTEXT_VAR , EOCF_CTX_ALIAS , EOCF_BIND_DATATYPE , EOCF_CTX_PARENTVAR , EOCF_CTX_VAR_TYPE , EOCF_CTX_CONSTANT , EOCF_LIB_TERM_ID , EOCF_SUBJECT_ID , EOCF_CTX_FLD_LVL , EOCF_CTX_FLD_REC , EOCF_CTX_FLD_FIELD , EOCF_CTX_SCROLL , EOCF_LOG_FLG , EOCF_COMPFLD_TYPE FROM PS_EOCF_CTX_VARSNW WHERE EOCF_COMPFLD_TYPE <> '1' AND EOCF_COMPFLD_TYPE <> '2'

  • Related Language Record: EOCF_CTXVRN_LVW

    • # 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