Friday, September 12, 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_AUDIT_ASU_AI10 (CRM #313183)
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)
Friday, September 5, 2008
Three new views and one new table have been added to the Human Resources Data Warehouse:
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.
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.
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.