SCCPS_FILE_VW (SQL View)	Index Back
File Parser / Pop Select vw File Map view for pop select

SCCPS_FILE_VW

(SQL View)

File Parser / Pop Select vw

File Map view for pop select

SELECT DISTINCT C.OPRID ,B.SCCPS_CNTXT_ID ,A.SCCFP_MAP_NAME ,A.SCCFP_MAP_NAME ,A.SCCFP_MAP_ID FROM PS_SCCFP_PS_MAP A , PS_SCCPS_CNTXT_BND B , PSOPRDEFN C WHERE (A.SCCPS_BIND_VIEW=B.SCCPS_BIND_VIEW OR A.SCCPS_BIND_VIEW IN ( SELECT E.RECNAME FROM PS_SCCPS_CNTXT_ARF E WHERE E.SCCPS_CNTXT_ID = B.SCCPS_CNTXT_ID)) AND (A.CREATEOPRID = C.OPRID OR A.SCCFP_PUBLIC_MAP = 'Y')

# 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

5 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping

#	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
5	SCCFP_MAP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Mapping ID - the unique key that identifies the file mapping