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

EXCHANGE_INFO Table

Explanation
Contains itinerary exchange info 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
EXCHANGEINFOID
ORIGINAL_TICKET_NUMBER


      

PNR
EXCHANGE_COUPON
EXCHANGE_TAX
      

• Although data may be available in the EXCHANGE_INFO table, this data is undocumented by World Travel. Please use at your own risk.

• The most recent record for a given EXCHANGE_INFO is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current exchange info detail information.

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

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