The table below will help you find information you previously accessed through Query Library. If you cannot find a Query Library query on this list, please contact us.
For new reports owned by UW-Madison, the Access Restrictions column indicates the Access Group that has permission to access the Tableau workbook. If you click on a link and find you do not have access but believe that you should, you may request access here. For new reports owned by UW System (UWBI), you can get more information here.
Name | New Report | Access Restrictions | Owner |
---|---|---|---|
ACA Student Hours Over 25.bqy | ACA Student Hours Over 25 | UWBI | System (UWBI) |
Academic Staff Job Security (Non Sensitive).bqy | Academic Staff Years in Service | UWBI | System (UWBI) |
Academic Staff Job Security (Sensitive).bqy | Academic Staff Years in Service | UWBI | System (UWBI) |
Academic Staff Time in Jobcode.bqy | Academic Staff Time in Job code | UWBI | System (UWBI) |
Academic Staff Years in Service for a Campus.bqy | Academic Staff Years in Service | UWBI | System (UWBI) |
Academic Staff Years in Service.bqy | Academic Staff Years in Service | UWBI | System (UWBI) |
Active Jobs for a Given Date Range.bqy | Jobs for a Given Date Range | UWBI | System (UWBI) |
Advisor Audit by Student Group.bqy | Advisor Assignments IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Advisor Audit.bqy | Advisor Assignments IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Advisor Notes System Assessment Data Summary.bqy | Advisor Notes System IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Average GPA by Plan or Program.bqy | Average GPAs by Academic Plan IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Biweekly Payroll Edit Checksheet.bqy | Biweekly Payroll Edit | UWBI | System (UWBI) |
Biweekly Payroll Overtime Hours for a Runid.bqy | Biweekly OT Hours | UWBI | System (UWBI) |
Biweekly Standard vs Approved Hours for a Runid.bqy | Biweekly Standard vs Approved Hours | UWBI | System (UWBI) |
Career Positions for SAs and SHs.bqy | Career Positions | UWBI | System (UWBI) |
Classified Carryover Vacation and Comp Time.bqy | Classified Carryover Vacation and Comp Time | UWBI | System (UWBI) |
Compensated Reserve Leave Balances - Non Sensitive.bqy | Reserve Leave Balances | UWBI | System (UWBI) |
Completed Graduate Minors by Program.bqy | Student Academic Awards IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Count Majors’ Courses in a Subject.bqy | Number of Courses Taken in Subject by Student and Plan IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Counting Student Majors in a Course.bqy | Course Enrollments by Student Major IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Course Enrollment History.bqy | Course Enrollments IDE | Student Data - Internal | UW-Madison (UWRAP) |
Course ID Look-up.bqy | Course Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Course Profile - Current.bqy | Course Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Course Profile History.bqy | Historical Course Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Courses of Currently Enrolled Graduate Students.bqy | Course Enrollments by Student Academic Level IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Courses Taken by Graduate Degree Recipients.bqy | Courses by Academic Awards IDE | Student Data - Internal | UW-Madison (UWRAP) |
Criminal Background Check Info.bqy | Criminal Background Check | UWBI | System (UWBI) |
Cum GPA Ranking by Major.bqy | Cumulative GPA Ranking by Academic Plan IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Current and Past Study Abroad Enrollments.bqy | Study Abroad Students IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Current Classified, Unclassified and Student Jobs.bqy | Current Employees and Jobs | UWBI | System (UWBI) |
Current Funding for Graduate Students.bqy | Current Funding for Graduate Students IDE | Employee Record Data - Restricted Student Data - Restricted | UW-Madison (UWRAP) |
Current Study Abroad Students by Major.bqy | Study Abroad Students IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Deduction Comparison.bqy | Deduction Comparison | UWBI | System (UWBI) |
Degrees and Honors Conferred to Undergraduates in a Major.bqy | Student Academic Awards IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Department Instructors’ Course History.bqy | Instructor Course History IDE | Student Data - Internal | UW-Madison (UWRAP) |
Departmental Course Enrollment by Instructor.bqy | Instructor Course History IDE | Student Data - Internal | UW-Madison (UWRAP) |
Dissertator Status Audit.bqy | Doctoral Student Milestones IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Diversity Reporting - Non Sensitive.bqy | Diversity | UWBI | System (UWBI) |
Diversity Reporting - Sensitive.bqy | Diversity | UWBI | System (UWBI) |
Employee Address General.bqy | Home Directory | UWBI | System (UWBI) |
Employee Address General.bqy | Directory | UWBI | System (UWBI) |
Employee Directory Business Address.bqy | Business Directory | UWBI | System (UWBI) |
Employee Directory Business Address.bqy | Business Directory | UWBI | System (UWBI) |
Employee First Hire Date and Years of Service.bqy | First Hire Date and Years of Service | UWBI | System (UWBI) |
Employee Hours and Earnings Query.bqy | Hours and Earnings | UWBI | System (UWBI) |
Employee Job History.bqy | Job History | UWBI | System (UWBI) |
Employee Job Probation.bqy | Job Probation | UWBI | System (UWBI) |
Employee Payroll and Deduction History.bqy | Payroll and Deductions | UWBI | System (UWBI) |
Employee Profile.bqy | Employee Profile | UWBI | System (UWBI) |
Employees Termed Five Years for a Campus.bqy | Employees Termed Five Years | UWBI | System (UWBI) |
Employees Without ACH.bqy | Employees Without ACH | UWBI | System (UWBI) |
Employment History for Grad Students.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
End of Semester Actions.bqy | Student Academic Actions IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Ended Classified, Unclassified and Student Jobs.bqy | Ended Jobs | UWBI | System (UWBI) |
Enrollment by Academic Level.bqy | Course Enrollments by Student Academic Level IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Enrollment Comparison by Department.bqy | Course Enrollments IDE | Student Data - Internal | UW-Madison (UWRAP) |
Enrollments.bqy | Course Enrollments IDE | Student Data - Internal | UW-Madison (UWRAP) |
Faculty Relationship Reports.bqy | Tenure and Relationships | UWBI | System (UWBI) |
Faculty Sabbaticals.bqy | Faculty Sabbaticals | UWBI | System (UWBI) |
First Year Students' Midterm Grades.bqy | New Freshman Midterm Grades IDE | Student Data - Restricted | UW-Madison (UWRAP) |
FTE Overload.bqy | FTE Overload | UWBI | System (UWBI) |
GPA by Academic Group and Level.bqy | Student GPAs IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Graduate Applicant Reports.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
Graduate Degrees Conferred.bqy | Student Academic Awards IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Graduate Student Directory-Demographic Info by Program.bqy | Historical Student Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Graduate Student Profiles and Directory.bqy | Student Data - Restricted | UW-Madison (UWRAP) | |
Graduate Students Applying to Multiple Programs.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
Graduate Students by Selected Grades.bqy | Student Course Grades IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Graduate Students by Student Group.bqy | Student Groups IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Health Ins Single Family Breakdown.bqy | Benefits Breakdown | UWBI | System (UWBI) |
Honor Students Enrolled in Courses.bqy | Undergraduate Honors Students in Courses IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Hourly Academic Staff Hours Worked and WRS Benefit.bqy | Hourly AS and WRS Benefit | UWBI | System (UWBI) |
HR Sensitive Personnel Data with Emergency Contact Info.bqy | Directories | UWBI | System (UWBI) |
HR Sensitive Personnel Data.bqy | Directories | UWBI | System (UWBI) |
HRS Absences Information.bqy | Absences Information | UWBI | System (UWBI) |
HRS Empl YTD Earnings-Deductions- Taxes.bqy | Empl YTD Earnings-Ded-Taxes | UWBI | System (UWBI) |
HRS Hires, Terms and Job Change Transactions.bqy | HR Transactions | UWBI | System (UWBI) |
HRS Payroll History Extract.bqy | HRS Payroll History | UWBI | System (UWBI) |
HRS Started Classified, Unclassified and Student Jobs.bqy | Hires for a Given Date Range | UWBI | System (UWBI) |
HRS Time Approver Information.bqy | Time Approver Information | UWBI | System (UWBI) |
Income Continuation Ins Deductions Report.bqy | Benefits Breakdown | UWBI | System (UWBI) |
Instructor Directory.bqy | Instructor Course History IDE | Student Data - Internal | UW-Madison (UWRAP) |
Instructor EmplIds.bqy | Instructor Course History IDE | Student Data - Internal | UW-Madison (UWRAP) |
Instructor’s Course history.bqy | Instructor Course History IDE | Student Data - Internal | UW-Madison (UWRAP) |
International Graduate Students by School-College or Plan.bqy | International Students IDE | Student Data - Restricted | UW-Madison (UWRAP) |
International Student Hours Worked - Madison.bqy | International Student Hours | UWBI | System (UWBI) |
International Student Hours Worked.bqy | International Student Hours | UWBI | System (UWBI) |
International Undergraduate and University Special Students by School or College.bqy | International Students IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Jobs On Leave.bqy | Jobs on Leave | UWBI | System (UWBI) |
Layoff Review Report.bqy | Layoff Review | UWBI | System (UWBI) |
Leave Payouts.bqy | Leave Payouts | UWBI | System (UWBI) |
Leave Taken by Employee or Deptid and for a Given Time Period.bqy | Leave Taken | UWBI | System (UWBI) |
LTE Monitoring by Anniversary Date.bqy | LTE Monitoring | UWBI | System (UWBI) |
Majors and Certificates Counts.bqy | Count of Students in Academic Plans IDE | Student Data - Internal | UW-Madison (UWRAP) |
Management Summary Data for Undergraduate Admissions.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Monitor UW Madison Grad Assts.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
Monitor Visa.bqy | Employment Visa | UWBI | System (UWBI) |
Monthly Payroll Edit Checksheet with Funding for All Jobs.bqy | Monthly Edit | UWBI | System (UWBI) |
Multiple Student Look-up by Campus Ids.bqy | Historical Student Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
New Transfer Students.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Number of Declared Majors.bqy | Count of Students in Academic Plans IDE | Student Data - Internal | UW-Madison (UWRAP) |
Number of Graduate and Professional Students - Historical.bqy | Historical Count of Students in Academic Plans IDE | Student Data - Internal | UW-Madison (UWRAP) |
Paper I-9 Remove Check.bqy | I9 Disposition | UWBI | System (UWBI) |
Past Study Abroad Students by Major or Degree(Award).bqy | Study Abroad Students IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Payroll - Workstudy Award, Job and Earnings.bqy | Workstudy Payroll Job and Earnings Information | UWBI | System (UWBI) |
Payroll Funding Edit and Placeholder Report.bqy | Payroll Funding Edit & Placeholder IDE | Employee Record Data - Internal | UW-Madison (UWRAP) |
Position of Trust.bqy | Position of Trust | UWBI | System (UWBI) |
Previous Institutions Attended.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
Prior Courses.bqy | Student Course History IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Rate and Jobcode History.bqy | Rate and Jobcode History | UWBI | System (UWBI) |
Rate History for a Deptid and Reason.bqy | Rate and Jobcode History | UWBI | System (UWBI) |
Reentry Students.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Rehired Annuitant Report.bqy | Rehired Annuitants | UWBI | System (UWBI) |
Retiree and Emeriti Contact Infomation.bqy | Retiree and Emeriti | UWBI | System (UWBI) |
Retitled HRS Jobs.bqy | Retitled Jobs | UWBI | System (UWBI) |
Returning and Readmit Students.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Salary Equity Non Sensitive.bqy | Salary Equity | UWBI | System (UWBI) |
Salary Equity Sensitive.bqy | Salary Equity | UWBI | System (UWBI) |
Salary Funding.bqy | Salary Funding IDE | Employee Record Data - Internal | UW-Madison (UWRAP) |
Specific Advisor's List of Advisees.bqy | Advisor Assignments IDE | Student Data - Restricted | UW-Madison (UWRAP) |
State Group Life Insurance Deductions Report.bqy | Benefits Breakdown | UWBI | System (UWBI) |
Student Assistant Enrollment Status for 8 Week Summer Session.bqy | Student Assistant Enrollment Status IDE | Employee Record Data - Restricted Student Data - Restricted | UW-Madison (UWRAP) |
Student Assistant Enrollment Status for Academic Year.bqy | Student Assistant Enrollment Status IDE | Employee Record Data - Restricted Student Data - Restricted | UW-Madison (UWRAP) |
Student Course Audit.bqy | Student Course History IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Student Declared Plan Changes.bqy | Student Academic Plans IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Student Enrollment & FICA Fall Spring.bqy | HR Student Enrollment Status | Student Data - Internal | UW-Madison (UWRAP) |
Student Enrollment & FICA Summer Session.bqy | HR Student Enrollment Status | Student Data - Internal | UW-Madison (UWRAP) |
Students by Selected Grades.bqy | Student Course Grades IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Students Eligible for Tuition Remission.bqy | peter.kinsley@wisc.edu | UW-Madison (UWRAP) | |
Summer Enrollments by School – College and Department.bqy | Course Enrollments IDE | Student Data - Internal | UW-Madison (UWRAP) |
Termed Employees for a Campus.bqy | Termed Employees | UWBI | System (UWBI) |
Terminated Jobs with Leave Balances.bqy | Leave Balances (Termed Jobs) | UWBI | System (UWBI) |
Timetable Audit – Class Associations.bqy | Curricular Audit Tools | UW-Madison Employees (NetID Required) | UW-Madison (UWRAP) |
Timetable Audit – Class Overlaps.bqy | Curricular Audit Tools | UW-Madison Employees (NetID Required) | UW-Madison (UWRAP) |
Timetable Audit.bqy | Curricular Audit Tools | UW-Madison Employees (NetID Required) | UW-Madison (UWRAP) |
Timetable Building-Room Search.bqy | Curricular Audit Tools | UW-Madison Employees (NetID Required) | UW-Madison (UWRAP) |
Tuition Monitoring Reports - Non Sensitive.bqy | Tuition Monitoring Detail for Non-pooled Operations | Specific/Limited Audience | UW-Madison (UWRAP) |
Tuition Monitoring Reports - Sensitive.bqy | Tuition Monitoring Detail for Non-pooled Operations | Specific/Limited Audience | UW-Madison (UWRAP) |
Unclassified Leave Usage and Balances.bqy | Leave Usage and Balance | UWBI | System (UWBI) |
Under Enrolled Classes by Department.bqy | Course Enrollment Counts by Maximum Enrollment IDE | Student Data - Internal | UW-Madison (UWRAP) |
Under Enrolled Classes by School or College.bqy | Course Enrollment Counts | Student Data - Internal | UW-Madison (UWRAP) |
Undergrads by Plan and Declaration Date.bqy | Student Academic Plans IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduate & Special Students by Selected Grades.bqy | Student Course Grades IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduate Admissions Summary.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Undergraduate Applicant Status.bqy | rebecca.everett@wisc.edu | UW-Madison (UWRAP) | |
Undergraduate Degree Cohort Course History.bqy | Student Course History IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduate Plan History.bqy | Student Academic Plans IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduate Students with Subplans.bqy | Student Academic Plans IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduate Veterans by School or College.bqy | veterans@wisc.edu | UW-Madison (UWRAP) | |
Undergraduates by Major (With Student Group filter).bqy | Student Academic Plans IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduates by School or College - L and S only.bqy | Historical Student Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduates by School or College.bqy | Historical Student Demographics IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Undergraduates by Student Group.bqy | Student Groups IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Withdrawn Undergraduate Students.bqy | Student Academic Actions IDE | Student Data - Restricted | UW-Madison (UWRAP) |
Workstudy Award Job and Earnings Info.bqy | Workstudy Award Job and Earnings Information | UWBI | System (UWBI) |