04/09/2009 ASU EPM 9.0.53 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views
  
  • Human Resource
    
    • ASU_BPC_VW_ALL (new) - has all available years of BPC data (currently 2008 and 2009)
      
    • ASU_BPC_VW (changed) – will always have current year(s) only, similar to Transaction Detail data in the legacy Financial warehouse. Presently this view contains 2009 only.
      
    • ASU_BPC_VW_2008 (changed) – the view has been 'materialized', or frozen; querying the view should be much faster
      
    • FW_APPROPRIATION_TRANSACTION table (new): loaded nightly from APPROPRIATION_TRANSACTION table from legacy Financial warehouse on Enterprise1