Mission
The Data Warehouse is home to the University’s historical data about our institution, also known as the Decision Support Database (DSD). The historical data tables are “frozen” or extracted from other UA information systems at specific points in time. Our mission is to provide the UA community with the consistent, static data tables which serve as the foundation for the various needs of institutional reporting. The Data Warehouse is guided by the Institutional Research Shared Services Leadership Team.
Scheduled Data Freezes
Freeze dates for the upcoming year are set in coordination with key data stewards in each data area, the IR Directors and OIT. Here is a list of the confirmed 25-26 freeze dates and the links below show more details about the primary freezes.
The Student and Human Resources (HR) data freezes consist of two processes and dates:
- A data extract-raw data is exported from Banner production at approximately 5:00 pm.
- DSD table load-custom or aggregated tables are then generated in the DSDMGR schema (aka Decision Support Database).
Once the Data Warehouse freeze tables are finalized and ready to use, notifications
are sent to the Google Group ua-data-warehouse@alaska.edu. UA personnel may visit
and sign up to receive notifications. UA personnel with specific business data needs
may also request access to the Data Warehouse via OIT Banner access request forms.
Click each link below for dates and details.
| Summer 2025 | Fall Open 2025 | Fall Close 2025 | Spring Open 2026 | Spring Close 2026 |
|---|---|---|---|---|
| Extract: Aug 25, 2025 | Extract: Sep 22, 2025 | Extract: Jan 5, 2026 | Extract: Feb 9, 2026 | Extract: May 26, 2026 |
| DSD Load: Aug 26-28, 2025 | DSD Load: Sep 23-24, 2025 | DSD Load: Jan 6-8, 2026 | DSD Load: Feb 10-12, 2026 |
DSD Load: May 27-29, 2026 |
Student data freezes occur five times per year and include enrollment numbers, course registration
activity, demographics, and much more.
Open freezes are approximately three weeks after the start of the semester following the course add/drop deadline. (The summer semester does not have an open freeze. )