RSF_FCAST_OP_VW

(SQL View)
 Index Back

Forecast Operator View

Operator to forecast view of specific dates

SELECT O.OPRID , F.FORECAST_ID , F.TIMEFRAME_PERIOD , F.FORECAST_CATEGORY , O.PERSON_ID , I.FORECAST_DT , T.BEGIN_DT , T.END_DT , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST F , PS_RSF_FCAST_ID I , PS_RSF_TFP_VW T , PSOPRALIAS O WHERE F.FORECAST_ID = I.FORECAST_ID AND F.TIMEFRAME_PERIOD = T.TIMEFRAME_PERIOD AND F.STATUS = 'A' AND I.STATUS = 'A' AND T.STATUS = 'A' AND O.OPRALIASTYPE = 'PER' AND I.FORECAST_DT <= T.END_DT

# 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