BI Releases
Title | Description/Details |
Profit and Loss (P&L) report | Report officially deployed to run using Snowflake; performance enhancements made |
Tableau server | Standard review committee formed |
Data Governance Program | New domain area and data steward added to system |
11 institutional data products | Publication and modification review and processing |
1 new institutional data definitions | Review and processing, BICoE approved, led by ODMAS |
Data Warehouse Updates
Title | Description/Details |
UW.UA_MARCH_PAYROLL UW.UA_OCTOBER_PAYROLL UW.UA_MONTHLY_PAYROLL UW.UA_MONTHLY_PAYROLL_ALL |
All the 2020 payroll/position reporting snapshot data was reloaded due to a UW System HRS integration problem. The problem was caused by the HRS FLSA changes that took effect January 2020. Certain positions were excluded from the HRS to Position Reporting system feed. The issue was resolved in the Position Reporting System and the data was reloaded to the data warehouse. |
DM.ACAD_DEPARTMENT_DIM | There were additions and changes to Academic Structure department dimension. These fields are now sourced from a new table: DEPARTMENT_TENURE_INDICATOR DEPARTMENT_RECOGNITION DEPARTMENT_DIVISION_OWNER These fields were added: DEPARTMENT_DISCIPINARY_DIV DEPARTMENT_NSF_DISC_INDICATOR |