Tuesday, March 31, 2009

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

Sunday, March 22, 2009

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

Monday, March 16, 2009

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

Thursday, March 12, 2009

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

Tuesday, March 3, 2009

3/2/2009 ASU EPM 9.0.45 Release Notes

New or Changed Tables and Views

  • Operational Warehouse Staging (OWS) Tables/Views
    • Student Records
      • PS_CLST_DETL_TBL
    • Human Resource
      • PS_EG_ADMIN_POSTS