RSF_FCAST_QT_VW

(SQL View)
Index Back

Timeframe view

Used as prompt for query

SELECT TIMEFRAME_PERIOD ,FORECAST_ID ,FORECAST_CATEGORY ,STATUS FROM PS_RSF_FCAST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

Prompt Table: %EDITTABLE

2 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name

Prompt Table: RSF_FCAST_ID

3 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast
4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A