RSF_FCFLT_BU_VW

(SQL View)
 Index Back

Forecast Filter Bus Unit VW


SELECT DISTINCT D.FORECAST_ID , D.TIMEFRAME_PERIOD , D.FORECAST_CATEGORY , D.BUSINESS_UNIT , BU.DESCR FROM PS_RSF_FCAST_DTL D , PS_BUS_UNIT_TBL_FS BU WHERE D.BUSINESS_UNIT = BU.BUSINESS_UNIT AND D.BUSINESS_UNIT <> ' '

  • Related Language Record: RSF_FCFLT_BU_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name
    2 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    3 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
    R=Revenue Forecast
    S=Shadow Forecast
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description