Report Catalog

Locate Reports

Here you may browse, search for, and view information on the reports available in the Enterprise Data Warehouse (EDW).

Finding and Running Reports

  • 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

131 reports found

Displaying all reports


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


EDW User Base Volume ( ADMIN1007 )

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.

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


Faculty Appointments by Appointment Term ( AP1005 )

This report provides a list of Faculty Appointments by Appointment Term. Results may be limited by Home Department Organization and/or Appointing Department Organization. Faculty appointments with terms that are less than 9 months may be managed by the departments; this report is useful in determining those individuals that are inactive and may need further action. Faculty Appointments with appointment terms that are not 9 or 12 months may be problematic; this report can aid this review.

More Metadata

  Page 2 of 6