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

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 (referenced in several universes)
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:

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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