- Navigation: Main Menu > Reporting Tools > Query > Query Viewer
- Queries about specific students produce FERPA-protected data! If you download or print data about specific students, take care to keep the data secure. General Summaries of Class Information and Textbook Queries do not identify individual students.
- Department Majors, Holds, and Grades Queries return information only for currently active majors. Running these queries for past terms will produce incomplete results.
- For access to queries: Log into SPIRE and navigate to Main Menu > My SPIRE > SPIRE Access Request. Follow the directions on the page and your request will be sent to your department head and the Registrar’s office for approval.
- Need help with queries? Contact the registrar's office systems group firstname.lastname@example.org.
- The list below gives a brief description of each query, followed by the actual query name that you use to search in the Query Viewer. Click a heading for further details.
- To find all your undergraduate queries, search for queries beginning with UR89_DEPT.
- To find all Amazon textbook queries, search for queries beginning with UM_IT_DEPT_AMZCLS.
Department Majors, Holds & Advisors
|Majors List Data Dump
|Majors List Data, abbreviated
|Non-Degree Majors List Data
|Minor list Data Dump
|Majors w/ Advisors
|Student assigned advisors only
|Adv hold/appt/RAC list for dept
|Acad plans with perm address
|Students with enrollment holds
|Dean's list - most recent term
|Students in Commonwealth Coll
|Students to chk for graduation
|Graduation List by confer date
|Active frosh by admit term
|Active transfers by admit term
|Active stdnt with <12 credits
|Active Exploratory Track Stdts
|Active Exploratory Trk Sdnts w RapTap
|Classes for subject/catalog #
|All classes by subject/cat #
|Classes by instructor ID
|Classes by subject
|Status of classes by subject
|History of classes by subject
|Classes with Gen Ed
|Class offerings by keyword
|Lists final exams by term
Need help with queries? Contact the registrar's office systems group email@example.com.