Penn Computing

University of Pennsylvania
Penn Computing << go backback
AIR_SEGMENT Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home

AIR_SEGMENT Table

Explanation
Contains air travel itinerary details from the World Travel booking and reservations system.

Common Uses

  • Reporting on travel itinerary details as well as aggregated travel itinerary data.

Primary Key Indexed Data Elements Related Tables
PNR_ID
PNR_LASTUPDATED_DATE SEGMENT_NUMBER
ARRIVAL_AIRPORT_CODE
ARRIVAL_AIRPORT_COUNTRY_CODE
ARRIVAL_DATE_TIME
DEPARTURE_AIRPORT_CODE
DEPARTURE_AIRPORT_COUNTRY_CODE
DEPARTURE_DATE_TIME
PNR_ID
PNR_LASTUPDATED_DATE
SEGMENT_NUMBER
PNR
SEAT
      

Cautions
  • There may be multiple AIR_SEGMENT records for a given itinierary representing each "leg" of a flight.
  • The AIR_SEGMENT table contains the change history for each itinerary so there may be multiple AIR_SEGMENT records for a given PNR_ID and SEGMENT_NUMBER.
  • The most recent record for a given AIR_SEGMENT is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current detail information for that leg of the flight.
  • Users granted access to the World Travel data collection may see all AIR_SEGMENT records.

Source

From the World Travel reservation and booking system (aka Concur) administered by the Travel Office.

World Travel reservation and booking system (aka Concur) is used to book travel reimbured by the University.

AIR_SEGMENT Table - Data Element Index   Tables and Data Elements   World Travel 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