Student Course Schedule with Grades

List of students by college with the grades associated with the courses taken for a term.

Universe

EDW – STU Academic Records

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.
This report uses the Overall Student Course Detail which has 10 years of academic history from the present term. This table is loaded on a weekly basis (Saturday).
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.