RSF_FCAST_CR_VW (SQL View)	Index Back
Revenue Forecast ID Compare VW Revenue Forecast ID Compare View

RSF_FCAST_CR_VW

(SQL View)

Revenue Forecast ID Compare VW

Revenue Forecast ID Compare View

SELECT TIMEFRAME_PERIOD , FORECAST_ID , FORECAST_DT FROM PS_RSF_FCAST WHERE STATUS = 'A' AND FORECAST_CATEGORY = 'R' AND FORECAST_ID <> ' ' AND FORECAST_DT IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

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

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	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame
2	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name
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.