RSF_FCAST_SE_VW (SQL View)	Index Back
Existing Shadow Forecasts Used on original configurable search page for 'existing' shadow forecasts.

RSF_FCAST_SE_VW

(SQL View)

Existing Shadow Forecasts

Used on original configurable search page for 'existing' shadow forecasts.

SELECT F.OPRID , F.TIMEFRAME_PERIOD , F.FORECAST_CATEGORY , F.PERSON_ID , F.FORECAST_ID , F.FORECAST_EXPECT_DT , F.BEGIN_DT , F.END_DT , U.PERSON_ID , U.FORECAST_DT , F.SYNCID , F.SYNCDTTM FROM PS_RSF_FCAST_OP_VW F , PS_RSF_FCAST_USER U WHERE F.FORECAST_CATEGORY = 'S' AND 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 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
Prompt Table: %EDITTABLE2

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

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

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

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

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

12 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	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame Prompt Table: %EDITTABLE2
3	FORECAST_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Forecast Category R=Revenue Forecast S=Shadow Forecast
4	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
5	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name
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_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.
11	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.
12	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time