RSF_FALLOUT2_VW (SQL View)	Index Back
Sales Compare of Forecasts This view is used by ACE for the Sales Compare of Forecasts analytic report.

RSF_FALLOUT2_VW

(SQL View)

Sales Compare of Forecasts

This view is used by ACE for the Sales Compare of Forecasts analytic report.

SELECT I.PROBINST , A.FORECAST_ID , A.TIMEFRAME_PERIOD , A.FORECAST_CATEGORY , C.OPPORTUNITY_ID , C.TERRITORYDESCR , %Substring(C.NAME1, 1, 30) , C.PRODGROUPDESCR , C.SYNCID , B.FORECAST_DT , %Round(%DecMult(C.FROM_REVENUE, G.RATE_MULT),1) , G.TO_CUR , 1 FROM PS_RSF_FCAST A , PS_RSF_FCAST_USER B , PS_RSF_FCAST_DTL C , PS_RSF_ACC_MGR_VW D , PS_RT_DFLT_VW G , PS_INSTALLATION H , PS_RSF_OPR_DEF_VW E , PS_RSF_FOUT_INST I WHERE E.OPRID = I.OPRID AND A.FORECAST_ID = B.FORECAST_ID AND A.TIMEFRAME_PERIOD = B.TIMEFRAME_PERIOD AND A.FORECAST_CATEGORY = B.FORECAST_CATEGORY AND B.FORECAST_ID = C.FORECAST_ID AND B.TIMEFRAME_PERIOD = C.TIMEFRAME_PERIOD AND B.FORECAST_CATEGORY = C.FORECAST_CATEGORY AND B.PERSON_ID = C.PERSON_ID AND C.PERSON_ID_ADJUSTBY = D.PERSON_ID AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PS_RT_DFLT_VW G_ED WHERE G.FROM_CUR = G_ED.FROM_CUR AND G.TO_CUR = G_ED.TO_CUR AND G.RT_TYPE = G_ED.RT_TYPE AND G.TO_CUR = I.TO_CUR AND H.DEF_CUR_RT_TYPE = G.RT_TYPE AND G.FROM_CUR = C.FROM_CUR AND G_ED.EFFDT <= %CurrentDateIn) AND D.PERSON_ID_MANAGER = E.PERSON_ID AND A.FORECAST_ID = I.RSF_COMP_ID AND A.TIMEFRAME_PERIOD = I.TIMEFRAME_PERIOD AND A.FORECAST_CATEGORY = I.FORECAST_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name

3 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

4 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast

5 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

6 TERRITORYDESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 PRODGROUPDESCR Character(30) VARCHAR2(30) NOT NULL Description

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

11 FROM_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL From Revenue For Forecast Comparison Ace Report

12 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

13 DUMMYFIELD Number(3,0) SMALLINT NOT NULL Dummy Filed For ACE Report

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name
3	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame
4	FORECAST_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Forecast Category R=Revenue Forecast S=Shadow Forecast
5	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
6	TERRITORYDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	PRODGROUPDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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	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.
11	FROM_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	From Revenue For Forecast Comparison Ace Report
12	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
13	DUMMYFIELD	Number(3,0)	SMALLINT NOT NULL	Dummy Filed For ACE Report