RSF_FCAST_RR_VW

(SQL View)
 Index Back

New Revene Forecasts

Used on original configurable search page for 'new' forecasts.

SELECT F.OPRID , F.FORECAST_ID , F.TIMEFRAME_PERIOD , F.FORECAST_CATEGORY , F.PERSON_ID , F.FORECAST_EXPECT_DT , F.BEGIN_DT , F.END_DT , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST_OP_VW F WHERE NOT EXISTS ( SELECT 'X' FROM PS_RSF_FCAST_USER U WHERE F.FORECAST_ID = U.FORECAST_ID AND F.TIMEFRAME_PERIOD = U.TIMEFRAME_PERIOD AND F.FORECAST_CATEGORY = U.FORECAST_CATEGORY AND U.PERSON_ID IN ( SELECT V.PERSON_ID FROM PS_RSF_ACC_MGR_VW V WHERE V.PERSON_ID_MANAGER = F.PERSON_ID) )

# 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 FORECAST_EXPECT_DT Date(10) DATE Expected Forecast Date
7 BEGIN_DT Date(10) DATE Begin Date
8 END_DT Date(10) DATE This field stores the end date values.
9 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.
10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time