EOCF_CTXCVAL_VW

(SQL View)
Index Back

context variable page view

context variable page view

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_CTX_VAR_TYPE = 'CVAL'

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

Default Value: CVAL

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 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: 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