SCCPS_CNTXT_HDR_IDSCCPS_CNTXT_IDPrompt Table: RECDEFN_VW
Prompt Table: RECDEFN_VW
Prompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
SCCPS_CNTXT_BND(SQL Table) |
Index Back |
|---|---|
Pop Select Context Bind MapPopulation Selection Bind Mapping Record |
| # | 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 | SCCPS_RSLTS_TABLE | Character(15) | VARCHAR2(15) NOT NULL |
Results table for population selection. This is the table that is populated with the results of the selection. This table is set on the Context.
Prompt Table: RECDEFN_VW |
| 4 | 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 |
| 5 | SCCPS_MAP_VALUE | Character(50) | VARCHAR2(50) NOT NULL |
Pop Select mapping value - maps context to generic field values
Prompt Table: %EDITTABLE |
| 6 | SCCPS_AUTO_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Population Selection - Auto Populate parameters flag
Y/N Table Edit Default Value: N |