Search Google Appliance

Information Technology

Article Details

Undergraduate Queries - General Summaries of Class Information

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
  • For more queries:  see SPIRE for Staff Query Directory.
  • 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.

 

Detailed Query Descriptions

 

  • Classes by subject & catalog # - UR89_DEPT_CLASS_BY_CATALOG
    Shows all class sections offered for a single course for a term (e.g., all BIOLOGY 100 lecture and lab sections for Fall 2010).

    • Search Parameters: Term, Subject Area abbreviation (e.g., CHEM), and Catalog Number (e.g., 118, 499C). All parameters are required.
    • A No Matching Values Found message may indicate that a course was not offered for the term you specified (if all your other search parameters are correct).
       
  • All Classes by subject & catalog # - UR89_DEPT_CLASS_LISTING
    Similar to a downloadable Schedule of Classes. Provides information about all classes (graduate and undergraduate) offered on campus by term.
     

  • Classes by instructor ID - UR89_DEPT_CLASS_BY_INSTRUCTR
    Shows all classes (graduate and undergraduate) that an instructor has taught by term.

    • Search Parameters: Term, Instructor’s 8-digit ID. Leave the ID field blank to view all the class sections that do not have an instructor assigned.
       
  • Classes by subject - UR89_DEPT_CLASS_BY_SUBJECT
    Shows all classes (graduate and undergraduate) offered in a subject area by term.

    • 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.
       
  • Status of Classes by subject - UR89_DEPT_CLASS_BYSUBJ_STATUS
    Shows the overall status of class sections, including Active, Cancelled, Closed, and Stop Further Enrollment.

    • 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.
       
  • History of classes by subject - UR89_DEPT_CLASS_BYSUBJ_HISTORY
    Lists classes offered for a subject in a range of terms.

    • Search Parameters: From Term, To Term,Subject abbreviation (e.g., CHEM). Refer to the Subject Area Codes & Definitions (PDF, 103k), if necessary, to ensure that you have the correct Subject abbreviation. All parameters are required.
       
  • Classes with Gen Ed - UR89_DEPT_CLASS_GEN_EDS
    Shows all classes offered for a specific term that fulfill General Education requirements.

    • Query results include all classes from all subject areas that satisfy any GenEd requirements for a given term. Use the GenEd column to manage your results.
       
  • Honors Classes - UR89_DEPT_CLASS_HONORS
    Look up all the honors classes offered on campus by term. Results include any class with the ‘HONORS’ Subject Area code or with ‘499’ or 'H' in Catalog Number.

    • Query results include all the honors classes from all subject areas offered for a given term. Use the Subject columns to sort your results.
       
  • RAP/TAP Classes - UR89_DEPT_RAPTAP_CLASS
    Look up all the RAP/TAP classes offered on campus by term.

    • Query results include all the RAP/TAP classes from all subject areas offered for a given term. Use RAP/TAP and RAP/TAP Detail columns to manage your results.
       
  • Class offerings by keyword - UR89_DEPT_CLASS_OFFERED
    Use a keyword or phrase from a class title to list classes offered in any term, as recorded in SPIRE.

    • Search Parameter: A keyword or phrase from the class title enclosed in two percent (%) signs, e.g., %ancient greece% (not case-sensitive).  Tip: Use % signs as “wild cards” within your keywords to expand your search results, e.g., try substituting % signs for vowels to find variations on a keyword.
    • Please be aware that class titles and abbreviations may vary over time.  The class you are looking for may have been offered under several different titles.  See tip in previous item.
    • Query results list all matching class titles, sorted by Subject/Course Number and then by Term, listed from oldest to most recent.
       
  • Lists final exams by term - UR89_DEPT_FINAL_EXAMS_BY_TERM
    Lists all final exams by term, in order by 5-digit class number.

    • Query results include date, start time, and location of each exam.