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.
  

3/31/2009 ASU EPM 9.0.51 Release Notes

Retired Tables (these objects will no longer be available for reporting)

• Operational Warehouse Staging (OWS) Tables/Views

• Student Financials
• PS_SF_ACCTG_LN
• PS_TUIT_CALC_TBL
• PS_CREDIT_HISTORY

Changes to EPM Business Rules and Logic - None

Two New Human Resource Profile Views!

Two new views have been added that will make reporting easier and more flexible. The new views are:

• ASU_EMP_JOB_PROFILE_VW
• ASU_EMP_JOB_PROFILE_CURR_VW
  

ASU_EMP_JOB_PROFILE_VW contains Job snapshots taken after each Pay End Dt. The view is a snapshot per pay period, of all active jobs and jobs terminated during the pay period.

ASU_EMP_JOB_PROFILE_CURR_VW contains just the most recent snapshot of Job data from ASU_EMP_JOB_PROFILE_VW.

More information can be found at: Data Dictionary: ASU_EMP_JOB_PROFILE_VW.

3/19/2009 ASU EPM 9.0.48 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views

• Student Finance
• PS_ASU_FA_ITEM_SUP
• PS_ITEM_TYPE_FA_VW
• PS_ITEM_TYPE_VW
• PS_ASU_FA_ITEM_REQ
• PS_ADM_MC_VW
• PS_AID_YR_CAR_TERM
• PS_ASU_FA_ADV_VW
• PS_ASU_FA_FTF_VW
• PS_ASU_FA_RES_VW
• PS_ASU_FA_ITEM_VW
• PS_ASU_FA_ATRBT_VW

• HR
• PS_ASU_PY_CHK_ERNS

Changes to EPM Business Rules and Logic - None

3/16/2009 ASU EPM 9.0.46 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views
• Human Resources

• FW_ACCOUNT: refreshed nightly from ACCOUNT table from Financial data warehouse on Enterprise1

• Faculty Activity Report

• FAR_COMMUNITYSERVICES
• FAR_HONORS
• FAR_BOOKREVIEWS
• FAR_MONETARYAWARDPURPOSES
• FAR_MONETARYAWARDS
• FAR_NONREFEREEDARTICLES
• FAR_PROFESSIONALSERVICES
• FAR_REFEREEDARTICLES
• FAR_SHORTSTORIES
• FAR_UNIVERSITYSERVICES
• FAR_EVALUATIONS

• Multi-Dimensional Warehouse (MDW) Tables/Views
• Human Resources
• ASU_EMP_JOB_PROFILE_VW: contains Job snapshots taken after each Pay End Dt. The view is a snapshot per pay period, of all active jobs and jobs terminated during the pay period.
• ASU_EMP_JOB_PROFILE_CURR_VW: view providing just the most recent snapshot of Job data from ASU_EMP_JOB_PROFILE_VW

Changes to EPM Business Rules and Logic

• PS_ASU_HR158_VW: modified logic behind the view, to significantly improve performance. The view may now return different results in some cases, due to improvements and changes in source tables and derivation logic. There is discussion of retiring PS_ASU_HR158_VW; recommend use of ASU_EMP_JOB_PROFILE_VW or ASU_EMP_JOB_CURR_VW

3/11/2009 ASU EPM 9.0.44 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views

• Human Resource
• PS_PAY_CHECK_EARNS

• Transcript Audit
• PS_ASU_SR0138_C_RH
• PS_ASU_SR0138_C_RD
• PS_ASU_SR0138_C_TR
• PS_ASU_SR0138_C_RC
• PS_ASU_SR0138_C_HC
• PS_ASU_SR0138_D_RH
• PS_ASU_SR0138_D_RD
• PS_ASU_SR0138_D_RE

• Changes to EPM Business Rules and Logic - None