RSF_FCAST_PR_VW (SQL View)	Index Back
Sales Rep Revenue Forecast VW View of all Sales Rep Revenue Forecasts

RSF_FCAST_PR_VW

(SQL View)

Sales Rep Revenue Forecast VW

View of all Sales Rep Revenue Forecasts

SELECT DISTINCT FORECAST_CATEGORY , PERSON_ID , EST_CLOSE_DT FROM PS_RSF_FCAST_OR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORECAST_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Forecast Category R=Revenue Forecast S=Shadow Forecast
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	EST_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity