RA_OFRCTX_VW (SQL View)	Index Back
Context Definition View Context definition view used in Offer Definition.

RA_OFRCTX_VW

(SQL View)

Context Definition View

Context definition view used in Offer Definition.

SELECT B.EOCF_CONTEXT_ID ,A.EOCF_CTX_NAME ,A.DESCR50 FROM PS_EOCF_CONTEXT A , PS_RA_CONTEXT B WHERE A.EOCF_CONTEXT_ID=B.EOCF_CONTEXT_ID

Related Language Record: RA_OFRCTX_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_CTX_NAME Character(50) VARCHAR2(50) NOT NULL context name

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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_CTX_NAME	Character(50)	VARCHAR2(50) NOT NULL	context name
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50