OPRIDFORECAST_TYPE1=Supply Forecast
2=Demand Forecast
3=Consolidated Scenario
Default Value: 1
RS_FR_COPY_SRCH(SQL View) |
Index Back |
|---|---|
Copy Forecast Search RecordSearch Record for Copy Forecast |
| SELECT OPRID ,FORECAST_TYPE FROM PS_RS_SCP_HOMEPAGE WHERE FORECAST_TYPE IN ('1','2') |
| # | 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 Default Value: 1 |