IT Connect

Information technology tools and resources at the UW

Data Loading Summary

The data summary table shows when and how frequently data is loaded into the Enterprise Data Warehouse. The table is organized by Subject Area and Data Component.
EDW Data Availability

Subject Area Data Component Load Freq Last Loaded
Academics Academic Data Store daily 01/19/18 3:29AM
Financial Budget Index daily 01/18/18 7:32PM
GL transactions daily 01/18/18 8:09PM
Financial transactions daily 01/19/18 5:11AM
Financial Activity cube daily 01/18/18 7:42PM
Human Resources - Legacy HEPPS Person, Employment, Financial (Projected Distributions) daily 10/16/17 2:06PM
Payment (Actual Distributions), Benefits, Faculty Bio pay calc 10/16/17 2:06PM
Check Register (Payment Verification) pay calc 06/20/17 12:35AM
Human Resources - Workday Daily load from Workday into HumanResources daily 01/19/18 3:43AM
Daily load from Workday into IBS daily 01/19/18 3:42AM
Daily load from Workday into ODS daily 01/19/18 3:45AM
Paycalc load from Workday into HumanResources pay calc 01/09/18 8:12PM
Paycalc load from Workday into ODS pay calc 01/09/18 8:16PM
Institutional Base Salary IBS Projected/Pre-Award daily 01/19/18 12:11AM
IBS UW Actual & Projected pay calc 06/20/17 5:11AM
IBS Actual monthly (day 5) 01/05/18 12:41AM
Master Data Organization daily 01/18/18 7:32PM
Research Administration Data Proposals & Awards daily 01/19/18 1:16AM
Research Awards Cube daily 01/19/18 1:36AM