Penn Computing

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

MISC_SEGMENT Table

Explanation
Contains micsellaneous 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_LAST_UPDATED_DATE
SEGMENT_NUMBER
ARRIVAL_CITY_CODE
ARRIVAL_COUNTRY_CODE
CHECK_IN_DATE
DEPARTURE_CITY_CODE
DEPARTURE_COUNTRY_CODE
DEPARTURE_DATE
PNR_ID
PNR_LAST_UPDATED_DATE
SEGMENT_NUMBER
PNR
      

Cautions
  • Although data may be available in the MISC_SEGMENT table, this data is undocumented by World Travel. Please use at your own risk.
  • The most recent record for a given MISC_SEGMENT is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current miscellaneous detail information.
  • Users granted access to the World Travel data collection may see all MISC_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.

MISC_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