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.

None

INDIVIDUAL_TRAVEL_LEG_ID

INDIVIDUAL_TRIP_V
GROUP_TRIP_V

• 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