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

Warehouse Infrastructure Tables & Data Elements

There are a number of tables that are used throughout Warehouse processes, and which are not unique to a particular data collection or source system. While these infrastructure tables are not typically available to end users of the Warehouse, they are documented here for informational purposes. If you have questions about access to or contents of specific tables, contact Data Administration.

Tables are listed in alphabetical order. Select Table to obtain the explanation, 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.

CHANGED_PENN_ID
Table   Elements


 

 

 

User Access Administration

System owners may choose to make user-security related information available to school and center Access Administrators via the Warehouse, for their use in monitoring and maintenance activities. The following tables, available via the Business Objects User Access Reporting universe, are available only to Access Administrators or their designated backups (for a list of current Access Administrators, click here). Access Administrators should use the appropriate form to request access to this data.

COMP_APPLICATION_GROUP
Table   Elements

COMP_APPLICATION_USER
Table   Elements

COMP_APPLICATION_USER_GROUP
Table   Elements

DW_ROLES
Table   Elements

DW_ROLES_DESC
Table   Elements

USER_ACCESS_LIST
Table   Elements


 

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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