OPRID1=Pending
2=Approved
3=Obsolete
RS_SCP_SCENARIO(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , B.SCENARIO_ID2 ,B.SCENARIO_STATUS , B.FORECAST_ID_SUP , B.FORECAST_ID_DMD , B.DESCR , C.DESCR ,D.DESCR ,C.CAPACITY , D.EFFORT ,B.ALLOCATED_DEMAND ,B.FMS_OPRID ,A.DATETIME_STAMP FROM %Table(RS_SCP_HOMEPAGE) A , %Table(RS_SCENARIO_HDR) B , %Table(RS_FR_SUP_HDR) C , %Table(RS_FR_DMD_HDR) D WHERE B.SCENARIO_ID2 = A.FORECAST_ID_FRM AND A.FORECAST_TYPE = '3' AND B.FORECAST_ID_SUP = C.FORECAST_ID_SUP AND B.FORECAST_ID_DMD = D.FORECAST_ID_DMD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SCENARIO_ID2 | Character(15) | VARCHAR2(15) NOT NULL | SCP-Combined Scenario ID |
| 3 | SCENARIO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SCP-Combined Scenario Statuses
1=Pending 2=Approved 3=Obsolete |
| 4 | FORECAST_ID_SUP | Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 5 | FORECAST_ID_DMD | Character(15) | VARCHAR2(15) NOT NULL | Demand Forecast ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR_4 | Character(30) | VARCHAR2(30) NOT NULL | Select New Page |
| 9 | CAPACITY | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | SCP- Forecasted Supply stored as capacity. |
| 10 | EFFORT | Number(13,2) | DECIMAL(12,2) NOT NULL | Effort |
| 11 | ALLOCATED_DEMAND | Number(13,2) | DECIMAL(12,2) NOT NULL | SCP-Allocated Demand . |
| 12 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 13 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |