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

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