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.
Looking for the Data Warehouse Project?
The Data Warehouse Modernization Initiative launched in 2023 to secure a modern technology solution to allow the warehouse to better support the University's evolving data needs.
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 are the confirmed 24-25 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.
| Summer 2024 | Fall Open 2024 | Fall Close 2024 | Spring Open 2025 | Spring Close 2025 |
|---|---|---|---|---|
| Extract: Aug 26, 2024 | Extract: Sep 26, 2024 | Extract: Jan 18, 2025 | Extract: Feb 26, 2025 | Extract: May 26, 2025 |
| DSD Load: Aug 27 - 29, 2024 | DSD Load: Sep 27 - 29, 2024 | DSD Load: Jan 19-21, 2025 | DSD Load: Feb 27 - 29, 2025 |
DSD Load: May 27 - 29, 2025 |
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.
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_STATS
- DSD_STUDENT_TEST_SCORES
- DSD_UA_SCHOLARS
| Summer 2024 | Fall 2024 | Spring 2025 | Summer 2025 |
|---|---|---|---|
| Extract: Aug 12, 2024 | Extract: Oct 14, 2024 | Extract: April 14, 2025 | Extract: n/a |
| DSD Load: Aug 13-15, 2024 | DSD Load: Oct 15-17, 2024 | DSD Load: April 15-17, 2025 | DSD Load: June 11-13, 2025 |
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.
Tables include:
- H_ASSIGNMENT
- H_DEMOGRAPHICS
- H_DISTRIBUTION
- H_EMPLOYEE
- H_FACULTY
| Aid Year 23-24: Late | Aid Year 23-24: Final | Aid Year 24-25: Early |
|---|---|---|
| July 8-9, 2024 | October 15-17, 2024 |
October 15-17, 2024 |
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). A freeze of preliminary 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.
Final 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.
| Aid Year 23-24: Preliminary | Aid Year 23-24: Final |
|---|---|
| July 22-24, 2024 | October 21-22, 2024 |
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 and the revenue generated as a result of the research.
Tables include:
- SPONSORED_PROG_EXPEND
- SPONSORED_PROG_FUND
- SPONSORED_PROG_THEMES
Other Data Freezes and Snapshots
Daily
- Early Semester Report (ESR) Data about:
- Applications
- Enrollment
- Projected Tuition
- Select Human Resource Tables
Monthly
- Degrees Awarded
- BOR Structure Updates - follows finance close
- Cycle, Cycap, TVEP Updates
- follows BOR Updates
Annual
- IPEDS/ Title III Data - November
- NSC Data Import - November
- Finance FTV Updates - July
- Final Degrees Earned -
August