PROBINSTRA_SCENARIOS_VW(SQL View) |
Index Back |
|---|---|
Scenario ViewScenario View for Marketing ACE Report |
| SELECT K.PROBINST , E.RA_SCENARIOS , E.COMMENTSHORT FROM PS_RA_SCENARIOS E , PS_RA_WIF_ALY_INST K , PS_RA_WIF_ANALYTIC J WHERE K.OPRID = J.OPRID AND K.RUN_CNTL_ID = J.RUN_CNTL_ID GROUP BY K.PROBINST , E.RA_SCENARIOS , E.COMMENTSHORT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | RA_SCENARIOS | Character(20) | VARCHAR2(20) NOT NULL | Scenarios for Marketing ACE Report |
| 3 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |