FORECAST_ID_SUPPROJ_ROLEDESCRPER_DTL_STATUSREGION_CDDATE_ENTEREDRS_SUP_ACE_VW(SQL View) |
Index Back |
|---|---|
Supply Forecast Cache TableESA for IT: Supply Forecast Cache Table |
| SELECT A.FORECAST_ID_SUP ,A.PROJ_ROLE ,B.DESCR ,A.PER_DTL_STATUS ,A.REGION_CD , A.DATE_ENTERED , A.PROBINST ,A.CAPACITY1 ,A.FULL_TIME_RES_SUP FROM PS_RS_SUP_ACE_TMP A ,PS_RS_RES_POOL B WHERE A.POOL_ID=B.POOL_ID AND (A.CAPACITY1>0 OR A.FULL_TIME_RES_SUP>0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_SUP |
Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PER_DTL_STATUS |
Character(12) | VARCHAR2(12) NOT NULL | Personnel Detailed Status |
| 5 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 6 | DATE_ENTERED |
Date(10) | DATE NOT NULL | Date |
| 7 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 8 | CAPACITY | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | SCP- Forecasted Supply stored as capacity. |
| 9 | FULL_TIME_RES_SUP | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Full Time Resources |