SPIRE for Staff Query Directory


Essential Information

Query Directory

Department Majors, Holds & Advisors
(FERPA-protected, time-sensitive)

Query Description Query Name
Majors List Data DumpUR89_DEPT_MJRS_NEW_UPDATED
Majors List Data, abbreviatedUR89_DEPT_MJRS_SHORTLIST
Non-Degree Majors List DataUR89_DEPT_MJRS_ND
Minor list Data DumpUR89_DEPT_MINORS_LIST
Majors w/ AdvisorsUR89_DEPT_MJRS_ADVISORS
Student assigned advisors onlyUR89_DEPT_ACTIVE_STDNT_ADVISOR
Adv hold/appt/RAC list for deptUR89_DEPT_RAC_WADVHOLDAPPT_LST
Acad plans with perm addressUR89_DEPT_PERM_ADDRESS
Students with enrollment holdsUR89_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 studentsUR89_DEPT_IND_STUDIES
Instructors for Practicum studentsUR89_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-requisiteUR89_DEPT_MISSING_COREQS
Students on academic probationUR89_DEPT_PROBATION_LIST
Students on academic warningUR89_DEPT_ACAD_WARNING_LIST
Students with no grade, by class #UR89_DEPT_GRADE_FOLLOWUP
Students with grade, by classUR89_DEPT_STUDENTS_BY_GRADE
Grd roster status w/instructorUR89_DEPT_GRADE_ROSTER_STATUS
Stdnt acad level by class subjUR89_DEPT_CLASS_ACAD_LEVEL
Students by Student GroupUR89_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 IDUR89_DEPT_CLASS_BY_INSTRUCTR
Classes by subjectUR89_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 EdUR89_DEPT_CLASS_GEN_EDS
Honors classesUR89_DEPT_CLASS_HONORS
RAP-TAP ClassesUR89_DEPT_RAPTAP_CLASS
Class offerings by keywordUR89_DEPT_CLASS_OFFERED
Lists final exams by termUR89_DEPT_FINAL_EXAMS_BY_TERM

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