EOCF_CTXVRN1_VW

(SQL View)
 Index Back

context variable

VIEW showing context variable definition with term name. it uses the left outer join.

SELECT A.EOCF_CONTEXT_ID , A.EOCF_CONTEXT_VAR ,A.EOCF_CTX_ALIAS ,A.EOCF_CTX_VAR_TYPE ,A.EOCF_BIND_DATATYPE ,A.EOCF_CTX_FLD_LVL , A.EOCF_CTX_SCROLL , B.EOCF_LIB_TERM_NAME ,A.EOCF_CTX_CONSTANT ,A.EOCF_COMPFLD_TYPE FROM PS_EOCF_CTX_VARSNW A ,PS_EOCF_TERM_DEFN B WHERE B.EOCF_LIB_TERM_ID (+) = A.EOCF_LIB_TERM_ID

  • Related Language Record: EOCF_CTXVR1_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL the ID value for a configured context
    2 EOCF_CONTEXT_VAR Number(3,0) SMALLINT NOT NULL seqnum for context variables
    3 EOCF_CTX_ALIAS Character(18) VARCHAR2(18) NOT NULL context variable alias
    4 EOCF_CTX_VAR_TYPE Character(4) VARCHAR2(4) NOT NULL context variable type
    CVAL=Constant Value
    PAGE=Online Page Variable
    TERM=Term
    5 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
    6 EOCF_CTX_FLD_LVL Number(1,0) SMALLINT NOT NULL Field Level
    7 EOCF_CTX_SCROLL Character(100) VARCHAR2(100) NOT NULL EOCF - This field is used in context definition page.
    8 EOCF_LIB_TERM_NAME Character(80) VARCHAR2(80) NOT NULL the name of the Term in the library
    9 EOCF_CTX_CONSTANT Character(50) VARCHAR2(50) NOT NULL constant values for constant context variables
    10 EOCF_COMPFLD_TYPE Character(1) VARCHAR2(1) NOT NULL Component Field Type - Rowset/Record/Field
    1=Rowset
    2=Record
    3=Field