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

CRUISE_FERRY_SEGMENT Table

Explanation
Contains cruise/ferry 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.
  
  

PNR_ID
PNR_LAST_UPDATED_DATE
SEGMENT_NUMBER

      

ARRIVAL_DATE_TIME
ARRIVAL_PORT
ARRIVAL_PORT_COUNTRY_CODE
DEPARTURE_DATE_TIME
DEPARTURE_PORT
DEPARTURE_PORT_COUNTRY_CODE
PNR_ID
PNR_LAST_UPDATED_DATE
SEGMENT_NUMBER

      

PNR

• There may be multiple CRUISE_FERRY_SEGMENT records for a given itinierary.

• The CRUISE_FERRY_SEGMENT table contains the change history for each itinerary so there may be multiple CRUISE_FERRY_SEGMENT records for a given PNR_ID and SEGMENT_NUMBER.

• The most recent record for a given CRUISE_FERRY_SEGMENT is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current cruise/ferry detail information.

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

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