OPRIDSCCPS_CNTXT_IDSCCPS_QUERY_NAMELANGUAGE_CDSCCPS_EQTN_LNG(SQL View) |
Index Back |
|---|---|
Pop Selection Equation PromptPop Selection Equation Prompt |
| SELECT B.OPRID , C.SCCPS_CNTXT_ID , A.EQUATION_NAME , A.LANGUAGE_CD , A.DESCR FROM PS_EQTXIDEXESECLNG A , PSOPRDEFN B , PS_SCCPS_CNTXT_BND C WHERE (EQTN_ID_AUTH_CLASS IN ( SELECT OPRALIASVALUE FROM PSOPRALIAS ALS WHERE ALS.OPRID = B.OPRID AND ALS.OPRALIASTYPE = 'EQN') OR (EQTN_ID_AUTH_CLASS = 'PUBLIC')) |
| # | 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 |