Office of Planning & Budgeting

Data and Tools for ABB Tuition Revenue and Distribution Calculations

ABB Tuition Files

NEW! FY21 ABB Tuition Projections – Preliminary FY20 true-up estimates and FY21 revenue projections are now available. These estimates are subject to change based on university, state, and federal policy changes in light of COVID-19: FY20-21 ABB Tuition Revenue (05.24.2020)

These files and files for prior years are available on OPB’s Annual Budgets webpage.

ABB Tuition Data Model and Resources

In December 2016, a number of tables were made available that enable campus users to do and see all calculations relevant to the distribution of net operating fee revenue under ABB. Links to a variety of information that will enable users to understand and use the data are provided below.

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 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: ABB tables and queries are currently under construction. OPB’s Data Architecture team is hard at work to build out a streamlined version of tables and views that will be used to create the interactive dashboards and reports for trending. As these new tables and views are developed, the ABB queries formerly provided by OPB will not work. We expect to complete the first phase of this update later this summer. Check back for more information and technical training sessions.

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 Introductory PowerPoint available on this page.

In each file, explanatory information is available on the “Reference” tab. The files currently available are:

  • The FY18 ABB Tuition Table, which includes calculation of the distribution of FY17 actual and FY18 projected tuition revenue using the new distribution parameters
  • The Excel file that provides calculations of years through FY17, using the old distribution parameters.


May 2018 ABB Newcomers Presentation slide deck

ABB Questions?

Please contact us at