FORECAST_IDPrompt Table: RSF_FCAST_ID
TIMEFRAME_PERIODPrompt Table: RSF_TFP_VW
FORECAST_CATEGORYR=Revenue Forecast
S=Shadow Forecast
A=Active
I=Inactive
Default Value: A
N=No
Y=Yes
RSF_FCAST_AR_VW(SQL View) |
Index Back |
|---|---|
Forecast Archive Search RecordThis record is a view of the forecast archive. |
| SELECT FORECAST_ID , TIMEFRAME_PERIOD , FORECAST_CATEGORY , STATUS , FORECAST_DT , FORECAST_LOCKED , FORECAST_LOCKED_DT FROM PS_RSF_FCAST |
| # | 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: RSF_TFP_VW |
| 3 | FORECAST_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Forecast Category
R=Revenue Forecast S=Shadow Forecast |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 5 | FORECAST_DT | Date(10) | DATE | Date when forecast. The date the entire forecast was begun does not change, but the date per user does change with updates. |
| 6 | FORECAST_LOCKED | Character(1) | VARCHAR2(1) NOT NULL |
Lock Forecast
N=No Y=Yes |
| 7 | FORECAST_LOCKED_DT | Date(10) | DATE | Forecast Locked Date |