SCCPS_CNTXT_FLD (SQL Table)	Index Back
Context field mapping Population Selection field mapping from the bind record to the results record. This is based on the context.

SCCPS_CNTXT_FLD

(SQL Table)

Context field mapping

Population Selection field mapping from the bind record to the results record. This is based on the context.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCCPS_CNTXT_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Population Selection Context Bind ID

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

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

4 SCCPS_MAP_ACTION Character(4) VARCHAR2(4) NOT NULL Field Mapping Action used by the pop selection feature. This defines the type of mapping a field will receive.
CNTR=Unique Counter
DFLT=Default
DRCT=Direct
NONE=None
PI=Process Instance
SEQ=Sequence

5 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.
Prompt Table: SCCPS_MAPFLD_VW

6 SCCPS_CNTR_REC Character(15) VARCHAR2(15) NOT NULL Counter record - used in the pop select mapping feature.
Prompt Table: SCCPS_RECDFN_VW

7 SCCPS_CNTR_FLD Character(18) VARCHAR2(18) NOT NULL Counter field - used in the pop select mapping feature.
Prompt Table: SCCPS_RECFLD_VW

8 BNDVALUE Long Character CLOB Bind Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCPS_CNTXT_HDR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Population Selection Context Bind ID
2	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	SCCPS_MAP_ACTION	Character(4)	VARCHAR2(4) NOT NULL	Field Mapping Action used by the pop selection feature. This defines the type of mapping a field will receive. CNTR=Unique Counter DFLT=Default DRCT=Direct NONE=None PI=Process Instance SEQ=Sequence
5	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. Prompt Table: SCCPS_MAPFLD_VW
6	SCCPS_CNTR_REC	Character(15)	VARCHAR2(15) NOT NULL	Counter record - used in the pop select mapping feature. Prompt Table: SCCPS_RECDFN_VW
7	SCCPS_CNTR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Counter field - used in the pop select mapping feature. Prompt Table: SCCPS_RECFLD_VW
8	BNDVALUE	Long Character	CLOB	Bind Value