Graduate Students by Selected Grades

The purpose of the document is to explain the features of the Graduate Students by Selected Grades query.

Graduate Students by Selected Grades
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • This can be run before Warrents are issued for students.

What answers can I find?

Reports available in this query:

  • Which students in my program received certain grades?
  • What courses are these in?
  • Which students in my program have incompletes?
  • What courses are these in?
  • What are the GPAs of these students?
  • What is the contact information and biographic data on these students?
  • Who are their advisors?
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:


Sample Report:
Alpha List



This query delivers three pivots, charting students by Plan Description, Contact Information and alphabetically.

The Retention data views used in this query do not refresh grade changes older than 3 years.

The selected criteria to run this query are -
Career = preset for GRAD, LAW, MEDS, PHAR, VMED
Academic Group
Plan Group Description
Academic Level

There are additional selections to focus your reports.
These are optional and no reprocessing is necessary.
Official Grade
Advisor Name
Targeted Minority
Student Group Description
Ethnic Group
Student Group

Email address are retrieved from the Stdnt Directory Multiterm data view which has records of the students currently enrolled and for the prior two Terms. Selecting Terms before that will not yield email addresses or phone numbers on the "Contact Information" report

Data views used:

  • Retention Student
  • Retention Plan History
  • Retention Course History
  • Retention Student Group History
  • Stdnt Multiterm
  • Stdnt Directory Multiterm
  • Stdnt Advisor Multiterm

Search either the InfoAccess Data View page or the Enterprise Performance Management (EPM) Data Warehouse page for data definitions to the data views used in the Query Library.

Keywords:graduate,enrolled,current student,grades,courses,incompletes,GPA,contact info,biographic,advisor Query Data Library   Doc ID:41681
Owner:Harriet A.Group:Query Library
Created:2014-07-07 17:11 CDTUpdated:2014-07-29 15:59 CDT
Sites:Query Library
Feedback:  0   0