FORECAST_ID_DMD1=1 - Critical
2=2 - High
3=3 - Medium
4=4 - Low
RS_FR_DMD_EFORT(SQL View) |
Index Back |
|---|
| SELECT FORECAST_ID_DMD , DEMAND_ID , DESCR , RANK , PRIORITY_DMD ,SUM(EFFORT) FROM %Table(RS_FR_DMD_DTL) GROUP BY FORECAST_ID_DMD ,DEMAND_ID ,DESCR ,RANK , PRIORITY_DMD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_DMD |
Character(15) | VARCHAR2(15) NOT NULL | Demand Forecast ID |
| 2 | DEMAND_ID | Character(15) | VARCHAR2(15) NOT NULL | Demand ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | RANK | Number(3,0) | SMALLINT NOT NULL | Priority Ranking |
| 5 | PRIORITY_DMD | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=1 - Critical 2=2 - High 3=3 - Medium 4=4 - Low |
| 6 | EFFORT | Number(13,2) | DECIMAL(12,2) NOT NULL | Effort |