PROBINSTRY_DLG_SCN_VW(SQL View) |
Index Back |
|---|---|
Dialog Scenario ViewDialog Scenario View for ACE report |
| SELECT D.PROBINST , A.RY_DLG_SCENARIO , A.COMMENTSHORT FROM PS_RY_DLG_SCENARIO A , PS_RY_DIALOG_IR C , PS_RY_DLG_IR_INST D WHERE C.OPRID = D.OPRID AND C.RUN_CNTL_ID = D.RUN_CNTL_ID GROUP BY D.PROBINST, A.RY_DLG_SCENARIO, A.COMMENTSHORT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | RY_DLG_SCENARIO | Character(30) | VARCHAR2(30) NOT NULL | Dialog Schnario for ACE reporting |
| 3 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |