Method and system for automatically keeping travel data consistent between passenger reservation records and corresponding electronic tickets

摘要

A method and a system are described that keep travel data consistent between adatabase of airline reservations storing passenger name records (PNR's)comprised of travel segments, and a database of electronic tickets (E-tickets)comprised of travel coupons, this latter database being independently controlledfrom a ticketing server. Whenever a travel segment is updated or added in one ofthe PNR's an electronic reconciliation service (ERS) receives imagesof updated PNR's. Corresponding E-ticket images are requested by ERS andreceived from the database of E-tickets. Then, ERS establishes a matrix of linksbetween orphan PNR travel segments and orphan E-ticket travel coupons so thatE-ticket orphan travel coupons are re-associated with matching PNR orphan travelsegments. After E-ticket is updated it is revalidated or reissued. Optionally,if applicable, a penalty generator is requested to calculate penalty fees onthe basis of changes brought to the revalidated or reissued E-tickets. The penaltyfees are then attached to the updated PNR's.