RSF_FCFLT_TN_VW

(SQL View)
Index Back

Forecast Filter Tree View


SELECT DISTINCT FORECAST_ID , TIMEFRAME_PERIOD , FORECAST_CATEGORY , TREE_NAME FROM PS_RSF_FCAST_D_VW WHERE TREE_NAME <> ' '

# 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 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name