FORECAST_IDPrompt Table: RSF_FCAST_ID
TIMEFRAME_PERIODPrompt Table: %EDITTABLE
FORECAST_CATEGORYR=Revenue Forecast
S=Shadow Forecast
PERSON_IDN=No
Y=Yes
Y/N Table Edit
Default Value: N
RSF_FC_ALLSB_VW(SQL View) |
Index Back |
|---|---|
View on submitted forecastsAll forecasts whether submiited or not |
| SELECT A.FORECAST_ID , A.TIMEFRAME_PERIOD , A.FORECAST_CATEGORY , B.PERSON_ID , B.PERSON_ID_MANAGER , A.FORECAST_SUBMITTED FROM PS_RSF_FCAST_USER A , PS_RSF_ACC_MGR_VW B WHERE B.PERSON_ID = A.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Forecast Name
Prompt Table: RSF_FCAST_ID |
| 2 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL |
Time Frame
Prompt Table: %EDITTABLE |
| 3 | FORECAST_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Forecast Category
R=Revenue Forecast S=Shadow Forecast |
| 4 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 5 | PERSON_ID_MANAGER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 6 | FORECAST_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
Submit status for forecast.
N=No Y=Yes Y/N Table Edit Default Value: N |