OPRIDSCCPS_CNTXT_IDSCCPS_QUERY_NAMESCCPS_EQTN_VW(SQL View) |
Index Back |
|---|---|
Pop Selection Equation PromptPop Selection Equation Prompt |
| SELECT B.OPRID , C.SCCPS_CNTXT_ID , A.EQUATION_NAME , A.DESCR FROM PS_EQTX_ID_EXE_SEC A , PSOPRDEFN B , PS_SCCPS_EQT_MAP C , PS_SCC_APPL_PRMPT D 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')) AND D.EQUATION_NAME = A.EQUATION_NAME AND D.SCC_APPL_PROMPT_ID = C.SCC_APPL_PROMPT_ID |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |