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 displays faculty with a home department in the selected OrgCode who submitted one or more applications to the UW Office of Sponsored Programs (OSP) during a FEC cycle they were paid 100% from sponsored funds.
The purpose of this report is to provide employee and paid FTE information for space coordinators and administrators to use in determining space utilization and functionalization in GeoSIMS. For each selected OrgCode, a list of employees by PI will be generated. All budget numbers contributing to an employee’s distribution (payroll) throughout FY 2013 will be shown along with the percentage each budget contributes to the FTE and the related A-21 cost pool of each budget.
The report contains faculty appointments and distributions currently appearing in HEPPS/OPUS. If there are no distributions, no appointment data will be listed; if there are multiple distributions, the appointment data is repeated. Results are filtered by the selected Home Department Organization Code. All appointments (in all Appointing Departments) for faculty in the selected Home Department are shown. The faculty included in this report are those with a Service Period >= to 9.0. Appointments with an Hourly Pay Rate are excluded. It is for use by Academic Human Resources.
This report returns a list of active academic personnel, including FTE %, Paid FTE %, and full time rate, based on selected reporting and organizational codes. As personnel lists can change, data is returned based on the user-defined pay cycle end date. PaidFTE is derived for each appt by summing all 'Regular Equivalent Earnings' (earn types: REG, PLP, TFA, S/L, MLP, TRN, SUM) from Actual Distributions and dividing by the Full-Time Rate. Note: 9-month Faculty who are not paid during the summer will not appear during summer quarter pay cycles.
Lists all active academic personnel for a selected Pay Period and a selected group of org units and job class codes. The appt FTE % and Full-Time Rate are as set in OPUS/HEPPS. PaidFTE is derived for each appt by summing all 'Regular Equivalent Earnings' (earn types: REG, PLP, TFA, S/L, SUM, MLP, TRN) from Actual Distributions and dividing by the Full-Time Rate. EXPORT INSTRUCTIONS: To export a nicely formatted Excel file, select 'XML file with report data' which saves the file with an .xml file extension, Open Excel, find that file looking at all file types, and open it.
Student account charges on charge code CHARGECODE - NAME for QRT quarter of YYYY for BRANCH.
Displays detailed charge information (i.e., amount charged, affixed, exempted and unpaid) by student for any entered charge code or charge code range within a date range. It is most useful for reviewing charge amounts placed on student accounts as well as determining which students have an outstanding balance. (Similar to: SDB Report SA70110-R-04)
Displays the dollar amount of aid authorized and disbursed by student number and name for a specified award fund/budget within each quarter over a given aid year. Report is useful for determining if all aid has been disbursed to students over the course of a year, or within a given quarter. For an individual quarter and award fund/budget, see "Aid Authorized and Disbursed by Quarter" report. (Similar to: SA70140-D-02)
Award Fund/Budget XX-XXXX for YYYY QRT Quarter | [ Exceptions Only | All Records ]
Displays the dollar amount of aid authorized and disbursed, and the difference between the two, by student number and name for a given fund/budget for a specified quarter and aid year. Report is useful for determining if all aid has been disbursed to students, or listing all students receiving aid, within a given fund/budget. For an complete year, see "Aid Authorized and Disbursed by Year" report. (Similar to: SA70140-D-04)
Biennium Budget Balance report (previously the Biennium Close Report) shows GOF, DOF-LFA and DOF-ICR funds and ROF for 608 and 609 for each unit. They are grouped by Budget Type/Budget Class and may be viewed in more detail by Org Major Area, Org Department, budget number and account code. These reports provide the units’ authorized biennial budgets, actual to-date expenditures, encumbrances, balance to-date, and expended percentage (i.e.: actual to-date plus encumbrance divided by the biennial budget). Fixed cost budgets are not included in this report.
Data is updated periodically (see the Biennium Budget Balance Report timeline at http://opb.washington.edu/content/biennium-close-process).
To export the data to Excel without titles or formatting, click "View raw data (for Excel export)", then select "Excel" format and click "Export".
The Budget Type/Class Matrix is used to classify and group budgets by their funding sources and is maintained by the Office of Planning and Budgeting. This classification system facilitates fiscal reporting and internal monitoring of budgets and funding levels.
The Matrix comprises four hierarchical levels of Budgets: Community > Family > Super Class > Type/Class. Budget Type/Class codes are assigned to budgets when they are created.
Budget Type/Class code is a 4 digit code used to classify budgets by funding source. The first two digits represent the Budget Type, the last two digits represent the Budget Class, the lowest grain of budget grouping.
Displays cashier payment transactions by student number, payment amount, bank deposit reference number, time of transaction and amount tendered by cashier ID. Useful for verifying cashier daily balance and otherwise auditing cashier drawers (similar to SDB report: SA32010-D-01 K)
Current roster of registered or no longer registered students for each course by curriculum, course and section. Useful for reviewing satisfactory progress, managing curriculum, determining course overload issues. This report does not include grade information. Required selection parameters are year, quarter, college, department, curriculum, course number, and course section.
Displays the Student Database (SDB) and Planning & Budgeting (PNB) organization codes and names based on links defined by the Financial Accounting System (FAS) org_code that exists in both systems. The comparison is between all campuses, colleges and departments from SDB records, and the campuses, colleges and departments associated with an academic unit in the current quarter from the PNB.
This report supercedes all varieties of the discontinued paper-based Consolidated Budget Status Report AM28619 and AM28225. It can be used to view current budget status information by OrgCode or by Parent Budget/Grant.
This report provides contact information for all students who have attempted to register for a specified course and been denied for lack of space. Useful for contacting students when new sections are opened. Required parameters are Curriculum and Course Number.
This report provides email and mailing addresses for all students registered for a selected quarter in a specified major. Useful for creating email lists. Required parameters are year, quarter, and major.