- Status
- Refresh Schedule
- Term Rollover Schedule
- Warehouse Population
- Changing Your Password
- Data Models
- Intro Screen
- All Terms Students Model
- Admission Applicants Model
- Current Recruits Model
- Validation Tables
- Historical Record of Model Changes
General Information
Warehouse Status
The University of Oregon Student Data Warehouse has been in production since February, 1996. There are currently more than 350 Student Data Warehouse users.
The Student Data Warehouse incorporates data from multiple terms of academic activity at the University. For a list of terms available in the warehouse, query the Terms Available object in the All Terms data model.
Refresh Schedule
Unlike the production Banner system, the Data Warehouse remains static until it is refreshed, or updated, with new data. The general policy is that the Warehouse will not change at all during workday hours. This provides users with a reliable snapshot of student data which they may use all day with no changes, so that counts, lists, etc. do not constantly change.
Currently, the Student Data Warehouse is refreshed six times a week. The refresh occurs shortly after midnight Monday through Saturday. Each day the Student Data Warehouse reflects the previous day's transactions entered in the Banner system.
|
DAY
|
START TIME
|
|
Monday
|
12:01 am
|
|
Tuesday
|
12:01 am
|
|
Wednesday
|
12:01 am
|
|
Thursday
|
12:01 am
|
|
Friday
|
12:01 am
|
|
Saturday
|
2:00 am
|
Term Rollover Schedule
The Student Data Warehouse also has a current term/semester defined for simplification of the querying process. The current term/semester is the term/semester that is currently in progress. The current term/semester usually changes on Monday evening, just before the start of a new term, except for the Fall term/semester which may be changed earlier, to help users prepare for the beginning of the new school year.
Warehouse Population
The Student Data Warehouse contains data only for students who have registration activity in a term/semester that is populated. For a list of populated terms, query the Terms Available object in the All Terms models. The exception to this is that students with no registration activity who have applied for degrees at the U of O are included in the Person and Degree objects in the warehouse.
University of Oregon course schedules are also available in the data warehouse. Schedule information is loaded for all populated terms. For a list of populated terms, query the Terms Available object in the All Terms models.
Changing Your Data Warehouse Password
Simply click one of the following links and login using your old password:
For the Sun Java Plugin: click here
For the Jinitiator Plugin: click here
If you forget your password, or have any problems with the password change, send email to oracle@uoregon.edu
Data Model
The student data model is a graphical representation of the student data warehouse. You'll use this model to construct the queries and produce the reports. The model contains 5 windows. They are:
Intro Screen
This window displays the access policy for using the data warehouse
. 
ALL Terms Students Model 2
This window combines three objects, Current Students, Past Students, and Future Students in one.
Admission Applicants Model
This window contains the objects for student who have applied
for the admission at the U of O in a populated term/semester. 
Current Recruits Model
This window contains the objects for people who have the recruit
records at U of O. 
Validation Tables
This windows contains the validation code tables used in the data warehouse.
This page was last updated on January 3, 2006
