RSF_FCASTIDA_VW (SQL View)	Index Back
Active Forecast Ids Active Forecast Ids with Expected Forecast Date today or later. This is used for Reporting only.

RSF_FCASTIDA_VW

(SQL View)

Active Forecast Ids

Active Forecast Ids with Expected Forecast Date today or later. This is used for Reporting only.

SELECT DISTINCT FC.FORECAST_ID , ID.DESCR , ID.STATUS , ID.FORECAST_DT FROM PS_RSF_FCAST_ID ID , PS_RSF_FCAST FC WHERE ID.FORECAST_ID = FC.FORECAST_ID

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.

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