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
here and login using your old password
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
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
