EDW Data Load Status

Last updated: January 5, 2023
Audience: StaffResearchersIT Staff / TechnicalDecision Makers

This page is meant to serve as an informational resource for users to view the most recent load times for the EDW Production and EDW Test environments. If you have questions about EDW’s data load frequency or availability that aren’t answered on this page, please contact: edw-help@uw.edu. If you have any other questions regarding the Enterprise Data Warehouse, please check to make sure that they are not answered on our Help: Enterprise Data Warehouse page.

When does EDW data load?

The data availability tables below show when and how frequently data is loaded into the EDW environment. The tables are organized by Subject Area and Data Component.

Note: The “Load Freq” indicates the days of the week after business hours that the data is loaded. For example, a “Load Freq” of “Daily: Mon-Fri” means that the data will be processed after business hours Monday through Friday and made available the next morning (Tuesday through Saturday).

EDW Production Data

The table below shows the most recent load times for the Enterprise Data Warehouse (EDW) PRODUCTION environment. For load status of the EDW Test environment, see EDW Test Data.



EDW Data Availability

Subject Area Data Component Load Freq Last Loaded
Academics Academic Data Store Daily: Sun-Fri 02/04/23 3:47AM
Core Data Funding Entity Core Data Management (FECDM) Daily: Mon-Fri 02/03/23 7:01PM
Geopolitical Entities, Names, and Codes (GENC) Weekly: Sunday 11/06/22 11:07PM
Financial Budget Index Daily: Mon-Sat 02/04/23 10:29PM
GL transactions Daily: Mon-Fri 02/03/23 8:04PM
Financial transactions Daily: Mon-Fri 02/03/23 8:14PM
UWODS financial data Daily: Mon-Sat 02/04/23 2:09AM
WDFinDataMart financial data Daily: Mon-Sat 02/04/23 1:50AM
WDFinDataMart financial journals Daily: Mon-Sat 02/04/23 2:02AM
WDFinDataMart payroll journals periodic 02/02/23 2:50AM
Human Resources - Legacy HEPPS Person, Employment, Financial (Projected Distributions) frozen as of 2017 10/16/17 2:06PM
Payment (Actual Distributions), Benefits, Faculty Bio frozen as of 2017 10/16/17 2:06PM
Check Register (Payment Verification) frozen as of 2017 06/20/17 12:35AM
Human Resources - Workday Daily load from Workday into HumanResources Daily: Sat-Thu 02/05/23 5:27AM
Daily load from Workday into IBS Daily: Sat-Thu 02/05/23 5:26AM
Daily load from Workday into ODS Daily: Sat-Thu 02/05/23 5:31AM
Paycalc load from Workday into HumanResources Twice monthly 01/21/23 7:49PM
Paycalc load from Workday into ODS Twice monthly 01/21/23 7:49PM
UWODS HR Data Daily: Mon-Sat 02/04/23 2:08AM
UWODS payroll results periodic 02/04/23 2:11AM
Institutional Base Salary IBS Projected/Pre-Award Daily: Mon-Sat 02/05/23 12:11AM
IBS UW Actual & Projected frozen as of 2017 06/20/17 5:11AM
IBS Actual monthly (day 5) 02/02/23 12:41AM
Master Data Organization Daily: Mon-Sat 02/04/23 10:29PM
Research Proposal, Award, and Expenditure data Daily: Sun-Sat 02/05/23 1:15AM


Note: If the data in the above table does not appear to be updating when you click the Refresh button, you may need to override your browser’s caching feature. In Firefox, Chrome, and Edge, you can override the caching by pressing Control-F5 with this page open. For more information, check your browser’s documentation, or see: Bypass your cache. There may be up to a 15 minute delay between the completion of the data load and the update of this page.

EDW Test Data

The data availability table below shows the most recent load times for the Enterprise Data Warehouse (EDW) TEST environment as a courtesy for partners working with the EDW on unreleased features and changes. The Load Freq column should not be relied upon, as the TEST environment is loaded on an ad hoc basis. For load status of the EDW Production environment, see EDW Production Data.



EDW Data Availability

Subject Area Data Component Load Freq Last Loaded
Academics Academic Data Store Daily: Sun-Fri 02/04/23 3:47AM
Core Data Funding Entity Core Data Management (FECDM) Daily: Mon-Fri 02/03/23 7:01PM
Geopolitical Entities, Names, and Codes (GENC) Weekly: Sunday 11/06/22 11:07PM
Financial Budget Index Daily: Mon-Sat 02/04/23 10:29PM
GL transactions Daily: Mon-Fri 02/03/23 8:04PM
Financial transactions Daily: Mon-Fri 02/03/23 8:14PM
UWODS financial data Daily: Mon-Sat 02/04/23 2:09AM
WDFinDataMart financial data Daily: Mon-Sat 02/04/23 1:50AM
WDFinDataMart financial journals Daily: Mon-Sat 02/04/23 2:02AM
WDFinDataMart payroll journals periodic 02/02/23 2:50AM
Human Resources - Legacy HEPPS Person, Employment, Financial (Projected Distributions) frozen as of 2017 10/16/17 2:06PM
Payment (Actual Distributions), Benefits, Faculty Bio frozen as of 2017 10/16/17 2:06PM
Check Register (Payment Verification) frozen as of 2017 06/20/17 12:35AM
Human Resources - Workday Daily load from Workday into HumanResources Daily: Sat-Thu 02/05/23 5:27AM
Daily load from Workday into IBS Daily: Sat-Thu 02/05/23 5:26AM
Daily load from Workday into ODS Daily: Sat-Thu 02/05/23 5:31AM
Paycalc load from Workday into HumanResources Twice monthly 01/21/23 7:49PM
Paycalc load from Workday into ODS Twice monthly 01/21/23 7:49PM
UWODS HR Data Daily: Mon-Sat 02/04/23 2:08AM
UWODS payroll results periodic 02/04/23 2:11AM
Institutional Base Salary IBS Projected/Pre-Award Daily: Mon-Sat 02/05/23 12:11AM
IBS UW Actual & Projected frozen as of 2017 06/20/17 5:11AM
IBS Actual monthly (day 5) 02/02/23 12:41AM
Master Data Organization Daily: Mon-Sat 02/04/23 10:29PM
Research Proposal, Award, and Expenditure data Daily: Sun-Sat 02/05/23 1:15AM



Note: If the data in the above table does not appear to be updating when you click the Refresh button, you may need to override your browser’s caching feature. In Firefox, Chrome, and Edge, you can override the caching by pressing Control-F5 with this page open. For more information, check your browser’s documentation, or see: Bypass your cache. There may be up to a 15 minute delay between the completion of the data load and the update of this page.