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

RSFD_MGR_O_A_NO

(SQL View)

Manager No Annual Open Revenue

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

SELECT S.PERSON_ID , '0' , EA.TIMEFRAME_PERIOD , INST.PT_CDB_DEF_CUR_CD , 0 FROM PS_RSF_SUSER S , PS_RSFD_TFP_ANN_VW EA , PSCDBINSTALL INST WHERE NOT EXISTS ( SELECT 'X' FROM PS_RSFD_MGR_OREV_A O WHERE S.PERSON_ID = O.PERSON_ID_MANAGER AND EA.TIMEFRAME_PERIOD = O.TIMEFRAME_PERIOD)

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