Penn Computing

University of Pennsylvania
Penn Computing << go backback
TRANSPORTATION_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home

TRANSPORTATION_V Table /View

Explanation
Table/ View of travelers' transportation details.

Common Uses
Displaying the transportation details.

Primary Key Indexed Data Elements Related Tables
None
INDIVIDUAL_TRAVEL_LEG_ID
INDIVIDUAL_TRIP_V
GROUP_TRIP_V

Cautions
  • If the TRAVEL_MODE = ‘Air’
    • flight specific information will be populated (i.e. airline code, arrival airport),
    • otherwise it will be null.
  • Transportation information pertains to a trip, not a destination.
  • Transportation information exists only for “Confirmed” trip travelers.
  • Records where GROUP_TRIP _ID is not null refers to a “Confirmed” Group trip traveler.
TRANSPORTATION_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

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