Passenger service and reservations
The commercial record of a journey: what was booked, by whom, at what fare, and every change made afterwards.
01 What it holds
The data inside it
Bookings, passengers, itineraries, fares, ancillaries and the inventory availability that governed what could be sold.
PNR, Segment, Passenger, Fare, Ticket, Ancillary, Booking class, Change / Cancellation
02 Getting the data out
Extraction, and the keys that decide whether it joins
Vendor feeds and message-based interfaces. Volumes are very large and PNRs mutate constantly, so change history matters as much as final state.
A PNR is not a stable customer identity: the same traveller books direct, through an agency and as a corporate passenger under different records.
03 What goes wrong
The failures that look like success
Each of these produces a number that is plausible, reconciles to something, and is wrong. They are worth reading before the first extract, not after the first dispute.
PNRs change constantly
Final state loses the booking curve, which is where revenue management decisions actually live.
Passenger identity fragmented
Frequency and lifetime value are computed on fragments unless loyalty, direct and corporate identities are resolved.
Revenue is recognised at flight, not booking
Cash arrives at booking and revenue at departure, so commercial and finance views of the same sale legitimately differ.
Interline and codeshare attribution
Who earned the revenue on a multi-carrier journey is a settlement question that arrives much later.
04 Joins that matter
What this system is worth joining to
| Join to | What it lets you answer |
|---|---|
| Revenue management | realised fare mix against the forecast that released it |
| Flight operations | what was sold against what actually flew, including disruption |
| Loyalty | the passenger identity that ties bookings together over time |
05 Metrics it feeds
The numbers that come out of it
06 Questions
Frequently asked
Why keep the full booking history?
Because the booking curve is the product. Knowing what was sold at what price at what point before departure is the entire basis of revenue management improvement.
What breaks route profitability analysis?
Disruption cost absorbed centrally and never attributed to the route, and interline revenue settled late. Both are joins rather than calculations.
Connect this system without replacing it
SCIKIQ reads it in place, resolves the entities inside it and governs what the fields mean.