RSF_FCAST_ID_VW (SQL View)	Index Back
Active Forecast Ids Active Forecast Ids with Expected Forecast Date today or later

RSF_FCAST_ID_VW

(SQL View)

Active Forecast Ids

Active Forecast Ids with Expected Forecast Date today or later

SELECT FORECAST_ID , DESCR , STATUS , FORECAST_DT , SYNCID , SYNCDTTM FROM PS_RSF_FCAST_ID WHERE STATUS = 'A' AND FORECAST_DT <= %CurrentDateIn

Related Language Record: RSF_FCAST_IDLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORECAST_ID	Character(15)	VARCHAR2(15) NOT NULL	Forecast Name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
4	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.
5	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.
6	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time