Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

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 of the BRS system. 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
Summer: Five (5) loads, once a month, from May to September
Fall: Five (5) loads, once a month, from September to January

These loads are identified in the Collection as Extract Date.

Source of the Data
The sources of the data in the Tuition Distribution tables are primarily snapshots of data from the Student and BRS_DETAIL 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.

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania