Data and Tools for ABB Tuition Revenue and Distribution Calculations

ABB Tuition Files

NEW! FY19 ABB Tuition Fall Update now available here: FY19 Fall Update (11.02.2018)
FY18 ABB True Up files now available here: FY18 ABB True Up Numbers (06.08.2018).
FY19 ABB Tuition Projections are now available here:  FY19 ABB Projections (06.08.2018)
 
Coming soon: OPB and a working group of academic administrators are working on a set of interactive dashboards to allow users to explore ABB trends by campus, college and tuition group.  Please check back later this summer for an update and information session schedule.
 
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. 

Presentations

May 2018 ABB Newcomers Presentation Slide Deck

 

ABB Questions?

Please contact us at uwir@uw.edu.

 

 

OPB