Monday, June 8, 2009

ASU EPM 9.0.57 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Human Resources
    • ASU_NOA_EE_EXCL
    • ASU_NOA_EE_HIST
    • ASU_NOA_GRP_TBL
    • ASU_NOA_NOSP_VW
    • ASU_NOA_OVRD_VW
    • ASU_NOA_SPON_VW
    • ASU_NOA_TENR_VW
    • ASU_NOA_TENS_VW
    • ASU_NOA_CURR_VW
    • ASU_NOA_EMPL_VW
    • ASU_NOA_MSS_VW
    • PS_DEPT_SEC_SRCH
  • Student Records
    • JOB_QUEUE_LIST
Changes to EPM Business Rules and Logic - None

Monday, June 1, 2009

06/01/2009 ASU EPM 9.0.56 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views
  • Human Resources
    • ASU_BPC_VW_2009:
      1. Added manual transactions from Advantage
      2. Adjusted fiscal year cutoff logic to use

    • FW_XWALK_FYFM_TO_PS_DATES:
      1. Defined cutoff dates for Distributions and Redistributions

    • FW_TRANSACTION_DETAIL_JV:
      1. Contains manual JVs entered in Advantage for salaries and wages

  • Student Financials
    • PS_GROUP_LINE


Monday, May 11, 2009

5/11/2009 ASU EPM 9.0.55 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Student Financials
    • PS_ASU_SF_FEE_RATE
    • PS_ASU_SF_FEECDDSC
    • PS_ASU_SF_RATETYPE
    • PS_ASU_SF_TUIT_GRP
    • PS_ASU_SF_TUIT_DT

Friday, May 1, 2009

04/30/2009 ASU EPM 9.0.54 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views
  • Financial Aid
    • PS_SCC_CKLSITM_TBL
    • PS_VAR_DATA_FINA
  • Human Resources
    • ASU_BPC_VW_2008:
      • Added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
      • Adjusted logic to filter out PeopleSoft 2008 distributions with Pay Period End Date >= 7/25/08, and PeopleSoft 2008 redistributions with GL Post Dt >= 7/14/08.
    • ASU_BPC_VW_2009: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • ASU_BPC_VW_ALL: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • ASU_BPC_VW: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • Dropped table LG_APPROPRIATION_TRANSACTION. It has been reincarnated as FW_APPROPRIATION_TRANSACTION.
    • PS_ASU_PERS_AFF_SB: changed structure to match changes made to Sub Affiliation data structures in PeopleSoft.
    • PS_ASU_SUBAFIL_TBL: changed structure to match changes made to Sub Affiliation data structures in PeopleSoft.

Changes to EPM Business Rules and Logic
  • PS_ASU_DIRECT_SRVC (Directory Services): modified logic to use changed data structures in Sub Affiliation source tables

Friday, April 10, 2009

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

Thursday, April 2, 2009

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.

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