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


Tables & Data Elements

Regular student data, extracted nightly

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.

Address
Table
Elements
 
Degree Term All V
Table
Elements
  LOOKUP TABLES:
use only to decode
values in other tables
Advisor Term
Table
Elements
 
Enrollment All V
Table
Elements
 
Approved Academic Programs
Table
Elements
Assignment
Table
Elements
 
Enrollment Section Type
Table
Elements
 
Building
Table
Elements
Athletic
Table
Elements
 
Hiatus
Table
Elements
 
College House
Table
Elements
Census Term
Table
Elements
 
Internal Course Equiv
Table
Elements
 
Country
Table
Elements
Course Inventory
Table
Elements
 
Leave
Table
Elements
 
Degree
Table
Elements
Course Xlist Inventory
Table
Elements
 
Major Minor Term
Table
Elements
 
Dept
Table
Elements
Course Inventory Desc
Table
Elements
 
 
Masters Thesis
Table
Elements
 
Division
Table
Elements
Course Inv Desc Text
Table
Elements
 
Person All V
Table
Elements
 
Institution
Table
Elements
Course Sect Mtg
Table
Elements
 
PhD Committee
Table
Elements
 
Major
Table
Elements
Course Section
Table
Elements
 
PhD Dissertation
Table
Elements
 
Present Period
Table
Elements
Course Section Instructor
Table
Elements
 
Room Profile
Table
Elements
 
School
Table
Elements
Course Section Reg Control
Table
Elements


 
SRS Admissions Data
Table
Elements
 
SRS States
Table
Elements
Course Section Type Term
Table
Elements
 
Student Holds
Table
Elements
 
SRS Term Calendar
Table
Elements
 
Degree Pursual All V
Table
Elements
 

Student Term

Table
Element

 
Subject Area
Table
Elements
Degree Received
Table
Elements
 

Transcript Honors

Table
Elements

 
Student APS
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