General Information
FERPA
Please review the FERPA policy before using data from the Query Library.
User Guide
Query Library Guide - Please review the instructions regarding accessing Query Library.
Internet Explorer is the preferred browser.
Access to Query Library
To receive access to Query Library you will need to complete or have on file a Compliance Form. Once that form has been submitted, complete the Access Request & Authorization form.
Access to the Query Library is based on the individual query. You will not have access to all of the queries listed below. Please only run the queries available under your department or a shared department heading.
To receive access to systems other than Query Library please contact the Help Desk or call 262-472-4357.
Queries designated with *** are run against the HEQRY database. This database is not real time. It is refreshed 6-8 am daily. This database is available 5am - 9pm Monday through Friday.
WINS Tutorials
WINS Tutorials - Some of these queries ask for input such as a term code. If you are unsure of the term codes or other data it may be available on the WINS Tutorial page.
Department Specific Queries
Select a Department or Area: A B C D F H I L M P S T U Y
Academic Support Services
- UW-W Advising Topics and Referral Reports (V11)
- Lawton Grant Candidates
- Academic Support Services Checklists Use the dropdown box to select the appropriate checklist.
- Financial Aid Family Data (V11)
- ACS Events (by Year)
Latino Student Programs
Accounting
Accounting GPA Queries - These will take a few minutes to run. After the results are available you will have two choices for the output. One is an excel file sorted by GPA, it is recommended that you save the file before attempting to open it. The other is a pdf file sorted by last name.
- Accounting GPA Queries (V11) - (Looks at students enrolled in specific courses).
- Accounting GPA Queries (Includes ACCOUNT 244) (V11) - (Looks at students enrolled in specific courses).
- Accounting GPA Queries (All) (V11) - (Looks at students enrolled in any Accounting course).
- Accounting GPA Queries (All)(Includes ACCOUNT 244) (V11) - (Looks at students enrolled in any Accounting course).
- ACCOUNT 454 GPA*** (V11) - Accounting 249/342 and Accounting 261/341 GPA for students enrolled in Account 454 in a specified term.
Other Accounting Queries
- MPA Degrees by Term (V11)
- BBA Degrees by Term (V11)
- Accounting Majors - High School Attended (V11)
Admissions
- Undergraduate and Graduate - Access the list of queries for admissions offices.
Adult Student Grant
Advising Center
- Youth Options Students (V11)-List of Youth Option Student Information
- Probation/Dismissals List (V11) -List of Students facing Probation/Dismissal
- Topics & Referrals (V11) - Summary of AAEC Contacts
- Student Summary (V11) - Listing of all Contacts for a Specific Student
- AP/ACT/Transfer Conflict Report (V11) - AP/ACT/Transfer credit Conflict Report
Pathways to Success Queries
- Pathways to Success PIP & Student Group Info (V11) - List of Pathways to Success Students who signed up for PIP with Student Group Data.
- Pathways to Success Detailed Query (V11) - List of Pathways to Success Students with Detailed Data
- Enrollment Audit Trail (V11) - List of enrollment transactions by Pathways to Success Students.
- Topics & Referrals (V11) - Summary of Pathways Contacts
Alumni Center/Foundation
- Chancellor Scholars List (V11) - Listing of Chancellor Scholars Candidates
- Ad Hoc Scholarship Listing (V11) - List of potential candidates for scholarships based on admit type, academic program and plans
Art Department
- Art Trip Fees ***
- Art Course Fees ***
Athletics
- PEGENRL 193 ***
- Team GPA Report (V11)
- Details Report(V11)
- Honors Report (V11)
- Major by Sport (V11) - List of Students with Major by Sport, Academic Year, and Gender
- Athlete Repeats in Progress (V11)- List of students repeating courses.
Building Supervisors
- Facilities Report (V11) - Students and Instructors by Building
Center For Students w/Disabilities
- Facilities Report (V11) -Facilities Report reflecting CSD students
- Academic Standing Report (V11) -Academic Standing Report reflecting CSD students
- Student Services Report (Term) (V11) -Student Services Report by Term.
- Student Services Report (by Academic Year) (V11) -Student Services Report by Academic Year.
- CSD Student for a term with Disability Codes (V11) -Students with Disability Codes by Term.
- CSD Student eligible for Graduation (V11)
- Admissions and CSD Denial Checklist Report (V11)***
- Student Lookup for Checklist Assignment Info (V11)
- Project Assist Fees*** - Students with Project Assist Fees on their account.
- Work Study Students (V11)*** - DVR Students with Workstudy Data.
- Retention Report (V11)***CSD Student Retention Data
- CSD Admits with PIP Signup Information - Admitted CSD Students with PIP Signup Data
- Completed Pending Checklists (V11)Completed CSD Checklists - Used for Imagenow Processing and Routing
Chemistry Department
Colleges (all)
- Graduation RINP Report (V11)- List of students who have applied for graduation and are repeating a course(s).
- Undergraduate Graduation List (V11) - List of students who have applied for graduation.
- Admitted Students w/PIP Data (V11)- Counts of students who have have been admitted by Academic Program and Plan. Can be used to plan for incoming new freshman and transfer enrollment.
College of Arts and Communication
- College of Arts & Communication Minority Report (V11)
- Music Department Fees***
- Theatre Department Fees*** - Students with Theatre Department Fees on their account.
College of Business and Economics
- - Access the list of queries for the College of Business (Undergraduate and Graduate).
College of Education and Professional Skills
- - Access the list of queries for the College of Education Dean's Offices and Departments.
College of Letters and Sciences
Continuing Education
- Domestic Travel Study *** - Domestic Travel Study Fees
Departments
- Shared Department Queries - Access the list of queries available to all academic departments.
First Year Experience
- Event_attendance (V11)-Lists and Reports of Students signed up for Plan-It Purple Events.
- FYE Signups (V11) -Statistical Reports of Students who have signed up for Plan-It Purple Events
- Students Not Signed Up (V11) - List of admitted freshman and/or transfers who have NOT signed up for Plan-It Purple.
- New Freshman Eligible for Honors (V11) - List or individual lookup of admitted new freshman who are eligible for the Honors Program.
- Application Fee Waivers (V11)- List of Waived Application Fees
- PIP Term Activation (V11) - Report lists term activated and Status of Test Credits
- Galactic GPS (V11) - Report and List of PIP Students who are in the Galactic GPS program
- Peer Mentoring Annual Query (V11) - Peer Mentoring Annual Report and File Extract
- Transfer Student Audit (V11) - Supplies a report of Transfer Students with no ACT/SAT/UWPT and/or no Basic English and Math Courses
FP&M
Health Services
- Health Services Contact List (V11) - List of Admitted Students
Honors
- Honors Student Group List (V11)
- New Freshman Eligible for Honors (V11) - List or individual lookup of admitted new freshman who are eligible for the Honors Program.
- Honors Classes(V11) - List of Honors Classes scheduled for a specified term.
- Biology Honors Majors (V11)- List of students in the Biology Honors majors.
Housing/Res Life
- Chancellor Scholars List (V11) - List of Admitted and Matriculated Chancellor Scholars
- Application Fee Waivers (V11)- List of Waived Application Fees
- Cancelled Student Listing- List of Cancelled Students
- Housing Statistics (V11)- Report of Housing Checklist Status by Term
- Admissions/Housing/PIP Extract (V11) - Admission Type, Housing Status, and PIP Data for Data Extract
Human Resources & Diversity
- Graduation List (V11)- List for HR of students that have applied for graduation
iCIT
- Graduation List (V11) - List for iCIT of students that have applied for graduation
- GAPS Lab Fees*** - Students with GAPS Lab Fees on their account.
Learning Communities
- LC Candidates (V11)- List of Admitted Students who qualify for Learning Communities
- Signup List (V11) - List of Students Signed Up for a Learning Community
- Application Fee Waivers (V11)- List of Waived Application Fees
- LC Enrollments (V11)- List of Students Enrolled by LC
- LC Service Indicators (V11) - List of Students with Service Indicators by PIP
- LC Enrollment Audit Trail (V11) - List of LC student enrollment changes by date.
Math & Computer Science Department
- Freshman Math (V11)- Freshman Enrollment in Math by term.
- Plan-it Purple Numbers (V11) - Number of students signed up for each PIP.
Minority Business Teacher Prep
Music
- Music Admits(V11) - List of admitted students with a music major.
- Music Majors - Instrument Report (V11) - List of music majors including advisor and instrument.
- Music Minors - Instrument Report (V11) - List of music minors including advisor and instrument.
Police Services
Special Education
- Special Education Queries - Queries have been moved to the COEPS query page.
Student Accounts and Cashiers
- PIP Enrollment Deposit Status - Students Registered for PIP with an Outstanding Enrollment Deposit.
- PIP Enrollment Name - PIP event information.
- Class Fees
Testing Office
- Test Scores to be Modeled (V11)
- Test Scores Not Posted (V11)
- Arithmetic Skills (V11) - Listing of Students who have received the Arithmetic Skills Letter
Theatre & Dance
- Theatre/Dance Admits (V11) - List of admitted students with a Theatre/Dance major.
University Bookstore and Textbook Rental
- Library Textbook Rental Report*** - Textbook Rental List for Grad Taking Undergrad Classes.
University Library
- Library Fees***
- Library Textbook Rental Report*** - Textbook Rental List for Grad Taking Undergrad Classes.
Young Auditorium
- English Enrollment*** (V11) - Student enrollment count for English 101, English 102, and English 105.
