IT - Undergraduate Queries - Class Enrollment Information, Grades & Student Groups

Essential Information

Navigation: Queries & Reporting tile on your SPIRE Center
The queries listed on this page produce FERPA-protected data! If you download or print the query results, take care to keep the data secure.
These queries return information only for currently active undergraduate majors in your department. Running them for past terms will produce incomplete results.
For more queries: see SPIRE for Staff Query Directory.
For access to queries: Log into SPIRE and navigate to Profile tile > Access & Privacy > 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 ursystems@registrar.umass.edu.

Detailed Query Descriptions

Instructors for Independent Studies students – UR89_DEPT_IND_STUDIES
Instructors for Practicum students – UR89_DEPT_PRACTICUM
Use the two queries above to view enrollment details for students taking independent studies or practicum classes offered by your department. Query results include the students associated with each class, along with the name of the instructor overseeing each student’s work.
- Generates results only if a SPIRE B user (usually the staff in your department responsible for processing overrides) has already matched the students taking independent studies or practicum classes with the appropriate instructor IDs. SPIRE B users can refer to this query to double-check the status of their work.
Student integrative experience (IE) requirement status - UR89_DEPT_STDT_IE_RQRMT_STATUS (FERPA-protected)
Enter a range of expected graduation terms to see the status of the integrated experience (IE) academic requirement for students in your major(s).
- Search Parameters: Exp Grad Term From, Exp Grad Term To. All parameters are required.
- Includes active students with an admit term of Fall 2010 or later.
- IE status is COMP, FAIL, or EXMP. Note: COMP includes students who have completed the class and students currently enrolled in the IE.
Students who did not pass prereq with at least a “C-” – UR89_DEPT_PREREQ_NOTPASS
Students who did not pass prereq with at least a “C” – UR89_DEPT_PREREQ_NOTPASS_C_UP
Use the two queries above to check for students who are enrolled in classes, but who did not earn at least the minimally acceptable grade for the prerequisite class(es). Students typically must earn a grade of at least “C-“ in prerequisite classes. In some cases, the minimally acceptable grade is “C”. When a student registers for a class and is currently taking a prerequisite for that class, SPIRE assumes that the student will pass the prerequisite with the minimum grade and allows the student to register. Use whichever query matches the minimally acceptable grade.
- Search Parameters: Class Term, Subject abbreviation (e.g., CHEM), Catalog Nbr (e.g., 118, 499C), Prereq Subject abbreviation, Prereq Catalog Nbr, Past term to check (typically the most recently ended term). All parameters are required.
- Recommended Timeframe: These queries are most effective between the date when final grades are posted for one term and the date when classes begin for the following term.
Count of students missing a particular co-requisite – UR89_DEPT_MISSING_COREQS
For a particular class and its co-requisite, find out how many students are missing the co-requisite.
- Search Parameters: Current Subject abbreviation (e.g., CHEM), Current Catalog Nbr (e.g., 269), Co-req Subject abbreviation, Co-req Catalog Nbr. All parameters are required.
Students on academic probation – UR89_DEPT_PROBATION_LIST
Find students who are on academic probation for a given term. Results appear in order of student's 8-digit SPIRE ID and include contact information.
Students on academic warning – UR89_DEPT_WARNING_LIST
Find students who are on academic warning for a given term. Results appear in order of student's last name and include contact information.
Students with no grade, by class # – UR89_DEPT_GRADE_FOLLOWUP
Find students in your department who have a grade of INC or __. Results appear in order of the 5-digit class number.
Students with grade, by class – UR89_DEPT_STUDENTS_BY_GRADE
Find students who took classes in your department and received a specified grade. Results appear in order of student’s last name and include class information.
- Search Parameters: Graded Term, Official Grade. All parameters are required.
Grd roster status w/instructor – UR89_DEPT_GRADE_ROSTER_STATUS
Shows the status of grade rosters (Not Reviewed, Ready for Review, Approved, or Posted) by class, with instructor names and email addresses.
- Search Parameters: Term, Subject Area abbreviation (e.g., CHEM). Refer to the Subject Area Codes & Definitions (PDF, 103k), if necessary, to ensure that you have the correct Subject Area abbreviation. All parameters are required.
Stdnt acad level by class subj – UR89_DEPT_CLASS_ACAD_LEVEL
Gives counts of students enrolled in individual classes by academic level.
- Search Parameters: Term, Subject Area abbreviation (e.g., CHEM). Refer to the Subject Area Codes & Definitions (PDF, 103k), if necessary, to ensure that you have the correct Subject Area abbreviation. All parameters are required.
Students by Student Group – UR89_DEPT_STDNTS_BY_ST_GROUP
Shows students who belong to an active student group.
- Search Parameter: Student Group. Enter the code for a student group, or click the magnifying glass icon and then click the Look Up button to find the group. You will see all possible student groups in the Look Up results, but you will only be able to see students for a specific group if you have the correct security. If you have questions about your security settings or about this query, please email ursystems@registrar.umass.edu.