OPRIDFORECAST_TYPE1=Supply Forecast
2=Demand Forecast
3=Consolidated Scenario
FORECAST_ID_FRMRS_SCP_HOMEPAGE(SQL Table) |
Index Back |
|---|---|
SCP HomePage RecordSCP - Used to store the last five viewed supply forecasts, demand forecasts and consolidated scenarios by an OPRID |
| # | 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 | FORECAST_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
SCP-Forecast Types-Supply, Demand and Combined Scenario
1=Supply Forecast 2=Demand Forecast 3=Consolidated Scenario |
| 3 | FORECAST_ID_FRM |
Character(15) | VARCHAR2(15) NOT NULL | SCP - Forecast Id |
| 4 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |