EDW Data Load Status

Last updated: April 19, 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 sometime after 6PM Monday through Friday and made available by 7AM the next morning (Tuesday through Saturday). There is no set time when a process may start or complete as it is dependent on the amount of data we receive for that day. Our processes are setup to lock a given database as needed when data is being refreshed within it. This may result in an access denied type error or one related to a connection being forcibly closed.

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 06/09/23 4:01AM
Core Data Funding Entity Core Data Management (FECDM) Daily: Mon-Fri 06/08/23 7:01PM
Geopolitical Entities, Names, and Codes (GENC) Weekly: Sunday 05/28/23 11:03PM
Financial Budget Index Daily: Mon-Sat 06/08/23 7:13PM
GL transactions Daily: Mon-Fri 06/08/23 7:59PM
Financial transactions Daily: Mon-Fri 06/09/23 6:06AM
UWODS financial data Daily: Mon-Sat 06/09/23 1:19AM
WDFinDataMart financial data Daily: Mon-Sat 06/09/23 1:09AM
WDFinDataMart financial journals Daily: Mon-Sat 06/09/23 2:24AM
WDFinDataMart payroll journals periodic 06/08/23 1:19AM
WDFinDataMart HR\P data Daily: Mon-Sat 06/09/23 1:03AM
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 06/09/23 5:19AM
Daily load from Workday into IBS Daily: Sat-Thu 06/09/23 5:18AM
Daily load from Workday into ODS Daily: Sat-Thu 06/09/23 5:23AM
Paycalc load from Workday into HumanResources Twice monthly 06/08/23 7:33PM
Paycalc load from Workday into ODS Twice monthly 06/08/23 7:33PM
UWODS HR Data Daily: Mon-Sat 06/09/23 1:27AM
UWODS payroll results periodic 06/08/23 1:05AM
Institutional Base Salary IBS Projected/Pre-Award Daily: Mon-Sat 06/09/23 12:11AM
IBS UW Actual & Projected frozen as of 2017 06/20/17 5:11AM
IBS Actual monthly (day 5) 06/03/23 12:42AM
Master Data Organization Daily: Mon-Sat 06/08/23 7:13PM
Research Proposal, Award, and Expenditure data Daily: Sun-Sat 06/09/23 1:22AM


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 06/09/23 8:15AM
Core Data Funding Entity Core Data Management (FECDM) Daily: Mon-Fri 03/20/23 8:53AM
Geopolitical Entities, Names, and Codes (GENC) Weekly: Sunday 05/11/23 1:13PM
Financial Budget Index Daily: Mon-Sat 05/31/23 1:17PM
GL transactions Daily: Mon-Fri 03/20/23 10:02AM
Financial transactions Daily: Mon-Fri 03/20/23 10:24AM
UWODS financial data Daily: Mon-Sat 06/09/23 10:42AM
WDFinDataMart financial data Daily: Mon-Sat 06/09/23 10:39AM
WDFinDataMart financial journals Daily: Mon-Sat 06/09/23 11:16AM
WDFinDataMart payroll journals periodic 05/31/23 10:22AM
WDFinDataMart HR\P data Daily: Mon-Sat 06/06/23 11:53AM
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 03/20/23 3:51PM
Daily load from Workday into IBS Daily: Sat-Thu 03/20/23 3:31PM
Daily load from Workday into ODS Daily: Sat-Thu 03/20/23 4:06PM
Paycalc load from Workday into HumanResources Twice monthly 05/01/23 2:39PM
Paycalc load from Workday into ODS Twice monthly 05/01/23 2:39PM
UWODS HR Data Daily: Mon-Sat 06/06/23 12:18PM
UWODS payroll results periodic 05/31/23 8:51AM
Institutional Base Salary IBS Projected/Pre-Award Daily: Mon-Sat 02/11/22 12:16PM
IBS UW Actual & Projected frozen as of 2017 06/20/17 5:11AM
IBS Actual monthly (day 5) 08/23/21 2:46PM
Master Data Organization Daily: Mon-Sat 05/31/23 1:17PM
Research Proposal, Award, and Expenditure data Daily: Sun-Sat 03/20/23 10:42AM



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.