FORECAST_ID_DMDDefault Value: NEXT
DATE_ENTEREDAPPLICATION_AREAAPPLICATIONPROGRAMRELEASERS_DMD_ACE_VW(SQL View) |
Index Back |
|---|---|
Supply Forecast Cache TableESA for IT: Supply Forecast Cache Table |
| SELECT FORECAST_ID_DMD , DATE_ENTERED ,APPLICATION_AREA ,APPLICATION ,PROGRAM ,RELEASE ,PROBINST ,SUM(EFFORT ) ,SUM(FULL_TIME_RES_DMD) FROM PS_RS_DMD_ACE_TMP GROUP BY PROBINST , FORECAST_ID_DMD , DATE_ENTERED ,APPLICATION_AREA ,APPLICATION ,PROGRAM ,RELEASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_DMD |
Character(15) | VARCHAR2(15) NOT NULL |
Demand Forecast ID
Default Value: NEXT |
| 2 | DATE_ENTERED |
Date(10) | DATE NOT NULL | Date |
| 3 | APPLICATION_AREA |
Character(10) | VARCHAR2(10) NOT NULL | The general area in which an application belongs. Examples: "Financials", "Human Resources", etc. |
| 4 | APPLICATION |
Character(10) | VARCHAR2(10) NOT NULL | Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area. |
| 5 | PROGRAM |
Character(15) | VARCHAR2(15) NOT NULL | Program |
| 6 | RELEASE |
Character(15) | VARCHAR2(15) NOT NULL | Release - Carries Release Information driven by the BUSINESS_UNIT |
| 7 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 8 | EFFORT | Number(13,2) | DECIMAL(12,2) NOT NULL | Effort |
| 9 | FULL_TIME_RES_DMD | Number(13,2) | DECIMAL(12,2) NOT NULL | Full Time Resource - Demand |