SCCPS_PSQRY_VW (SQL View)	Index Back
Pop Select PS Query Prompt Vw Prompt view used for PS Query Names by Pop Select

SCCPS_PSQRY_VW

(SQL View)

Pop Select PS Query Prompt Vw

Prompt view used for PS Query Names by Pop Select

SELECT DISTINCT D.OPRID ,C.SCCPS_CNTXT_ID ,A.QRYNAME ,A.DESCR FROM PSQRYDEFN A , PSQRYRECORD B , PS_SCCPS_CNTXT_BND C , PSOPRDEFN D WHERE A.OPRID = B.OPRID AND A.QRYNAME = B.QRYNAME AND B.RECNAME IN ( SELECT RECNAME FROM PS_SCCPS_CNTXT_ARF E WHERE E.SCCPS_CNTXT_ID = C.SCCPS_CNTXT_ID) AND (D.OPRID = A.OPRID OR A.OPRID = ' ')

Related Language Record: SCCPS_PSQRY_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

3 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context
3	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description