April 2021 Release Notes

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
Skip to content