Bookings
Last updated
Last updated
The “Bookings” cube contains information about the bookings and trip segments processed by X-Assist.
“Bookings” is a that allows change tracking over time by applying a filter to “Bookings – Valid on” or selecting it as a time dimension.
The number of distinct bookings in the result set.
The number of distinct segments in the result set.
The unique ID of the booking from the upstream system. Also known as “file key”, “PNR ID” or “record locator”.
The UTC timestamp at which the booking has been created in X-Assist.
The UTC timestamp at which the segment started.
The UTC timestamp at which the segment ended.
The type of the booking.
Possible values:
Manual Trip Registration (manual_trip_registration
): The booking was created through the manual trip registration in X-Assist.
Calendar Trip Registration (calendar_trip_registration
): The booking was created through the calendar trip registration in X-Assist.
Expat Registration (expat_registration
): The booking was created through the expat management feature in X-Assist.
The type of the booking segment.
Possible values:
Air (air
): Flight booking
Calendar (calendar
): Calendar trip registration
Expat (expat
): Expat registration
Hotel (hotel
): Hotel booking
Accommodation (accommodation
): Accommodation from the manual trip registration
Rail (rail
): Train ride
Stop (stop
): Deprecated, scheduled for removal in December 2022.
The numeric part of the flight number, without the airline code (“1234” instead of “LH1234”).
The UTC period during which the record was valid (i.e. the time from creation to deletion of the record).
Bookings can be joined with:
The human-readable name of the organization () that delivered the booking to X-Assist. This value is optional and will not be present for manual and calendar trip registrations.
PNR (pnr
): The booking was delivered to X-Assist by a .
For , this will be the flight number of the operating carrier.
Some deliver poor quality data to X-Assist, which may result in the airline code still being part of the flight number.