SCCPS_CNTXT_HDR_IDSCCPS_CNTXT_IDPrompt Table: SCCPS_CNTXT_MAP
Prompt Table: %EDITTABLE
SCCPS_APPDTA_VW(SQL View) |
Index Back |
|---|---|
Pop Select App Data ViewPopulation Selection Application Specific data view |
| SELECT A.SCCPS_CNTXT_HDR_ID ,B.SCCPS_CNTXT_ID , A.SCCPS_VARY_MAP_ID , B.SCCPS_MAP_VALUE FROM PS_SCCPS_CNTXT_DFN A , PS_SCCPS_CNTXT_BND B WHERE A.SCCPS_CNTXT_HDR_ID = B.SCCPS_CNTXT_HDR_ID |
| # | 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_VARY_MAP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Pop Select Mapping Key
Prompt Table: SCCPS_CNTXT_MAP |
| 4 | SCCPS_MAP_VALUE | Character(50) | VARCHAR2(50) NOT NULL |
Pop Select mapping value - maps context to generic field values
Prompt Table: %EDITTABLE |