Main - Overview - Data Dictionaries - Reports - Comments - Email

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

 

 


Copyright 2011 Georgia Southern University All Rights Reserved.
Comments or suggestions please contact Technical Support's Webmaster

This page was last updated on April 20, 2011