Tuition Distribution Collection Refresh Schedule
Tuition Distribution tables are loaded five times per term, for each of the three terms. The load schedule is set by
Student Financial Services, using the month end date from Pennant Accounts (see the operations calendar). This ensures that the tuition data in the collection
will tie to the BEN deferred income amount.
The basic schedule is as follows:
Spring: Five (5) loads, once a month, from January to May
These loads are identified in the Collection as Extract Date.
Summer: Five (5) loads, once a month, from May to September
Fall: Five (5) loads, once a month, from September to January
Source of the Data
The sources of the data in the Tuition Distribution tables are primarily snapshots of data from the Student and Pennant Accounts tables
from the Data Warehouse.
Data are collected on the enrollment and Primary Instructional Programs (Division, Degree, Major, Special Program) of the students registered,
as well as the total amount of tuition billed and paid by those Instructional Programs. From those data, calculations are performed to determine
an amount per course unit which then determines tuition distribution.
Time Span Covered
The Tuition Distribution data collection was loaded on January 26, 2006 for Fall 2004, Spring 2005, Summer 2005, and Fall 2005.
The data in the collection for those terms are valid as of that load date, (i.e., they will not match the census reports precisely).
Spring 2006 was considered test data using production feeds. Summer 2006 and Fall 2006 are production loads.