RSF_FCAST_SR_VW (SQL View)	Index Back
New SalesRep Forecasts Used on original configurable search page for 'new' sales rep forecasts.

RSF_FCAST_SR_VW

(SQL View)

New SalesRep Forecasts

Used on original configurable search page for 'new' sales rep forecasts.

SELECT F.OPRID , F.FORECAST_ID , F.TIMEFRAME_PERIOD , F.FORECAST_CATEGORY , F.PERSON_ID , F.FORECAST_EXPECT_DT , F.BEGIN_DT , F.END_DT , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST_OP_VW F WHERE NOT EXISTS ( SELECT 'X' FROM PS_RSF_FCAST_USER U WHERE F.FORECAST_ID = U.FORECAST_ID AND F.TIMEFRAME_PERIOD = U.TIMEFRAME_PERIOD AND F.FORECAST_CATEGORY = U.FORECAST_CATEGORY AND F.PERSON_ID = U.PERSON_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name
Prompt Table: %EDITTABLE

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

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

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

6 FORECAST_EXPECT_DT Date(10) DATE Expected Forecast Date

7 BEGIN_DT Date(10) DATE Begin Date

8 END_DT Date(10) DATE This field stores the end date values.

9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name Prompt Table: %EDITTABLE
3	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame Prompt Table: %EDITTABLE2
4	FORECAST_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Forecast Category R=Revenue Forecast S=Shadow Forecast
5	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
6	FORECAST_EXPECT_DT	Date(10)	DATE	Expected Forecast Date
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	This field stores the end date values.
9	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time