EDW for Finance Transformation Release 19 is Now Available

April 4, 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 19

Database	Overview of Release
UWODS	This release includes 20 new tables and 156 columns were added to existing tables. Introduced Breaking Changes by removing columns from a table. New or Revised Frequently Asked Questions (FAQ) available – See FAQ \| UWODS to learn more about this updated FAQ! Known Data Issues are as follows: Some Tables are missing data. See: Tables Missing Data \| UWODS Truncated data due to bad test data not following expected standards Some definitions are unknown For more information, refer to UWODS – Release 19. For support, refer to Support l UWODS.
WDFinDataMart	This release includes 1 new table with 26 fields, including: RecordLoadDttm RecordUpdateDttm Updates to 2 existing tables with new fields to both tables Updates to 4 existing views with new fields to all views There were no Breaking Changes for this release. New or Revised Frequently Asked Questions (FAQ) available – See FAQ l WDFinDataMart to learn more about this updated FAQ! 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 – Release 19. For Support, refer to Support l WDFinDataMart

Database

Overview of Release

UWODS

This release includes 20 new tables and 156 columns were added to existing tables.
Introduced Breaking Changes by removing columns from a table.

New or Revised Frequently Asked Questions (FAQ) available – See FAQ | UWODS to learn more about this updated FAQ!

Known Data Issues are as follows:

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

For more information, refer to UWODS – Release 19. For support, refer to Support l UWODS.

WDFinDataMart

This release includes 1 new table with 26 fields, including:
- RecordLoadDttm
- RecordUpdateDttm
Updates to 2 existing tables with new fields to both tables
Updates to 4 existing views with new fields to all views
There were no Breaking Changes for this release.

New or Revised Frequently Asked Questions (FAQ) available – See FAQ l WDFinDataMart to learn more about this updated FAQ!

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 – Release 19. 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 Emerging Guidance for Writing Code Using Finance Data in WDFinDataMart and UWODS

We have provided a link on the UWODS and WDFinDataMart Sample Queries pages that take you to a resource where you can find sample queries for common finance related questions. This resource is under construction and restricted to current EDW and BI Portal finance data viewers. Use at your own risk.

You will find this link under the Finance Data Concepts and Queries section on these pages:

Upcoming Data Tenant Changes in EDP for FT Environments

Some EDP environments will be subject to multiple data tenant switches during the month of April to support various UWFT activities. If you are accustomed to using the following environments for your development and testing work, these environments may not reflect the data you think it should during this time:

UWODS TEST
WDFinDataMart TEST

For more information, including the schedule, recommended actions, and guidance on how to access more reliable data during this time, refer to Important Notice – Upcoming Data Tenant Changes in EDP for Finance Transformation Environments.

Join Us for Enterprise Reporting and Analytics (ERA) Office Hours

EDW Subject Matter Experts are now available during the Enterprise Reporting and Analytics (ERA) Office Hours every Friday from 9 to 10.
Please drop in to ask your UWODS and WDFinDataMart questions. You can either sign up ahead of time or drop by during the session:

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.

New EDP for FT Resource Available

EDP for Finance Transformation offers services that reflect the Foundation Data Model (FDM) and Finance Reference Data; however, because the changes to finance data are so transformational, we are not able to answer questions that are specific to your unit or provide guidance on how to use this data. Fortunately, there are various UWFT resources available to help with this aspect of the transformation and we’ve compiled a list of these resources on the Resources for Understanding Finance Transformation page. We will update this page as more resources are identified, so please watch for updates.