INSURANCE_SEGMENT Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home

INSURANCE_SEGMENT Table

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

Common Uses

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

PNR_ID
PNR_LAST_UPDATED_DATE
SEGMENT_NUMBER

      

DATE_INSURANCE_BEGINS
DATE_INSURANCE_ENDS
DEPARTURE_CITY
DEPARTURE_COUNTRY
DEPARTURE_COUNTRY_CODE
DESTINATION_CITY
DESTINATION_COUNTRY
DESTINATION_COUNTRY_CODE
PNR_ID
PNR_LAST_UPDATED_DATE
SEGMENT_NUMBER

      

PNR
      

• Although data may be available in the INSURANCE_SEGMENT table, this data is undocumented by World Travel.

• The most recent record for a given INSURANCE_SEGMENT is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current insurance detail information.

• Users granted access to the World Travel data collection may see all INSURANCE_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.

INSURANCE_SEGMENT Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home