Report Catalog & BI Portal

Locate Reports

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

136 reports found

Displaying all reports


Creative Communications Mailing List ( HR1009 )

Used by mailing services to create a master mailing list

More Metadata


Current Employee with Active Appointment ( PAYR1026 )

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.

More Metadata


Current Online Check Register ( PAYR1001 )

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.

More Metadata


Current Student Information By Major ( ACAD1026 )

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.

More Metadata


Current Student Information By Minor ( ACAD1029 )

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.

More Metadata


Current Student Registration Courses ( ACAD1030 )

Displays current registration information for all students in a selected major. Useful for tracking majors and satisfactory progress . Required parameters are quarter, college, and department.

More Metadata


Current Student Transcript Courses ( ACAD1027 )

Displays transcript information for all students in a selected major. Useful for satisfactory progress and tracking progress in a major. Required parameters are college, department, and major.

More Metadata


Current Student Transcript Quarterly Summary ( ACAD1031 )

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.

More Metadata


Current Student Transfer Summary ( ACAD1032 )

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.

More Metadata


Curriculum Codes ( ACAD1045 )

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.

More Metadata


Custom Budget Index Report by OrgCode ( FIN1012 )

This report displays customizable Budget Index information for selected Org Codes.

More Metadata


DAC Secured Tables, Views And Columns Overview by Roles ( ADMIN1008 )

by Roles

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.

More Metadata


DAC-Secured Tables, Views And Columns ( ADMIN1005 )

Security Metadata Administration Tool (SMAT) Settings

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.

More Metadata


Daily Aid and Refund Check Activity File ( ACAD1042 )

UW Bank Account Number 0062042015 (Bank Code Z)

Displays check register activity file for aid and refund checks issued on a given date. Useful to monitor or audit check register activity. (Similar to: SA70200-D-01)

More Metadata


Degree Codes ( ACAD1021 )

By Major Abbreviation, Pathway, Level, and Type

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.

More Metadata


Degrees and Organization Associations ( MSTR1007 )

Primary and Secondary

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.

More Metadata


Emeritus Faculty Earnings ( AP1004 )

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.

More Metadata


Employee Download ( PAYR1007 )

by Organization Code

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.

More Metadata


Employee and Payment Verification Download ( PAYR1020 )

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.

More Metadata


Employee Download ( PAYR1010 )

by PUCs

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.

More Metadata


Employee_GTN_Information ( PAYR1023 )

Selected Employee and GTN Information

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.

More Metadata


Expense and Revenue Transfer Report ( FIN1010 )

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".

More Metadata


Expense distribution by payroll unit code PUC ( PAYR1024 )

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.

More Metadata


Facility Information ( MSTR1013 )

This report displays facility-level data.

More Metadata


Facility Room Detail ( MSTR1014 )

This report displays a list of rooms for the selected facility by primary use.

More Metadata

  Page 2 of 6