RSFD_FC_TYPE_VW

(SQL View)
Index Back

Forecast Type in Dashboard

A view on forecast type descriptors for dashboard.

SELECT FORECAST_TYPE , DESCRSHORT , DESCR , STATUS FROM PS_RSF_FCAST_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FORECAST_TYPE Character(10) VARCHAR2(10) NOT NULL Type of forecast, eg 'Open' or 'closed'
2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive