RSFD_FCST_ID_VW (SQL View)	Index Back
Dashboard forecasts Forecasts for dashboard: those with submitted users

RSFD_FCST_ID_VW

(SQL View)

Dashboard forecasts

Forecasts for dashboard: those with submitted users

SELECT DISTINCT FORECAST_ID ,TIMEFRAME_PERIOD ,FORECAST_DT FROM PS_RSF_FCAST_USER WHERE FORECAST_CATEGORY = 'R' AND FORECAST_SUBMITTED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name
Prompt Table: RSF_FCAST_ID

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

3 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 Prompt Table: RSF_FCAST_ID
2	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame Prompt Table: %EDITTABLE
3	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.