Data Warehouse: Student Billing (BRS) Tables and Data Elements



	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) Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

BRS Tables

BRS_COURSE_FEE

BRS_DETAIL
Table Elements

BRS_FEE_RATE

BRS_GL_DETAIL *only in BRS_Combined universe
Elements

BRS_SUBCODE
Table Elements

BRS_SUBCODE_HISTORY_V
Table Element

"Non-BRS" Tables - only in the BRS_Combined universe

DEGREE_TERM_ALL_V (from Student collection)
Table   Elements
EMPLOYEE_GENERAL (from SalMgt collection)
Table   Elements
GL_PERIODS (from GL collection)
Table   Elements
PERSON_ALL_V (from Student collection)
Table   Elements

"Non-BRS" Tables - in both universes.

CENTER_REF_CODES Table Elements	OBJECT_CODES Table Elements
CNAC_CODES Table Elements	ORG_CODES Table Element
FUND_CODES Table Elements	PROGRAM_CODES Table Elements

Collection Information:



Information Systems and Computing University of Pennsylvania Comments & Questions