SPIRE Queries - Records
To access the Query Viewer, logon to SPIRE and navigate to Queries & Reporting Tile > Query Viewer
|List of current, active students. This list includes all contact information such as address, email and local phone.
|List of active students with advisor name.
|List of current active students, and those that have recently discontinued or graduated. Use when a student doesn't appear on the active list.
|List of current active students. Includes course enrollments, but does not include students with no registrations.
|List of current active students who have not yet registered for the semester
|List of current, active students with a registration hold due to missing application materials. These students were conditionally admitted.
|Active students with their cumulative GPA and total number of credits. Prompts for term.
|Active students with cum GPA, total credits and possible incomplete grades. Could be used to determine degree eligibility.
|All courses, including GRADSCH-999, and grades for all active students in the program. Sorted by student and term.
|All incomplete courses for all students in the program.
|Incomplete courses for individual student. Prompts for ID.
|List of active students and a summary of any milestones they have completed. Sorted by Expected Graduation Date (soonest to most distant) and then by student name. Students without milestones are included.
|List of milestones for active students. There are multiple rows for each student. Students without milestones do not appear.
List of students who are expected to graduate or the department will need to request an extension to their SOL.
|List of students for whom we have received a degree eligibility form.
|List of students for whom a degree or certificate was awarded.
|List of active students with link to Student Groups. Optional prompt for Plan.
|List of Graduate Faculty
|List of Graduate Faculty in a specific program. Prompts for Academic Program code.