PC_HORIZON_VW

(SQL View)
 Index Back

Projects Forecast Horizons

This view selects the more current horizon for each BU GL that has just completed.

SELECT A.BUSINESS_UNIT_GL , MAX(A.BEGIN_DT) FROM PS_FC_CTRL_TBL A WHERE A.PERIOD = 1 AND A.STATUS = 'I' GROUP BY A.BUSINESS_UNIT_GL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 BEGIN_DT Date(10) DATE Begin Date