Support Available to Transition Human Resource/Payroll Data from ODS to UWODS
The Enterprise Data Warehouse (EDW) recently introduced two new databases to support UW Finance Transformation (UWFT): UWODS and WDFinDataMart. For more information, refer to EDW Databases and Resources Available to Support Finance Transformation.
The UWODS database, which goes live with UWFT, will enable EDW users to access Finance and Human Resource/Payroll (HRP) data from Workday. The UWODS will replace the current ODS database as the EDW resource for this data.
In the UWODS, the HRP data model is different than in the current ODS database. This change better reflects Workday’s HRP data structure and creates better parity between the UWODS and HRP Web Service (HRPWS). This better alignment allows the EDW to quickly adapt to future changes and provide more clarity and consistency to users who leverage this data.
Watch this short video for an introduction to how HRP data is changing in the UWODS:
Transition Support is Available
Documentation is available to help users transition from the ODS to UWODS for HRP data. Refer to the following pages to get started:
- Transitioning HR Data from ODS to UWODS – This resource guides users through the transition from ODS to UWODS, which includes:
- Mapping tables and columns from current to future state.
- Reviewing new HRP tables.
- Exploring HR Data Domain concepts and associated sample queries to help answer common questions.
- UWODS Customer Portal – This page provides additional information on this new database, including the different environments available and how to get started.
Additional Resources for Support
Join Us for 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 by to ask your UWODS questions.
You can either sign up ahead of time or drop by during the session:
Drop by – Zoom (During session only)
Subscribe to Our Email List
When you request access to UWODS, you are automatically added to the respective mailman list(s) to receive periodic communications related to these databases.
If you are not ready to get access, but want to stay in the loop, we encourage you to sign up for the following list today: uwods-ft-users
Email Us
If you have questions or would like to provide feedback, please write to edw-help@uw.edu with “UWODS” in the subject line.