OPRIDFORECAST_IDPrompt Table: %EDITTABLE
TIMEFRAME_PERIODPrompt Table: %EDITTABLE2
FORECAST_CATEGORYR=Revenue Forecast
S=Shadow Forecast
PERSON_IDRSFM_SV_FCST_VW(SQL View) |
Index Back |
|---|---|
RSF_FCAST - Revenue Sales User |
| SELECT O.OPRID , U.FORECAST_ID , U.TIMEFRAME_PERIOD , U.FORECAST_CATEGORY , U.PERSON_ID , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST_USER U , PS_RSF_FCAST F , PS_RSF_FCAST_ID I , PSOPRALIAS O WHERE F.FORECAST_ID = U.FORECAST_ID AND F.FORECAST_ID = I.FORECAST_ID AND F.TIMEFRAME_PERIOD = U.TIMEFRAME_PERIOD AND F.STATUS = 'A' AND F.FORECAST_CATEGORY = 'R' AND U.FORECAST_CATEGORY = 'R' AND O.PERSON_ID = U.PERSON_ID AND O.OPRALIASTYPE = 'PER' |
| # | 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_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Forecast Name
Prompt Table: %EDITTABLE |
| 3 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL |
Time Frame
Prompt Table: %EDITTABLE2 |
| 4 | FORECAST_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Forecast Category
R=Revenue Forecast S=Shadow Forecast |
| 5 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 6 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 7 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |