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

121 reports found

Displaying all reports


100 Percent Sponsor-Funded Faculty ( FIN1065 )

This report displays Faculty with a Home Department in the selected Org Code(s) who have made Grant Proposals during periods they were paid 100% from sponsored funds.

More Metadata


Academic HR FAC Reappointment Download ( AP1003 )

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.

More Metadata


Academic Personnel Appointments ( AP1001 )

Appointment FTE, Paid FTE and Full Time Rate

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.

More Metadata


Academic Personnel Appointments with Demographics ( AP1010 )

Active appointments as of [date]

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

More Metadata


Active Job Classes ( HR1007 )

Parameter driven list of job classes, to allow users to determine correct job classes for running other mailing list reports.

More Metadata


Advance Budget Number Report ( FIN1066 )

This report displays a list of grant and contract budgets in advance funding status for a selected Org Code structure. No historical information is reported.

More Metadata


Affixed Payment Detail ( ACAD1014 )

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)

More Metadata


Aid Authorization and Disbursement by Year ( ACAD1020 )

By Fund Number and Student Name

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)

More Metadata


Aid Authorized and Disbursed for Aid Year and Quarter ( ACAD1038 )

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)

More Metadata


Biennium Budget Balances report ( FIN1061 )

Biennium Budget Balance report (previously the Biennium Close Report) shows GOF, DOF-LFA and DOF-RCR 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 2009-11 Biennium Budget Balance Report timeline http://www.washington.edu/admin/pb/home/pdf/bc-timeline-0911.pdf). To export the data to Excel without titles or formatting, click "View raw data (for Excel export)", then select "Excel" format and click "Export".

More Metadata


Budget Detail by Payroll Unit ( PAYR1004 )

This report is a drill through report from Payment/Budget Verification report. This report provides additional information about budgetary breakout and supporting detail.

More Metadata


Budget Summary by OrgCode ( FIN1016 )

This report displays budgeted amounts, encumbrances, transaction totals, and budget balances for the selected Org Codes, by account code, during a reporting period.

More Metadata


Budget Type Class Matrix ( FIN1027 )

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.

More Metadata


Building Summary by OrgCode ( MSTR1009 )

This report displays a summary of assignable square feet, capacity, and count of rooms by OrgCode for each OrgCode that has assigned space in the facility. The facility code, number, and name are options that can be used to filter the data.

More Metadata


Building Summary by Primary Use ( MSTR1010 )

This report displays a summary of assignable square feet, capacity, and count of rooms by primary use for a facility. A filter option to locate one or more facilities by facility code, number, and name is available.

More Metadata


Cashier Activity Report - Payments Received ( ACAD1041 )

Payment Activty for Cashier IDs for MM/DD/YYYY

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)

More Metadata


Class List By Curriculum Course Section ( ACAD1034 )

For the selected year/quarter, this list displays students who are either registered or have withdrawn from the course/section, depending on the user selections made.

More Metadata


College Space Data ( MSTR1012 )

This report displays a summary of assignable square feet, capacity, and count of rooms for each OrgCode and facility that an Org Dean-level unit has assigned space in. The report is similar to the College Space Data by OrgCode report but presents the information in a different order. Information in College Space Data is presented in order of facility and then organization.

More Metadata


College Space Data by OrgCode ( MSTR1011 )

This report displays a summary of assignable square feet, capacity, and count of rooms for each OrgCode and facility that an Org Dean-level unit has assigned space in. The report is similar to the College Space Data report but presents the information in a different order. Information in College Space Data by OrgCode is presented in order of organization and then facility.

More Metadata


Comparison of SDB & PNB Organization Hierarchies ( MSTR1001 )

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.

More Metadata


Consolidated Budget Status Report Menu ( FIN1021 )

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.

More Metadata


Contact Information - Majors ( ACAD1015 )

This report provide contact information for all students who are registered for credit in a given year/quarter and who have a given major. The user may select the year/quarter and the major. Contact information include local and permanent mailing addresses and phone numbers as well as email address. A clear notation is made of those students who have placed a FERPA block on their records

More Metadata


Contact Information - Unmet Requests ( ACAD1017 )

This report provide contact information for all students who have attempted to register for a selected course in a specified year/quarter and been denied for lack of space. The user may select the year/quarter, the curriculum and the course number . Contact information include local and permanent mailing addresses and phone numbers as well as email address. A clear notation is made of those students who have placed a FERPA block on their records

More Metadata


Creative Communications Mailing List ( HR1009 )

Used by mailing services to create a master mailing list

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

  Page 1 of 5