Thursday, July 30, 2009

7/28/2009 ASU EPM 9.0.60 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Student Records
    • Removed the following table from EPM which are no longer being used for reporting:
      • PS_ASU_RATA_HDR
      • PS_ASU_ADS_ETH_TBL

Changes to EPM Business Rules and Logic
- none

6/18/2009 ASU EPM 9.0.58 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Human Resources
    • Changed table FW_TRANSACTION_DETAIL_JV, adding 4 columns (FISCAL_MONTH, TRANSACTION_DOCUMENT_CODE, OBJECT_CODE, EXPENDITURE_CODE)
    • PS_EG_OTH_DPT_TBL (new)

  • Admissions
    • Changed table PS_ASU_ACADP_EXTNS, adding 4 columns (ASU_ACADP_LRF_TEXT, ASU_MATH_REQ_FLAG, ASU_ACADP_MRF_CRSE, ASU_ACADP_MRF_TEXT)
    • Changed table PS_ASU_AD0010_PROG, adding CAMPUS column

  • DARS (peoplesoft)
    • PS_ASU_DARS_XWALK (new)

Changes to EPM Business Rules and Logic
  • Added one more object code, 7200, to the transactions sent nightly from the legacy financial warehouse to EPM: This results in additional transactional data in: FW_TRANSACTION_DETAIL_JV, ASU_BPC_VW, ASU_BPC_VW_ALL, ASU_BPC_VW_2009.

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