SCCPS_CNTXT_IDSCCPS_CNTXT_VW(SQL View) |
Index Back |
|---|---|
Pop Select Context ViewPop Select context view |
| SELECT DISTINCT B.SCCPS_CNTXT_ID , A.SCCPS_CNTXT_NAME , A.SCCPS_DESCR254 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_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Context ID - the unique key that identifies the pop selection context |
| 2 | SCCPS_CNTXT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Context name - the user key to a pop select context. |
| 3 | SCCPS_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Generic description field used in the pop selection feature. |