SCCPS_MAPFLD_VW (SQL View)	Index Back
Pop Select Field View View that returns all the fields (regardless of subrecords) for a record. This is used by the context mapping feature.

SCCPS_MAPFLD_VW

(SQL View)

Pop Select Field View

View that returns all the fields (regardless of subrecords) for a record. This is used by the context mapping feature.

SELECT A.RECNAME , B.FIELDNAME FROM PSRECDEFN A , PSRECFIELD B WHERE B.SUBRECORD = 'N' AND (A.RECNAME = B.RECNAME OR (A.RECNAME <> B.RECNAME AND B.RECNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELD C WHERE C.SUBRECORD = 'Y' AND C.RECNAME = A.RECNAME)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCCPS_BIND_VIEW Character(15) VARCHAR2(15) NOT NULL Bind view used for the pop selection feature. This view contains the required fields for a paticular context.
Prompt Table: RECDEFN_VW

2 SCCPS_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Source field - the source field from the bind record used by pop selection during the mapping of results.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCPS_BIND_VIEW	Character(15)	VARCHAR2(15) NOT NULL	Bind view used for the pop selection feature. This view contains the required fields for a paticular context. Prompt Table: RECDEFN_VW
2	SCCPS_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source field - the source field from the bind record used by pop selection during the mapping of results.