RSFD_MGR_PL_NO

(SQL View)
 Index Back

Manager Pipeline Actual

This view is used to get (Estimated Revenue) Pipeline revenue/count for Managers that do not have any Open or Closed-Won opportunities.

SELECT DISTINCT MGR.PERSON_ID_MANAGER , STG.PIPELINE_SEGMENT , 'R' , INST.PT_CDB_DEF_CUR_CD , 0 , 0 FROM PS_RSFD_OPPBASE_VW O , PS_RSF_OPP_SLSREP REP , PS_RSF_ACC_MGR_VW MGR , PS_RBD_CURRT CUR , PSCDBINSTALL INST , PS_RSF_SALES_STAGE STG , PS_RSF_SEGMENT SEG WHERE STG.PIPELINE_SEGMENT = SEG.PIPELINE_SEGMENT AND STG.STATUS = 'A' AND MGR.PERSON_ID_MANAGER > ' ' AND O.OPPORTUNITY_ID = REP.OPPORTUNITY_ID AND REP.PERSON_ID = MGR.PERSON_ID AND O.CURRENCY_CD = CUR.CURRENCY_CD AND O.SETID = STG.SETID AND O.SALES_MODEL = STG.SALES_MODEL AND O.SALES_STAGE = STG.SALES_STAGE AND NOT EXISTS ( SELECT 'X' FROM PS_RSFD_MGR_PL_ACT A WHERE A.PERSON_ID_MANAGER = MGR.PERSON_ID_MANAGER AND A.PIPELINE_SEGMENT = SEG.PIPELINE_SEGMENT)

# 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 PIPELINE_SEGMENT Character(15) VARCHAR2(15) NOT NULL Segment corresponds to sales stage.
3 SEG_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Segment Quota Type
M=Manager Quota
R=Rollup Quota

Default Value: R

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
5 REVENUE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
6 OPPORTUNITY_COUNT Signed Number(10,0) DECIMAL(9) NOT NULL Opportunity Count