RSF_FCAST_TP_VW (SQL View)	Index Back
Active Forecast Ids Active Forecast Ids with Expected Forecast Date today or later This is used for Reporting only.

RSF_FCAST_TP_VW

(SQL View)

Active Forecast Ids

Active Forecast Ids with Expected Forecast Date today or later This is used for Reporting only.

SELECT FC.FORECAST_ID ,FORECAST_CATEGORY , TIMEFRAME_PERIOD ,FORECAST_DT FROM PS_RSF_FCAST FC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast

3 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
Prompt Table: %EDITTABLE

4 FORECAST_DT Date(10) DATE Date when forecast. The date the entire forecast was begun does not change, but the date per user does change with updates.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name
2	FORECAST_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Forecast Category R=Revenue Forecast S=Shadow Forecast
3	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame Prompt Table: %EDITTABLE
4	FORECAST_DT	Date(10)	DATE	Date when forecast. The date the entire forecast was begun does not change, but the date per user does change with updates.