Founded in 1861, the University of Washington is one of the oldest state-supported institutions of higher education on the West
Coast and is one of the preeminent research universities in the world. Learn more
The UW is committed to improving the student experience. Plans currently are under way to remodel the Husky Union
Building, expand the Ethnic Cultural Center and remodel the Hall Health Primary Care Center. Learn more about Student Life
Exceptional learning opportunities are around every corner. Our students have gone to the moon. Mapped the human genome.
Broken the sound barrier. Created vaccines. Negotiated peace. What amazing things will UW grads do next? Read more
The University of Washington recruits the best, most diverse and innovative faculty and staff from around the world,
encouraging a vibrant intellectual community for our students. We promote access to excellence and strive to inspire through education.
Vision & Values
No matter where you are, Husky Happy Hours are a great way to plug into the University of Washington's strong network
of alumni. Connect with UW grads in a casual setting and meet fellow alumni in your area. Details
The Report Catalog available on this page, is the original tool designed to help you search for and learn more about Enterprise Data Warehouse (EDW) reports. The Report Catalog contains some search functionality not yet in the Business Intelligence Portal, while the Portal contains all new ways of learning about reports and analytics. Visit the BI Portal to see the new face of report and analytics exploration at UW. Or jump down to the Finding and Running Reports Using the Report Catalog section of this page to learn more about how to use the Report Catalog.
New! UW Business Intelligence Portal
The new, feature-packed Business Intelligence (BI) Portal is now live. This intuitive site connects you to UW Enterprise Data Warehouse central reports and analytics.
Star your favorites, see what's trending, get report recommendations, stay abreast of new releases, see the underlying SQL queries, peruse data definitions, read how others are using reports, add your feedback, and more. This guided tour shows you how.
(UW NetID required)
Finding and Running Reports Using the Report Catalog
Search for a report using the Browse or Search tabs to the right.
TIP: As you make selections in these tabs, the list of reports displayed below changes to match your selection.
To run a report, you need an account. When you find the report you want to run, click on the blue report name below.
When prompted to log in, your username is "netid\yournetid", without the quotes and replacing yournetid with your own UW NetID. Then of course enter your NetID password.
TIP: Internet Explorer provides the best browsing experience as some functionality is not available in other browsers
This report contains summarized appointments by organization code. This report provide HR information for strategic planning and reporting on personnel salaries.
This report only display employees with earn type "REG" and "LWO". You can filter your selection by college, home department, appointing department as well as select one or more employment types and pay rate codes. To export data directly into Excel in raw form without the extraneous formatting associated with the standard Excel export option, choose "XML file with Report Data" from the export menu.
This is the official Check Register for the purposes of verifying accurate payday earnings for all employees of a Payroll Unit. This report is to be accessed prior to payday to verify payments to employees and view current advice print status of all employees in a Payroll Unit.
Creates a roster with information about currently registered students in a specified minor. Displays student demographic information, majors, and GPAs for students registered in the current quarter. Required parameters are college, department, and major.
Creates a roster with contact information for currently registered students in a specified minor. Displays student demographic information, majors, and academic information. Required parameters are college, department, and minor.
Displays quarterly transcript summary information for students in a selected major for a selected quarter. Useful for tracking quarterly progress, and you can click through to full transcript information for an individual student. Required parameters are Quarter, College, Department, and Major.
Creates a roster of currently-registered transfer students within a selected major and provides a summary of information about the students' prior schools. Useful for a quick overview of prior academic work, and also allows access to full transcript details for individual students. Required parameters are College, Department, and Major.
Displays information about curriculum codes for selected departments. Useful for seeing which curricula are controlled by a department or for seeing what CIP code is associated with a curriculum. Required parameters are College and Department.
The report shows an overview of DAC Secured Tables and the counts of restricted and available columns for each role. The report initially displays the selected role and a list of associated databases with Restricted Column and Available Column counts for each database within the role. The report could be further drilled down to display Table Name and Column Name. Toggle switch (+) expands Database Name, Table Name and Column Name. A green Column Name indicates role has access to the column. A red Column Name indicates role has no access to the column. Restricted Column indicates column count restricted to the role, Available Column indicates column count available to the role and Total Column indicates the total number of column in the database. *Please note: Due to efficiency reasons, the maximum row limit is 80,000 for this report. It is recommended not more than 3 roles are selected when running this report.
This report shows the current security settings for each table that has had the Data Management Committee's Roles And Access Matrix security settings applied (also known as each DAC-enabled table). This report displays the security Roles as column headings and the columns within the selected table as rows in this display. A red N directly below the Role name indicates that role does not have access to the entire table. A red Y in the Restricted Column column indicates that column is considered sensitive per the Roles And Access Matrix. A red N inside the matrix indicates the Role does not have access to that column within the table.
Displays information about degree codes for selected departments. Useful for finding a code when filling out a change of major form or filing a graduation application, or for looking up a degree's tuition category. Required parameters are College and Department.
List of University degrees for the time period selected and their associated financial organizations. Degrees may be assocciated with more than one financial organization. The primary organization is indicated as a "Y" in the "Primary Ind" column. All other associations will be indicated by "N". Degrees without associations will NOT be displayed.
This chart displays the number of people who have been granted access to Enterprise Data Warehouse (EDW) data and reports at a given point in time. Access to EDW resources is granted by the Data Management Committee (DMC), who assigns each user to a role associated with selected security settings. Learn more about the user roles and their security settings by clicking the DMC's Roles & Access Matrix Information link below.
Produces a list of payments during the specified payment period for emeritus faculty paid using the “TFA” earn type. Results may be limited by Home Department Organization and/or Appointing Department Organization.
This report contains university-wide appointments and distributions by organization code. If there are multiple distributions, the appointment data is repeated. You can filter your selection by college, home department, appointing department as well as select one or more employment types and pay rate codes.
This report provides employee information for a specific pay period. This information includes basic Appointment, Distribution and Payment information. This report detail is based on the Home Department PUC.
This report contains university-wide appointments and distributions by PUC. If there are multiple distributions, the appointment data is repeated. You can filter your selection by home department or appointing department as well as select one or more employment types and pay rate codes.
This report shows all history in the Data Warehouse for Deductions and Contributions by Employee
Note: An employee may have more that one EID over the course of their career at UW. Make sure you have checked for this.
Note: Data prior to the early 1990's had a portion deleted. If you are looking for information prior to the early 1990's use a different source.
This report displays posted expense and revenue transfers for selected Org Codes for a selected date range. It is similar to the MyFinancial.desktop “Posted Expense Transfer” query template, but also includes transfers initiated in other applications - e.g. FASTRANS. Grant Budgets are defined in this context as those with a Budget Type of "05".
This is a payroll distribution expense report. The user can choose either Home Department Payroll Unit Code (PUC) or Distribution Department PUC to select related distribution records for a chosen pay cycle end date month and year.