|
The Georgia Southern University Data Warehouse is a collection of
data periodically extracted from the Banner student information
system. Its simple structure allows faculty, staff, system
developers, and institutional researchers to perform queries on
student data.
A data dictionary, detailing each
data field in the data warehouse, is also available for each of the
tables.
Training is
available for individuals interested in using the data warehouse.
Also available from the data warehouse on this site are free,
downloadable Crystal 7 reports, which
include: class rosters, student schedules, complete student academic
histories, and lists of advisees assigned to advisors.
Access to the tables can be obtained by contacting the following
administrators:
Registrar Tables
YEN,YDR,YSC,YCC,YHH,YSH,YHD,YGR,YRS,YSR,YCR,YDS |
Contact Registrar's office at
wbrown@georgiasouthern.edu (Wallace Brown)
|
Student Affairs Tables
YSA
|
Contact Student Affairs at
ted_williams@georgiasouthern.edu (Ted Williams)
|
Admissions Tables
YAD,YAR,YAS
|
Contact Admissions at
pmiddleton@georgiasouthern.edu (Pearl Middleton)
|
Alumni Tables
YALMAIN, YAL****
|
Contact Alumni Affairs at
jwest@georgiasouthern.edu (Janice West)
|
Auxiliary Services Tables
YHS
|
Contact Auxiliary Services at
bgrogan@georgiasouthern.edu (Bob Grogan)
|
Below is a graphical representation of the Data
Warehouse. Boxes in blue are hyperlinked and will lead you to the appropriate data dictionary. A schedule of the refresh cycle
for each table follows this diagram.
REFRESH CYCLES:
|
Table Name |
Description |
Frequency |
Refreshed |
|
General Student Tables
|
|
YENyytt
|
Student Enrollment
|
Nightly
|
Monday through Friday
by
6:00 am |
|
YDRyytt
|
Student Directory
|
Nightly
|
Monday through Friday
by
6:00 am |
|
YSCyytt
|
Student Registration
|
Nightly
|
Monday through Friday
by 6:00 am |
|
YCCyytt
|
Course Schedule
|
Nightly
|
Monday through Friday
by
5:00 am |
|
YHHMAIN / YSHHIST
|
Academic History
|
Nightly
|
Monday through Saturday
by
9:00 pm |
|
YHDMAIN
|
Student Holds
|
Nightly
|
Monday through Friday
by
5:00 am |
|
YGRMAIN
|
Graduation
|
Nightly
|
Monday through Friday
by 8:00 am |
|
YRSMAIN
|
Registration Statists
|
Nightly
|
Monday through Friday
by 8:00 am |
Regents Reporting Tables
|
|
YSRyytt
|
ADM/SIRS Reporting |
Once/Term |
Mid-term |
|
YCRyytt
|
ADM/Curriculum Inventory
|
Once/Term
|
Mid-term |
|
Enrollment Management Tables
|
|
YDSyytt
/ YDSROLL
|
Decision Support
|
Nightly
|
Monday through Friday
by 7:00 am |
|
Auxiliary Services Tables
|
|
YHSMAIN
|
Health Services
|
Nightly
|
Monday through Friday
by 7:00 am |
|
Admissions Tables
|
|
YADALL (YADMAIN,YADGRAD)
|
Admissions
|
Nightly
|
Monday through Friday
by 6:00 am |
|
YARALL (YARMAIN,YARGRAD)
|
Recruiting
|
Nightly
|
Monday through Friday
by 8:00 am |
|
YASMAIN
|
Admission Statistics
|
Weekly
|
Wednesday
by 8:00 am
|
|
Alumni Tables
|
|
YALMAIN / YAL****
|
Alumni
|
Nightly
|
Monday through Friday
by 7:00 am |
|
Student Affairs Tables
|
|
YSAMAIN
|
Student Affairs
|
Nightly
|
Monday through Friday
by 7:00 am |
|
