List of Query Library Reports

If you are new to the Query Library go to the Getting Started page to get more information. You will need to be authorized for the Query Library before you will be able to access any of these queries.

If you are already authorized and just need to get to the QL (Query Library), you can access it via the Quick Link at the top of any of the Reporting.uwm.edu web pages or go directly to the Query Library.

All reports are written for access with Hyperion, unless otherwise stated.

Many more reports have been written that have not been published. If you don’t find a report you are interested in, contact the Campus Report Writing Rep for your area. S/he can check to see if someone on campus has already written the report you desire.

MILWAUKEE/Campus Wide Folder

The following queries have been published for university-wide use. Note: unless otherwise noted, all authorization is granted through the Authorization Application.

Admissions    
NameBrief DescriptionLocationData SourceAuthorization Needed
Admitted StudentsStudents admitted by term, admission type, school/college and plan.Campus Wide/AdmissionsStudent Data WarehouseQL-General Access, QL-Student Data
Comparison of Admissions to DateAdmissions reports by admit type; year in school; heritage; international students; academic group & program; and admit status. Prepared by AIR.Campus Wide/Admissions
Links directly to report found at: OAIR website
Student Data WarehouseQL-General Access
New Freshmen OrientationList, labels and pivots for Freshmen Orientation students.Campus Wide/AdmissionsStudent Data WarehouseQL-General Access, QL-Student Data
Human Resources    
NameBrief DescriptionLocationData SourceAuthorization Needed
Visit the HRS Reporting page for reports related to HRS that are published in the Query Library.A new data warehouse is available, called EPM (Enterprise Performance Management). The EPM contains data related to: HR, Payroll, Benefits, Absence Management, Time and Labor, and Funding.Campus Wide/Human ResourcesEPMQL-General Access without Plugin,
for HRS EPM authorization/access questions and requests, please contact hrs-securityissues@uwm.edu
Institutional Research    
NameBrief Description LocationData SourceAuthorization Needed
Admissions To DateReports on Comparison of Admissions to Date - Current and Historical.Campus Wide/Institutional Research/Admissions To DateStudent Data WarehouseQL-General Access
Enrollments To DateReports on Comparison of Enrollments to Date.Campus Wide/Institutional Research/Enrollments To DateStudent Data WarehouseQL-General Access
Financial CommitmentReports of students who have not made a financial commitment. There are separate reports for 2 pre-cancel times and a final cancel report.Campus Wide/Institutional Research/Financial Commitment Student Data WarehouseQL-General Access, QL-Student Data
GER Course EnrollmentsReports of the history of GER Course EnrollmentsCampus Wide/Institutional Research/GER Course EnrollmentsStudent Data WarehouseQL-General Access
Records and Enrollments    
NameBrief DescriptionLocationData SourceAuthorization Needed
Class ReflectorsUpdated daily per term while term is active. File of students enrolled by course, includes campus email address.sent to listservesStudent Data Warehouseper individual listserve
Class RostersReport showing name, address, email, phone for students for a specific term. Output options: labels and exportable file.Campus Wide/Records and Enrollments/Class EnrollmentStudent Data WarehouseQL-General Access
Class TalliesSelect courses by School/College, Department, Course #. Shows course, section, class description, enrollment status, class status, capacity, enrollment, available seats, units, days, begin and end time, facility, instructor, session.
Reports also available at: Tallies online
Campus Wide/Records and Enrollments/Class EnrollmentStudent Data WarehouseQL-General Access
Course Registration HistoryFive year Enrollment Comparisons for Fall and Spring; nine year comparison for UWinteriM.Campus Wide/Records and Enrollments/Class EnrollmentStudent Data WarehouseQL-General Access
Section Attrition & Grade ReportsEnrollments both beginning & end of terms, and numbers of grades received by grade, for each course section. Produced by AIR.Campus Wide/Records and Enrollments/Class Enrollment
Links directly to report found at: OAIR website
Student Data WarehouseQL-General Access, QL-Student Data
Wait ListsReport showing students who placed themselves on the waitlist or were manually added to the waitlist by the departments by term. Note: UWinteriM does not currently have waitlists.Campus Wide/Records and Enrollments/Class EnrollmentStudent Data WarehouseQL-General Access
Tentative Graduation ListFile, list and labels for students with a degree checkout status of AG, AP, PN, AW or IR.Campus Wide/Records and Enrollments/GraduationStudent Data WarehouseQL-General Access, QL-Student Data
Legacy Data Data from 1984 to the implementation of PAWS.
contact Chad Rathsack
Campus Wide/Records and Enrollments/LegacyStudent Data WarehouseQL-General Access, Data Warehouse - PAWS Student Admin-Legacy Data

Query Library – Individual Unit Folders

Contact the following Unit Admins for access and more information about the reports published in each folder.

Unit FolderUnit Admin
Admissions and RecruitmentChad Rathsack, Jennifer Elsner
Business and Financial ServicesColleen Johnson, Joe McCullough
Center for International StudentsDave Schuckit
College of NursingRay MacDonald
Engineering and Applied SciencesTodd Johnson
Financial AidChad Rathsack
Graduate SchoolShane Dunlap, Riley Hale
Health SciencesMichelle Janowiak
HousingStephanie Warner
Human ResourcesCarla Sagert, Donna Glover
Institutional Research AdminChris Jacobson, Marianne Guidos
Letters & ScienceSherry Kulhanek
Multicultural Student CenterLinda Huang
Registrar's OfficeChad Rathsack, Rachael Daniel, Wei Li
School of BusinessKeith Kunkel, James Hardy
School of EducationRita Delzer
School of Information Studies
School of Social WelfareMike Darnell
Student Disability CenterShannon Aylesworth
UITSMichelle Schartner