Office of Planning & Budgeting

Data and tools for ABB tuition revenue and distribution calculations

ABB tuition files

NEW! The Preliminary 2021–22 Workbook (released May 5, 2021) contains preliminary FY21 true-up estimates and FY22 revenue projections. These estimates are subject to change based on university, state and federal policy changes. For more exploration of activity trends, please visit our new dashboards (available on the UW Network or VPN and Netid needed).

These files and files for prior years are available on the Office of Planning & Budgeting’s (OPB) annual budgets webpage.

ABB tuition data model and resources

In December 2016, OPB made a number of tables available that enable campus users to see and perform all calculations relevant to the distribution of net operating-fee revenue under ABB. See below for links to a variety of information that will enable you to understand and use the data.

Please note that a number of improvements — including, but not limited to, the ability to include students with exemptions as well as data-quality checks — have been made as the data have been moved to the AnalyticInteg database (AIDB). The budget allocations made through FY16 under ABB represent final allocation decisions; no changes to budgets for prior years will be made on the basis of the data now made available through AIDB. Historical data are included here only to facilitate trend analysis.

NOTE: As part of the ABB Phase III recommendations, OPB is working on two levels of dashboards to be made available to the campus community. The first high-level trending dashboards will be posted to this website once completed (est. Winter 2021). The exploratory dashboards, currently underway, will be made available to Deans and Academic Admins during the spring census period.

Data model details

Documentation and code for ABB tuition calculations:

  • Documentation of how to connect to data and perform all necessary calculations.
  • SQL code that performs ABB tuition calculations using the new distribution parameters
  • SQL code that provides the basis for projecting tuition revenue pools by campus, tuition category and residency. This code is used in the Excel-based ABB tuition files to provide projections. The general approach to projections is outlined in the Introduction: Operating Fee Revenue Distribution Calculations for ABB PowerPoint above.

Tuition tables:
Explanatory information is available on the Reference tab. The files currently available are:

  • FY18 ABB tuition table, with calculations of the distribution of FY17 actual and FY18 projected tuition revenue using the new distribution parameters
  • Excel file with calculations of years through FY17 using the old distribution parameters

ABB questions?

Please contact us at uwir@uw.edu.