OPRIDSCCPS_CNTXT_IDSCCPS_QUERY_NAMELANGUAGE_CDSCCPS_PSQRY_LNG(SQL View) |
Index Back |
|---|---|
Pop Select PS Query Prompt VwPrompt view used for PS Query Names by Pop Select |
| SELECT DISTINCT D.OPRID ,C.SCCPS_CNTXT_ID ,A.QRYNAME ,A.LANGUAGE_CD ,A.DESCR FROM PSQRYDEFNLANG A , PSQRYRECORD B , PS_SCCPS_CNTXT_BND C , PSOPRDEFN D WHERE A.OPRID = B.OPRID AND A.QRYNAME = B.QRYNAME AND C.SCCPS_BIND_VIEW = B.RECNAME AND (D.OPRID = A.OPRID OR A.OPRID = ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SCCPS_CNTXT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Context ID - the unique key that identifies the pop selection context |
| 3 | SCCPS_QUERY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Query / Section name used by population selection |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |