RSF_FCAST_SV_VW (SQL View)	Index Back
Sales user Revene Forecasts Sales user Revene Forecasts used by Sales Viewer

RSF_FCAST_SV_VW

(SQL View)

Sales user Revene Forecasts

Sales user Revene Forecasts used by Sales Viewer

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 , U.PERSON_ID , U.FORECAST_SUBMITTED , U.FORECAST_DT , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST_OP_VW F , PS_RSF_FCAST_USER U WHERE '1' = '2'

# 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 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

10 FORECAST_SUBMITTED Character(1) VARCHAR2(1) NOT NULL Submit status for forecast.
N=No
Y=Yes
Y/N Table Edit
Default Value: N

11 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.

12 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.

13 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	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
10	FORECAST_SUBMITTED	Character(1)	VARCHAR2(1) NOT NULL	Submit status for forecast. N=No Y=Yes Y/N Table Edit Default Value: N
11	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.
12	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.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time