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