Decision Support

Alerts

RSS Feed

No system alerts at this time.

News

EDW's Academic Data Store (UWSDBDataStore) Reorg on May 19

UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg. Learn more... (5/14/2012)

New Look!
The Decision Support Web site has been updated. Learn more... (3/5/2012)

EDW Infrastructure Improvements Coming
The EDW is completing a two-part effort to increase capacity and data availability. Learn more... (3/5/2012)

EDW Minor Reorg on March 6
Two columns are being resized in the Academic Data Store. Learn more... (3/5/2012)

New EDW Models and Data Definitions Available
Check out the interactive models and definitions. Learn more... (1/17/2012)

Other Recent Headlines

The Decision Support Web site provides a single point of access to information for users and developers of Enterprise Data Warehouse (EDW) data and tools. It addresses questions about access, database connections, report writing and deployment, query writing, available data, and more. Here you will find answers, with self-service access to a centralized set of data and tools, standards and best practices, to help ensure consistent use of institutional data across multiple functional areas and units.

Data Availability Summary

The following chart shows when data was last loaded, how frequently the data is loaded (Load Freq), displayed by Subject Area and Data Component.

EDW Data Availability
Subject Area Data Component Load Freq Last Loaded
Academics Academic Data Store daily Loading...
Census Day Counts quarterly 04/07/12 4:40PM
Enrollments & Degrees daily 05/15/12 9:04AM
Financial Budget Index daily 05/15/12 6:49PM
GL transactions daily 05/15/12 8:27PM
Financial transactions daily 05/15/12 8:42PM
Financial Activity cube daily 05/15/12 9:06PM
Human Resources Person, Employment, Financial (Projected Distributions) daily 05/15/12 11:00PM
Payment (Actual Distributions), Benefits, Faculty Bio pay calc 05/05/12 2:39AM
Check Register (Payment Verification) pay calc 05/04/12 10:51PM
Institutional Base Salary IBS Projected/Pre-Award daily 05/16/12 12:01AM
IBS Actual monthly (day 5) 05/05/12 12:31AM
Master Data Organization daily 05/15/12 6:42PM
Research Administration Data Proposals & Awards daily 05/16/12 4:03AM