PROBINSTRF_UTL_SCENARIORF_UTIL_SCN_VW(SQL View) |
Index Back |
|---|---|
Work Hours - Utilizatio RateInput view for work hours - utilization rate ACE report |
| SELECT K.PROBINST , B.RF_UTL_SCENARIO , B.COMMENTSHORT FROM PS_RF_UTIL_WRK_TBL A , PS_RF_UTL_SCENARIO B , PS_RF_UTIL_CONFIG J , PS_RF_UTIL_CF_INST K WHERE A.UUID_RAW = K.UUID_RAW AND J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID GROUP BY K.PROBINST , B.RF_UTL_SCENARIO , B.COMMENTSHORT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | RF_UTL_SCENARIO |
Character(30) | VARCHAR2(30) NOT NULL | Utilization Rate Scenario for Marketing ACE Report |
| 3 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |