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
Google Groups 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. )
Closing freezes are approximately three weeks after the end of a semester (not including holiday breaks) following the faculty grade deadline.
Data Warehouse (DSD) Summary Tables Include:
- DSD_APS_STUDENTS
- DSD_AEG_STUDENTS
- DSD_DUAL_ENROLLMENT
- DSD_HSCHOOL
- DSD_REGISTRATION
- DSD_SECTION
- DSD_STUDENT_DEMOG
- DSD_STUDENT_CURRICULUM
- DSD_STUDENT_STATISTICS
- DSD_STUDENT_TEST_SCORES
- DSD_UA_SCHOLARS
| Summer A 2025 (FY25) | Summer B 2025 (FY26) | Fall 2025 (FY26) | Spring 2026 (FY26) |
|---|---|---|---|
| Extract: June 11, 2025 | Extract: Aug 12, 2025 | Extract: Oct 13, 2025 | Extract: April 13, 2026 |
| DSD Load: June 11-13, 2025 | DSD Load: Aug 13-15, 2025 | DSD Load: Oct 14-16, 2025 | DSD Load: April 14-16, 2026 |
Human Resource freezes occur four times per year, each Fall and Spring semester and twice in Summer.
The HR freezes include personnel data such as employee and faculty assignment info, job classifications, demographics, and more.
Data Warehouse (DSD) Summary Tables Include:
- H_ASSIGNMENT
- H_DEMOGRAPHICS
- H_DISTRIBUTION
- H_EMPLOYEE
- H_FACULTY
| Aid Year 24-25: Late (Intermediate) | Aid Year 24-25: Final | Aid Year 25-26: Early (Preliminary) |
|---|---|---|
| July 7-8, 2025 | October 1-3, 2025 |
October 1-3, 2025 |
The Financial Aid year ends on September 30 and begins on October 1. This means that in October, the
financial aid data is frozen once to conlcude the aid year that is closing (Final),
then again to initiate the tables for the new, upcoming aid year (Early/Preliminary).
A freeze of intermediate data is also taken in July (Late).
Financial aid data includes FAFSA data, totals of aid dollars awarded, and various sources of scholarships and financial aid.
Data Warehouse (DSD) Summary Tables Include:
- FINAID_AWARD
- FINAID_ACPE_PRIORITY
- FINAID_FAFSA
- FINAID_FUND_DATA
- FINAID_RBRACMP
- FINAID_PAID
Appending _LATE and _EARLY to the above tables will provide the corresponding data for those freezes.
| FY 25: Preliminary | FY 25: Final |
|---|---|
| July 21-23, 2025 | October 20-21, 2025 |
The Research freeze occurs twice per year following the close of the fiscal year and the summer
semester.
Research tables contain data on the University's various grant-funded and capital research expenditures, research themes, and the revenue generated as a result of the research.
Data Warehouse (DSD) Summary Tables Include:
- SPONSORED_PROG_EXPEND
- SPONSORED_PROG_FUND
- SPONSORED_PROG_THEMES
Automated Snapshots and Annual Data Freezes
Daily
- Early Semester Report (ESR) Tables:
- Admissions Applications
- Course Enrollment
- Projected Tuition
- Select Human Resource Tables
Monthly
- Degrees Awarded
- BOR Structure Updates
- follows finance close - Cycle, Cycap, Updates
- follows BOR Updates
Annual
- IPEDS/ Title III Data - November
- NSC Data Import - November
- Finance FTV Updates - July
- Final Degrees Awarded -
August
|
Data Warehouse (DSD) Summary Tables Include: |
||
|
|
|