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

Global Activities Registry Collection Tables & Data Elements

Tables are listed in alphabetical order by type: Group Trips, Individual Trips, Travel Group/Program, and Lookup tables. 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.

Group Trips

GROUP_TRIP_DESTINATION_V
Table    Elements

GROUP_TRIP_HOSTPARTNER_INST_V
Table    Elements

GROUP_TRIP_LEADER_V
Table    Elements

GROUP_TRIP_TRAVELER_V
Table    Elements

GROUP_TRIP_V
Table    Elements

Individual Trips

INDIVIDUAL_TRIP_DESTINATION_V
Table    Elements

INDIVIDUAL_TRIP_V
Table    Elements

TRANSPORTATION_V
Table    Elements


Travel Group/Programs

GAR_GROUP_PROGRAM_ORGANIZATN_V
Table    Elements

GAR_GROUP_PROGRAM_SCHOOL_V
Table    Elements

GAR_GROUP_PROGRAM_V
Table    Elements

Lookup Tables

ACTIVITY_SUB_TYPE
Table    Elements

ACTIVITY_TO_990
Table    Elements

ACTIVITY_TYPE
Table    Elements

AIRLINE
Table    Elements

COUNTRY
Table    Elements

FOREIGN_VISA_TYPE
Table    Elements

IATA_CODE
Table    Elements

ORGANIZATION
Table    Elements

PERSON
Table    Elements

REGION
Table    Elements

SCHOOL
Table    Elements

TRAVEL_MODE
Table    Elements

UNIVERSITY (Host/Partner Institution)
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