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 05/30/12 5:14AM
Census Day Counts quarterly 04/07/12 4:40PM
Enrollments & Degrees daily 05/30/12 9:03AM
Financial Budget Index daily 05/30/12 6:47PM
GL transactions daily 05/30/12 7:37PM
Financial transactions daily 05/30/12 8:23PM
Financial Activity cube daily 05/30/12 9:02PM
Human Resources Person, Employment, Financial (Projected Distributions) daily 05/29/12 9:15PM
Payment (Actual Distributions), Benefits, Faculty Bio pay calc 05/22/12 9:42AM
Check Register (Payment Verification) pay calc 05/21/12 11:14PM
Institutional Base Salary IBS Projected/Pre-Award daily 05/30/12 12:01AM
IBS Actual monthly (day 5) 05/05/12 12:31AM
Master Data Organization daily 05/30/12 6:40PM
Research Administration Data Proposals & Awards daily 05/30/12 4:03AM