Generating consolidated travel records from distinct formats
A method and system for consolidating travel records from on the one hand a source derived from a Global Distribution System or more generally a first travel database, and on the other hand a source derived from non-Global Distribution System information or more generally a second travel database. It is determined whether unique identifiers associated with the two sources match, indicating that information from the source travel records can be consolidated without compromising data integrity.
1. A system for consolidating electronic travel records of a journey upon determining that a schema in which privately arranged, non-commercial reservations are stored has passed a validation check, the system comprising:
a record consolidation server configured to:
accept an inbound feed with privately arranged, non-commercial reservations information, the inbound feed having an inbound schema;
validate the inbound schema with which the privately arranged reservations information is associated, to ensure the system can process the inbound schema;
enter a reject process to determine if records from distinct formats can be consolidated, the reject process comprising:
determine that the inbound schema passes and there are no unmarshalling errors;
determine that an XML record contains a system identifier and record locator;
fetch a Passenger Name Record from a Global Distribution System;
verify a trip request identifier in the Passenger Name Record;
determine that the trip request identifier matches the inbound schema;
store, in a first travel record structured to be associated with the Passenger Name Record from the Global Distribution System, wherein the first travel record contains a travel reservation from a commercial flight:
a first itinerary identifier that uniquely identifies a set of travel information for a trip derived from publicly available commercial travel options, and
a second itinerary identifier that uniquely identifies a set of travel information for a trip derived from privately arranged, non-commercial travel options;
store, in a second travel record structured to be associated with a trip request identifier from the privately arranged, non-commercial travel reservations:
a third itinerary identifier that uniquely identifies a set of travel information for a trip derived from publicly available travel options, and
a fourth itinerary identifier that uniquely identifies a set of travel information for a trip derived from privately arranged, non-commercial travel options;
consolidate the first travel record and the second travel record into a consolidated travel record; and
deliver a message to a user comprising the consolidated travel record.
2. The system of claim 1 , wherein the set of travel information based on the privately arranged, non-commercial reservations information is associated with a charter flight, a charter bus, a helicopter, a rail trip segment, a water trip segment, or campsite accommodations.