RSF_FCAST_RM_VW (SQL View)	Index Back
Existing Revene Forecasts Used on original configurable search page for 'existing' forecasts.

RSF_FCAST_RM_VW

(SQL View)

Existing Revene Forecasts

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

SELECT F.OPRID , F.SYNCID , U.FORECAST_DT , MAX(U.PERSON_ID) FROM PS_RSF_FCAST_OP_VW F , PS_RSF_FCAST_USER U , PS_RSF_SUSEROPR_VW O WHERE F.FORECAST_ID = U.FORECAST_ID AND F.TIMEFRAME_PERIOD = U.TIMEFRAME_PERIOD AND F.FORECAST_CATEGORY = U.FORECAST_CATEGORY AND O.PERSON_ID = F.PERSON_ID AND U.PERSON_ID IN ( SELECT V.PERSON_ID FROM PS_RSF_ACC_MGR_VW V WHERE V.PERSON_ID_MANAGER = O.PERSON_ID) GROUP BY F.OPRID , F.SYNCID, U.FORECAST_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 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.

3 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.

4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL 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	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.
3	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.
4	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID