EOCF_CTXVRN_LVW (SQL View)	Index Back
context variable LANG VIEW This is prompt view used in Term defn page for prompting term bind mapping if bind source is system. context variable definition

EOCF_CTXVRN_LVW

(SQL View)

context variable LANG VIEW

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

SELECT A.EOCF_CONTEXT_ID , A.EOCF_CONTEXT_VAR ,B.LANGUAGE_CD , B.EOCF_CTX_CONSTANT FROM PS_EOCF_CTX_VARSNW A , PS_EOCF_CTX_VARS_L B WHERE A.EOCF_COMPFLD_TYPE <> '1' AND A.EOCF_COMPFLD_TYPE <> '2'

Related Language Record for EOCF_CTXVARN_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EOCF_CTX_CONSTANT Character(50) VARCHAR2(50) NOT NULL constant values for constant context variables

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EOCF_CTX_CONSTANT	Character(50)	VARCHAR2(50) NOT NULL	constant values for constant context variables