RSFD_MGR_FC_VW

(SQL View)
 Index Back

Compare Forecast to quota

This record is used for Sales Dashboard to compare forecast vs. Quota for a sales rep. Has quota Has Forecast

SELECT FCID.PERSON_ID_MANAGER , F.TIMEFRAME_PERIOD , INST.PT_CDB_DEF_CUR_CD , %Round(sum(%DecMult(CUR.INST_MULT , F.FROM_REVENUE)),0) FROM PS_RSF_FCAST_DTL F , PS_RSF_FCAST_USER U , PS_RSF_SUSER S , PS_RSFD_MGR_FCID_V FCID , PS_RSF_ACC_MGR_VW MGR , PS_RBD_CURRT CUR , PSCDBINSTALL INST WHERE F.FORECAST_CATEGORY = 'R' AND F.PERSON_ID = S.PERSON_ID AND F.TIMEFRAME_PERIOD = FCID.TIMEFRAME_PERIOD AND F.FORECAST_ID = FCID.FORECAST_ID AND F.FORECAST_ID = U.FORECAST_ID AND F.FORECAST_CATEGORY = U.FORECAST_CATEGORY AND F.PERSON_ID = U.PERSON_ID AND F.TIMEFRAME_PERIOD = U.TIMEFRAME_PERIOD AND U.FORECAST_SUBMITTED = 'Y' AND FCID.PERSON_ID_MANAGER = MGR.PERSON_ID_MANAGER AND F.PERSON_ID = MGR.PERSON_ID AND ((F.FROM_CUR = CUR.CURRENCY_CD AND F.FROM_CUR <> ' ' ) OR (F.FROM_CUR = ' ' AND S.CURRENCY_CD = CUR.CURRENCY_CD)) GROUP BY FCID.PERSON_ID_MANAGER , F.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 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
3 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
4 FORECAST_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Forecast Total