Data Warehouse: Student Billing (BRS) Data Collection



	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
	Learning Management
	OIP
	Position Inventory
	Research-PennERA Proposals
	Salary Management
	Student
	Tuition Distribution
	Cross-Collection

Student Billing (BRS) Refresh Schedule

The BRS_DETAIL table is refreshed on a daily basis, Monday through Friday, following SRS and BRS source system processing. The BRS_SUBCODE, BRS_COURSE_FEE and BRS_FEE_RATE lookup tables are refreshed on an ad hoc basis, usually after SRFS has changed the source tables.

Source of the Data
The sources of the data in the BRS_DETAIL table are the Bursar_Detail, Intermediate and History files, which contain data from the online Billing and Receivables System (BRS). Together, these files represent all the data on a student account. The BRS_SUBCODE, BRS_COURSE_FEE and BRS_FEE_RATE tables contain only the most current versions of the subcode, course fee and tuition rate lookup data.

Time Span Covered
The BRS data collection stores from fiscal year 2003 and on. Select records from years previous to fiscal 2003 are also available, in cases where older charges have not been fully paid and applied.

Collection Information:



Information Systems and Computing University of Pennsylvania Comments & Questions