SCENARIO_ID2FORECAST_ID_DMDPROJ_ROLEDATE_ENTEREDRS_SNR_ACE_VW(SQL View) |
Index Back |
|---|---|
Supply Forecast Cache TableESA for IT: Supply Forecast Cache Table |
| SELECT A.SCENARIO_ID2 ,A.FORECAST_ID_DMD ,A.PROJ_ROLE ,A.DATE_ENTERED ,B.DESCR ,A.PROBINST ,A.PRIORITY_DMD_STRNG ,A.COMMIT_ACTN_STRNG ,A.RANK ,A.ALLOCATED_DEMAND ,A.EFFORT ,A.ALERT ,A.VARIANCE_SCP FROM PS_RS_SNR_COM_TMP A ,PS_RS_FR_DMD_DTL B WHERE A.DEMAND_ID=B.DEMAND_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCENARIO_ID2 |
Character(15) | VARCHAR2(15) NOT NULL | SCP-Combined Scenario ID |
| 2 | FORECAST_ID_DMD |
Character(15) | VARCHAR2(15) NOT NULL | Demand Forecast ID |
| 3 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 4 | DATE_ENTERED |
Date(10) | DATE NOT NULL | Date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 7 | PRIORITY_DMD_STRNG | Character(10) | VARCHAR2(10) NOT NULL | Demand Priority |
| 8 | COMMIT_ACTN_STRNG | Character(10) | VARCHAR2(10) NOT NULL | Commitment Line |
| 9 | RANK | Number(3,0) | SMALLINT NOT NULL | Priority Ranking |
| 10 | ALLOCATED_DEMAND | Number(13,2) | DECIMAL(12,2) NOT NULL | SCP-Allocated Demand . |
| 11 | EFFORT | Number(13,2) | DECIMAL(12,2) NOT NULL | Effort |
| 12 | ALERT | Character(1) | VARCHAR2(1) NOT NULL | SCP - To indicate negative Variance. |
| 13 | VARIANCE_SCP | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | SCP-Difference in Capacity |