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

4/2/2009 ASU EPM 9.0.52 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views
• Hyperion Repository
• HY_V8_EVENT_VW_P
• HY_V8_QUERY_VW_P
• HY_V8_OBJECT_VW_P
• HY_V8_USER_VW_P

• FAR (Faculty Activity Report)
• FAR_MENTORING
• FAR_ENCYCLOPEDIAARTICLES

• Event Tracking
• ET_TBL_EVENT_TYPE

• DARS
• DA_JOB_QUEUE_DETAIL
• DA_JOB_QUEUE_RUN
  

Changes to EPM Business Rules and Logic

• Directory Services table (PS_ASU_DIRECT_SRVC) – TITLE field now reflects working titles. Specifically, TITLE will be employee’s Primary job position working title, if it exists, otherwise the title reflects the employee’s Primary job jobcode description.