Search Google Appliance

Information Technology

Article Details

SPIRE for Staff Query Directory

We're taking you to an updated version of this article.

UMass Amherst Information Technology support articles are now updated in the new IT Knowledge Base. We found an updated version of this article, so we're sending you there.

Taking you to:

umass.service-now.com/sp
Redirecting in
10s

Stay here to view this page in the legacy Support Center.
Information may be outdated as these articles are no longer maintained.

Find answers to your tech questions in the new IT Knowledge Base.

UMass Amherst Information Technology support articles are now updated in the new IT Knowledge Base.

This article is part of our archived legacy Support Center and may be outdated or inaccurate.
We did not find an updated version of this article. That means this archived content is more likely to be outdated or no longer relevant.
Check the new IT Knowledge Base for updated information:

More tech help options

Essential Information

  • 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 ursystems@registrar.umass.edu.

Query Directory

  • 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
(FERPA-protected, time-sensitive)

Query Description  Query Name
Majors List Data Dump UR89_DEPT_MJRS_NEW_UPDATED
Majors List Data, abbreviated UR89_DEPT_MJRS_SHORTLIST
Non-Degree Majors List Data UR89_DEPT_MJRS_ND
Minor list Data Dump UR89_DEPT_MINORS_LIST
Majors w/ Advisors UR89_DEPT_MJRS_ADVISORS
Student assigned advisors only UR89_DEPT_ACTIVE_STDNT_ADVISOR
Adv hold/appt/RAC list for dept UR89_DEPT_RAC_WADVHOLDAPPT_LST
Acad plans with perm address UR89_DEPT_PERM_ADDRESS
Students with enrollment holds UR89_DEPT_MJRS_W_ENRL_HOLDS  
Dean's list - most recent term

UR89_DEPT_DEANS_LIST

Students in Commonwealth Coll

UR89_DEPT_MJRS_WITH_HONORS

Students to chk for graduation

UR89_DEPT_PRELIM_GRAD_LIST

Graduation List by confer date

UR89_DEPT_FINAL_GRAD_LIST

Active frosh by admit term

UR89_DEPT_FROSH_BY_ADMIT_TERM

Active transfers by admit term

UR89_DEPT_TRNSFR_BY_ADMIT_TERM

Active stdnt with <12 credits

UR89_DEPT_LESSTHAN12_BY_TERM

Active Exploratory Track Stdts

UR89_DEPT_EXPLORATORY_TRACK_ST

Active Exploratory Trk Sdnts w RapTap

UR89_DEPT_EXPLOR_TRK_W_RAPTAP

Class Enrollment Information, Grades & Student Groups
(FERPA-protected, not time-sensitive)

Query Description  Query Name
Instructors for Independent Studies students UR89_DEPT_IND_STUDIES
Instructors for Practicum students UR89_DEPT_PRACTICUM
Student integrative experience (IE) requirement status

UR89_DEPT_STDT_IE_RQRMT_STATUS

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
Count of students missing a particular co-requisite UR89_DEPT_MISSING_COREQS
Students on academic probation UR89_DEPT_PROBATION_LIST
Students on academic warning UR89_DEPT_ACAD_WARNING_LIST
Students with no grade, by class # UR89_DEPT_GRADE_FOLLOWUP
Students with grade, by class UR89_DEPT_STUDENTS_BY_GRADE
Grd roster status w/instructor UR89_DEPT_GRADE_ROSTER_STATUS
Stdnt acad level by class subj UR89_DEPT_CLASS_ACAD_LEVEL
Students by Student Group UR89_DEPT_STDNTS_BY_ST_GROUP

General Summaries of Class Information

Query Description  Query Name
Classes for subject/catalog # UR89_DEPT_CLASS_BY_CATALOG
All classes by subject/cat #

UR89_DEPT_CLASS_LISTING

Classes by instructor ID UR89_DEPT_CLASS_BY_INSTRUCTR
Classes by subject UR89_DEPT_CLASS_BY_SUBJECT
Status of classes by subject

UR89_DEPT_CLASS_BYSUBJ_STATUS

History of classes by subject

UR89_DEPT_CLASS_BYSUBJ_HISTORY

Classes with Gen Ed UR89_DEPT_CLASS_GEN_EDS
Honors classes UR89_DEPT_CLASS_HONORS
RAP-TAP Classes UR89_DEPT_RAPTAP_CLASS
Class offerings by keyword UR89_DEPT_CLASS_OFFERED
Lists final exams by term UR89_DEPT_FINAL_EXAMS_BY_TERM

Need help with queries?  Contact the registrar's office systems group ursystems@registrar.umass.edu.