RSFD_MGR_OREV_A (SQL View)	Index Back
Manager Annual Open Revenue This view is used to populate summarized Open Annual revenue at a manager level in sales dashboard.

RSFD_MGR_OREV_A

(SQL View)

Manager Annual Open Revenue

This view is used to populate summarized Open Annual revenue at a manager level in sales dashboard.

SELECT MGR.PERSON_ID_MANAGER , O.OPPORTUNITY_STATUS , EA.TIMEFRAME_PERIOD , INST.PT_CDB_DEF_CUR_CD , %Round(SUM(%DecDiv(%DecMult(%DecMult(CUR.INST_MULT, O.EST_REVENUE), REP.PCT_ALLOC),100)),0) FROM PS_RSF_OPPORTUNITY O , PS_RSF_OPP_SLSREP REP , PS_RSF_ACC_MGR_VW MGR , PS_RSFD_TFP_ANN_VW EA , PS_RBD_CURRT CUR , PSCDBINSTALL INST WHERE OPPORTUNITY_STATUS = '0' AND O.EST_CLOSE_DT BETWEEN EA.BEGIN_DT AND EA.END_DT AND O.OPPORTUNITY_ID = REP.OPPORTUNITY_ID AND REP.PERSON_ID = MGR.PERSON_ID AND O.CURRENCY_CD = CUR.CURRENCY_CD GROUP BY MGR.PERSON_ID_MANAGER , O.OPPORTUNITY_STATUS, EA.TIMEFRAME_PERIOD , INST.PT_CDB_DEF_CUR_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

2 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
0=Open
1=Closed - Lost
2=Closed - Won
3=Inactive

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

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

5 EST_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	OPPORTUNITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Opportunity Status. The values are XLat Values 0=Open 1=Closed - Lost 2=Closed - Won 3=Inactive
3	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
5	EST_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.