EDW for Finance Transformation Release 16 is Now Available

January 10, 2023

Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation.

Monthly Scheduled Releases

Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline.

What’s New in EDW Release 16

Database	Overview of Release
UWODS	This release includes 16 new tables. An additional 41 columns were added to existing tables. Introduced Breaking changes by renaming and removing fields in multiple tables. Known Data Issues are as follows: Some Tables are missing data. See: UWODS Tables Missing Data Truncated data due to bad test data not following expected standards Some definitions are unknown New Frequently Asked Questions (FAQ) available – See UWODS’s FAQs to learn more about this updated FAQ! I use several ODS tables (for example, Person, JobProfile, etc.). Where should I look for comparable data in the future? What is the new/future version of the ODS table currently called BudgetActivityDetail? Is that table continuing? What’s the difference between a WID and a RefID? For more information, refer to UWODS EDW Release 16. For support, refer to Support l UWODS.
WDFinDataMart	No new tables were added in R16. A breaking change was introduced by removing a single field from an existing table in R16. Known Data Issues Some Tables are missing data. See: Tables Missing Data \| WDFinDataMart Truncated data due to bad test data not following expected standards Some definitions are unknown For more information, refer to WDFinDataMart EDW Release 16. For Support, refer to Support l WDFinDataMart

Database

Overview of Release

UWODS

This release includes 16 new tables. An additional 41 columns were added to existing tables.
Introduced Breaking changes by renaming and removing fields in multiple tables.

Known Data Issues are as follows:

- Some Tables are missing data. See: UWODS Tables Missing Data
- Truncated data due to bad test data not following expected standards
- Some definitions are unknown

New Frequently Asked Questions (FAQ) available – See UWODS’s FAQs to learn more about this updated FAQ!

I use several ODS tables (for example, Person, JobProfile, etc.). Where should I look for comparable data in the future?
What is the new/future version of the ODS table currently called BudgetActivityDetail? Is that table continuing?
What’s the difference between a WID and a RefID?

For more information, refer to UWODS EDW Release 16. For support, refer to Support l UWODS.

WDFinDataMart

No new tables were added in R16.
A breaking change was introduced by removing a single field from an existing table in R16.

Known Data Issues

Some Tables are missing data. See: Tables Missing Data | WDFinDataMart
Truncated data due to bad test data not following expected standards
Some definitions are unknown

For more information, refer to WDFinDataMart EDW Release 16. For Support, refer to Support l WDFinDataMart

EDW Release Schedule

We have already started working on next month’s release. Bookmark Release Notes | UWODS and Release Notes | WDFinDataMart to follow our progress.

Support Available to Transition Human Resource/Payroll Data from ODS to UWODS

When UW Finance Transformation (UWFT) goes live, the current state ODS database will be frozen and the UWODS database will be introduced. For more information, refer to Transitioning HR Data from ODS to UWODS.

New EDW Data Load Status for Production and Test Environments

Based on our requests from customers, we have published a new stand alone EDW Data Load Status page for both EDW Production and Test environments. This replaces the Data Load Status information that was previously embedded in the EDW help page. Please update your bookmarks accordingly.