Query Library Crosswalk

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 ReportAccess RestrictionsOwner
ACA Student Hours Over 25.bqy ACA Student Hours Over 25 UWBISystem (UWBI)
Academic Staff Job Security (Non Sensitive).bqyAcademic Staff Years in Service UWBISystem (UWBI)
Academic Staff Job Security (Sensitive).bqyAcademic Staff Years in Service UWBISystem (UWBI)
Academic Staff Time in Jobcode.bqy Academic Staff Time in Job code UWBISystem (UWBI)
Academic Staff Years in Service for a Campus.bqy Academic Staff Years in Service UWBISystem (UWBI)
Academic Staff Years in Service.bqyAcademic Staff Years in Service UWBISystem (UWBI)
Active Jobs for a Given Date Range.bqy Jobs for a Given Date Range UWBISystem (UWBI)
Advisor Audit by Student Group.bqyAdvisor Assignments IDEStudent Data - RestrictedUW-Madison (UWRAP)
Advisor Audit.bqyAdvisor Assignments IDEStudent Data - RestrictedUW-Madison (UWRAP)
Advisor Notes System Assessment Data Summary.bqyAdvisor Notes System IDEStudent Data - RestrictedUW-Madison (UWRAP)
Average GPA by Plan or Program.bqyAverage GPAs by Academic Plan IDEStudent Data - RestrictedUW-Madison (UWRAP)
Biweekly Payroll Edit Checksheet.bqy Biweekly Payroll Edit UWBISystem (UWBI)
Biweekly Payroll Overtime Hours for a Runid.bqy Biweekly OT Hours UWBISystem (UWBI)
Biweekly Standard vs Approved Hours for a Runid.bqy Biweekly Standard vs Approved Hours UWBISystem (UWBI)
Career Positions for SAs and SHs.bqy Career Positions UWBISystem (UWBI)
Classified Carryover Vacation and Comp Time.bqy Classified Carryover Vacation and Comp Time UWBISystem (UWBI)
Compensated Reserve Leave Balances - Non Sensitive.bqy Reserve Leave Balances UWBISystem (UWBI)
Completed Graduate Minors by Program.bqyStudent Academic Awards IDEStudent Data - RestrictedUW-Madison (UWRAP)
Count Majors’ Courses in a Subject.bqyNumber of Courses Taken in Subject by Student and Plan IDEStudent Data - RestrictedUW-Madison (UWRAP)
Counting Student Majors in a Course.bqyCourse Enrollments by Student Major IDEStudent Data - RestrictedUW-Madison (UWRAP)
Course Enrollment History.bqyCourse Enrollments IDEStudent Data - InternalUW-Madison (UWRAP)
Course ID Look-up.bqyCourse Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Course Profile - Current.bqyCourse Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Course Profile History.bqyHistorical Course Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Courses of Currently Enrolled Graduate Students.bqyCourse Enrollments by Student Academic Level IDEStudent Data - RestrictedUW-Madison (UWRAP)
Courses Taken by Graduate Degree Recipients.bqyCourses by Academic Awards IDEStudent Data - InternalUW-Madison (UWRAP)
Criminal Background Check Info.bqy Criminal Background Check UWBISystem (UWBI)
Cum GPA Ranking by Major.bqyCumulative GPA Ranking by Academic Plan IDEStudent Data - RestrictedUW-Madison (UWRAP)
Current and Past Study Abroad Enrollments.bqyStudy Abroad Students IDEStudent Data - RestrictedUW-Madison (UWRAP)
Current Classified, Unclassified and Student Jobs.bqy Current Employees and Jobs UWBISystem (UWBI)
Current Funding for Graduate Students.bqyCurrent Funding for Graduate Students IDEEmployee Record Data - Restricted
Student Data - Restricted
UW-Madison (UWRAP)
Current Study Abroad Students by Major.bqyStudy Abroad Students IDEStudent Data - RestrictedUW-Madison (UWRAP)
Deduction Comparison.bqy Deduction Comparison UWBISystem (UWBI)
Degrees and Honors Conferred to Undergraduates in a Major.bqyStudent Academic Awards IDEStudent Data - RestrictedUW-Madison (UWRAP)
Department Instructors’ Course History.bqyInstructor Course History IDEStudent Data - InternalUW-Madison (UWRAP)
Departmental Course Enrollment by Instructor.bqyInstructor Course History IDEStudent Data - InternalUW-Madison (UWRAP)
Dissertator Status Audit.bqyDoctoral Student Milestones IDEStudent Data - RestrictedUW-Madison (UWRAP)
Diversity Reporting - Non Sensitive.bqy Diversity UWBISystem (UWBI)
Diversity Reporting - Sensitive.bqy Diversity UWBISystem (UWBI)
Employee Address General.bqy Home Directory UWBISystem (UWBI)
Employee Address General.bqy Directory UWBISystem (UWBI)
Employee Directory Business Address.bqy Business Directory UWBISystem (UWBI)
Employee Directory Business Address.bqy Business Directory UWBISystem (UWBI)
Employee First Hire Date and Years of Service.bqy First Hire Date and Years of Service UWBISystem (UWBI)
Employee Hours and Earnings Query.bqy Hours and Earnings UWBISystem (UWBI)
Employee Job History.bqy Job History UWBISystem (UWBI)
Employee Job Probation.bqy Job Probation UWBISystem (UWBI)
Employee Payroll and Deduction History.bqy Payroll and Deductions UWBISystem (UWBI)
Employee Profile.bqy Employee Profile UWBISystem (UWBI)
Employees Termed Five Years for a Campus.bqy Employees Termed Five Years UWBISystem (UWBI)
Employees Without ACH.bqy Employees Without ACH UWBISystem (UWBI)
Employment History for Grad Students.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
End of Semester Actions.bqyStudent Academic Actions IDEStudent Data - RestrictedUW-Madison (UWRAP)
Ended Classified, Unclassified and Student Jobs.bqy Ended Jobs UWBISystem (UWBI)
Enrollment by Academic Level.bqyCourse Enrollments by Student Academic Level IDEStudent Data - RestrictedUW-Madison (UWRAP)
Enrollment Comparison by Department.bqyCourse Enrollments IDEStudent Data - InternalUW-Madison (UWRAP)
Enrollments.bqyCourse Enrollments IDEStudent Data - InternalUW-Madison (UWRAP)
Faculty Relationship Reports.bqy Tenure and Relationships UWBISystem (UWBI)
Faculty Sabbaticals.bqy Faculty Sabbaticals UWBISystem (UWBI)
First Year Students' Midterm Grades.bqyNew Freshman Midterm Grades IDEStudent Data - RestrictedUW-Madison (UWRAP)
FTE Overload.bqy FTE Overload UWBISystem (UWBI)
GPA by Academic Group and Level.bqyStudent GPAs IDEStudent Data - RestrictedUW-Madison (UWRAP)
Graduate Applicant Reports.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
Graduate Degrees Conferred.bqyStudent Academic Awards IDEStudent Data - RestrictedUW-Madison (UWRAP)
Graduate Student Directory-Demographic Info by Program.bqyHistorical Student Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Graduate Student Profiles and Directory.bqyStudent Data - RestrictedUW-Madison (UWRAP)
Graduate Students Applying to Multiple Programs.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
Graduate Students by Selected Grades.bqyStudent Course Grades IDEStudent Data - RestrictedUW-Madison (UWRAP)
Graduate Students by Student Group.bqyStudent Groups IDEStudent Data - RestrictedUW-Madison (UWRAP)
Health Ins Single Family Breakdown.bqy Benefits Breakdown UWBISystem (UWBI)
Honor Students Enrolled in Courses.bqyUndergraduate Honors Students in Courses IDEStudent Data - RestrictedUW-Madison (UWRAP)
Hourly Academic Staff Hours Worked and WRS Benefit.bqy Hourly AS and WRS Benefit UWBISystem (UWBI)
HR Sensitive Personnel Data with Emergency Contact Info.bqy Directories UWBISystem (UWBI)
HR Sensitive Personnel Data.bqy Directories UWBISystem (UWBI)
HRS Absences Information.bqy Absences Information UWBISystem (UWBI)
HRS Empl YTD Earnings-Deductions- Taxes.bqy Empl YTD Earnings-Ded-Taxes UWBISystem (UWBI)
HRS Hires, Terms and Job Change Transactions.bqy HR Transactions UWBISystem (UWBI)
HRS Payroll History Extract.bqy HRS Payroll History UWBISystem (UWBI)
HRS Started Classified, Unclassified and Student Jobs.bqy Hires for a Given Date Range UWBISystem (UWBI)
HRS Time Approver Information.bqy Time Approver Information UWBISystem (UWBI)
Income Continuation Ins Deductions Report.bqy Benefits Breakdown UWBISystem (UWBI)
Instructor Directory.bqyInstructor Course History IDEStudent Data - InternalUW-Madison (UWRAP)
Instructor EmplIds.bqyInstructor Course History IDEStudent Data - InternalUW-Madison (UWRAP)
Instructor’s Course history.bqyInstructor Course History IDEStudent Data - InternalUW-Madison (UWRAP)
International Graduate Students by School-College or Plan.bqyInternational Students IDEStudent Data - RestrictedUW-Madison (UWRAP)
International Student Hours Worked - Madison.bqyInternational Student HoursUWBISystem (UWBI)
International Student Hours Worked.bqy International Student Hours UWBISystem (UWBI)
International Undergraduate and University Special Students by School or College.bqyInternational Students IDEStudent Data - RestrictedUW-Madison (UWRAP)
Jobs On Leave.bqy Jobs on Leave UWBISystem (UWBI)
Layoff Review Report.bqy Layoff Review UWBISystem (UWBI)
Leave Payouts.bqy Leave Payouts UWBISystem (UWBI)
Leave Taken by Employee or Deptid and for a Given Time Period.bqy Leave Taken UWBISystem (UWBI)
LTE Monitoring by Anniversary Date.bqy LTE Monitoring UWBISystem (UWBI)
Majors and Certificates Counts.bqyCount of Students in Academic Plans IDEStudent Data - InternalUW-Madison (UWRAP)
Management Summary Data for Undergraduate Admissions.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Monitor UW Madison Grad Assts.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
Monitor Visa.bqy Employment Visa UWBISystem (UWBI)
Monthly Payroll Edit Checksheet with Funding for All Jobs.bqy Monthly Edit UWBISystem (UWBI)
Multiple Student Look-up by Campus Ids.bqyHistorical Student Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
New Transfer Students.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Number of Declared Majors.bqyCount of Students in Academic Plans IDEStudent Data - InternalUW-Madison (UWRAP)
Number of Graduate and Professional Students - Historical.bqyHistorical Count of Students in Academic Plans IDEStudent Data - InternalUW-Madison (UWRAP)
Paper I-9 Remove Check.bqy I9 Disposition UWBISystem (UWBI)
Past Study Abroad Students by Major or Degree(Award).bqyStudy Abroad Students IDEStudent Data - RestrictedUW-Madison (UWRAP)
Payroll - Workstudy Award, Job and Earnings.bqy Workstudy Payroll Job and Earnings Information UWBISystem (UWBI)
Payroll Funding Edit and Placeholder Report.bqyPayroll Funding Edit & Placeholder IDEEmployee Record Data - InternalUW-Madison (UWRAP)
Position of Trust.bqyPosition of TrustUWBISystem (UWBI)
Previous Institutions Attended.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
Prior Courses.bqyStudent Course History IDEStudent Data - RestrictedUW-Madison (UWRAP)
Rate and Jobcode History.bqy Rate and Jobcode History UWBISystem (UWBI)
Rate History for a Deptid and Reason.bqy Rate and Jobcode History UWBISystem (UWBI)
Reentry Students.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Rehired Annuitant Report.bqy Rehired Annuitants UWBISystem (UWBI)
Retiree and Emeriti Contact Infomation.bqy Retiree and Emeriti UWBISystem (UWBI)
Retitled HRS Jobs.bqy Retitled Jobs UWBISystem (UWBI)
Returning and Readmit Students.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Salary Equity Non Sensitive.bqy Salary Equity UWBISystem (UWBI)
Salary Equity Sensitive.bqy Salary Equity UWBISystem (UWBI)
Salary Funding.bqySalary Funding IDEEmployee Record Data - InternalUW-Madison (UWRAP)
Specific Advisor's List of Advisees.bqyAdvisor Assignments IDEStudent Data - RestrictedUW-Madison (UWRAP)
State Group Life Insurance Deductions Report.bqy Benefits Breakdown UWBISystem (UWBI)
Student Assistant Enrollment Status for 8 Week Summer Session.bqyStudent Assistant Enrollment Status IDEEmployee Record Data - Restricted
Student Data - Restricted
UW-Madison (UWRAP)
Student Assistant Enrollment Status for Academic Year.bqyStudent Assistant Enrollment Status IDEEmployee Record Data - Restricted
Student Data - Restricted
UW-Madison (UWRAP)
Student Course Audit.bqyStudent Course History IDEStudent Data - RestrictedUW-Madison (UWRAP)
Student Declared Plan Changes.bqyStudent Academic Plans IDEStudent Data - RestrictedUW-Madison (UWRAP)
Student Enrollment & FICA Fall Spring.bqyHR Student Enrollment StatusStudent Data - InternalUW-Madison (UWRAP)
Student Enrollment & FICA Summer Session.bqyHR Student Enrollment StatusStudent Data - InternalUW-Madison (UWRAP)
Students by Selected Grades.bqyStudent Course Grades IDEStudent Data - RestrictedUW-Madison (UWRAP)
Students Eligible for Tuition Remission.bqypeter.kinsley@wisc.eduUW-Madison (UWRAP)
Summer Enrollments by School – College and Department.bqyCourse Enrollments IDEStudent Data - InternalUW-Madison (UWRAP)
Termed Employees for a Campus.bqy Termed Employees UWBISystem (UWBI)
Terminated Jobs with Leave Balances.bqy Leave Balances (Termed Jobs) UWBISystem (UWBI)
Timetable Audit – Class Associations.bqyCurricular Audit ToolsUW-Madison Employees (NetID Required)UW-Madison (UWRAP)
Timetable Audit – Class Overlaps.bqyCurricular Audit ToolsUW-Madison Employees (NetID Required)UW-Madison (UWRAP)
Timetable Audit.bqyCurricular Audit ToolsUW-Madison Employees (NetID Required)UW-Madison (UWRAP)
Timetable Building-Room Search.bqyCurricular Audit ToolsUW-Madison Employees (NetID Required)UW-Madison (UWRAP)
Tuition Monitoring Reports - Non Sensitive.bqyTuition Monitoring Detail for Non-pooled OperationsSpecific/Limited AudienceUW-Madison (UWRAP)
Tuition Monitoring Reports - Sensitive.bqyTuition Monitoring Detail for Non-pooled OperationsSpecific/Limited AudienceUW-Madison (UWRAP)
Unclassified Leave Usage and Balances.bqy Leave Usage and Balance UWBISystem (UWBI)
Under Enrolled Classes by Department.bqyCourse Enrollment Counts by Maximum Enrollment IDEStudent Data - InternalUW-Madison (UWRAP)
Under Enrolled Classes by School or College.bqyCourse Enrollment CountsStudent Data - InternalUW-Madison (UWRAP)
Undergrads by Plan and Declaration Date.bqyStudent Academic Plans IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduate & Special Students by Selected Grades.bqyStudent Course Grades IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduate Admissions Summary.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Undergraduate Applicant Status.bqyrebecca.everett@wisc.eduUW-Madison (UWRAP)
Undergraduate Degree Cohort Course History.bqyStudent Course History IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduate Plan History.bqyStudent Academic Plans IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduate Students with Subplans.bqyStudent Academic Plans IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduate Veterans by School or College.bqyveterans@wisc.eduUW-Madison (UWRAP)
Undergraduates by Major (With Student Group filter).bqyStudent Academic Plans IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduates by School or College - L and S only.bqyHistorical Student Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduates by School or College.bqyHistorical Student Demographics IDEStudent Data - RestrictedUW-Madison (UWRAP)
Undergraduates by Student Group.bqyStudent Groups IDEStudent Data - RestrictedUW-Madison (UWRAP)
Withdrawn Undergraduate Students.bqyStudent Academic Actions IDEStudent Data - RestrictedUW-Madison (UWRAP)
Workstudy Award Job and Earnings Info.bqy Workstudy Award Job and Earnings Information UWBISystem (UWBI)
Skip to content