List of students and their Term GPA and Level GPA, for a specific Term, College, GPA Type and Student Level. This report is grouped by Department and sorted by Student Name.  A UIN count is included for each department and for the entire college.


EDW – STU Academic Records

Data Rules Related to this Report

  • Term GPA is the GPA associated with the course work of a student whether it is institutional or transfer course work.
  • This report will always pull the current Level GPA regardless of the chosen term because Level GPA is associated with a student by their level. For example, if you select Fall 2014 – UIUC, you will receive the students who have been awarded a degree in Fall 2014 with their most current Level GPA (not their Level GPA ‘as of’ Fall 2014). Level GPA is associated with the student and their level (i.e., 1U – UIUC Undergraduate; 2G – UIC Graduate, etc.), not a term.
  • Due to the amount of data available in the Academic Records tables, average run time for reports is 10 – 15 minutes.
  • Academic Records data has a one term lag time which means that the EDW will not have Records data until the Banner “roll to academic history” has completed. For example: if the current term is Spring 2014, data for that term will be available AFTER the Spring 2014 term has completed.
  • When creating lists of students, you must ALWAYS include the Person Confidentiality Indicator for FERPA restrictions. Consult your campus OAR office for FERPA policy and guidelines.