FORECAST_ID_DMDRS_DEMAND_SUM(SQL View) |
Index Back |
|---|
| SELECT DISTINCT FORECAST_ID_DMD , APPLICATION_AREA ,SUM( EFFORT) , SUM(FULL_TIME_RES_DMD) FROM %Table(RS_FR_DMD_DTL) GROUP BY FORECAST_ID_DMD ,APPLICATION_AREA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_DMD |
Character(15) | VARCHAR2(15) NOT NULL | Demand Forecast ID |
| 2 | APPLICATION_AREA | Character(10) | VARCHAR2(10) NOT NULL | The general area in which an application belongs. Examples: "Financials", "Human Resources", etc. |
| 3 | EFFORT | Number(13,2) | DECIMAL(12,2) NOT NULL | Effort |
| 4 | FULL_TIME_RES_DMD | Number(13,2) | DECIMAL(12,2) NOT NULL | Full Time Resource - Demand |