EPM 9.0.34 Release Notes

09/10/2008 ASU EPM 9.0.34 Release Notes - available 09/11/2008

New or Changed Tables and Views

Changed: Operational Warehouse Staging (OWS) Tables/Views. These record definitions were altered to match changes in PeopleSoft SAPRD:

PS_ASU_AI0008_PLAN (CRM #312173)
PS_ASU_AI0008_TRAC
PS_ASU_AI0008_REQ
PS_ASU_AI0008_TERM
PS_ASU_AI0008_CTVW
PS_ASU_AI0008_V1
PS_ASU_AI0008_V2
PS_AUDIT_ASU_AI10 (CRM #313183)
PS_ASU_AI10_STDNT1
PS_ASU_AI10_WORKLD
PS_ ASU_SFSTDRES_VW (CRM #312506)

New: Operational Warehouse Staging (OWS) Tables/Views in Student Records mart:

PS_HOME_CAMPUS_TBL (CRM #309127)

Changes to EPM Business Rules and Logic

Multi-Dimensional Warehouse Tables/Views

PS_ASU_D_PERSON and PS_ASU_D_PERSON_VW: resolved delivered Oracle issue preventing future-dated person attributes from being reflected consistently (CRM #313577)

Budget Position Control Dashboard Search Enhancement

The Budget Position Control 2009 dashboard search capabilities have been enhanced. You now have the ability to search by department, account, position, or employee id from any dashboard page, not just the initial page.

Budget Position Control Status Update

An update on Budget Position Control:

DATA WAREHOUSE

Three new views and one new table have been added to the Human Resources Data Warehouse:

ASU_BPC_VW_2008
ASU_BPC_VW_2009
ASU_BPC_VW
ST_ORIGINAL_BUDGET

The ASU_BPC_VW views contain BPC related information consolidated from several sources. Data includes Fiscal Year, Account, Position Number, Employee ID, Original Budget, Budget Adjustments, Expense, Encumbrance, and budgeted FTE. The Original Budget and budgeted FTE are sourced from STAR. The Expense and Encumbrance amounts originate from the PeopleSoft. The Budget Adjustments come from the Advantage fed Financial data warehouse. The ASU_BPC_VW combines all fiscal years in a single view.

ST_ORIGINAL_BUDGET contains the data that has been interfaced from STAR into the Human Resource Data Warehouse that was used for the ASU_BPC_VW_2009.
As of today these views and table are available to My Reports users; however, the budget amounts are not yet complete. State budgets are loaded but not yet finalized. Local budgets are expected to be loaded during September.

MY REPORTS

A new query, Budget Position Control.bqy is available in the Human Resource folder. Some enhancements have been added to the BPC 2008 query. Fund, ABOR classification, and Grade have been added.

DASHBOARDS

The BPC 2009 dashboard went into Production 9/4/2008 at http://dashboards.asu.edu. The BPC 2008 dashboard has been removed from the main dashboard menu but can be accessed from within the BPC 2009 dashboard.