Bookings

The “Bookings” cube contains information about the bookings and trip segments processed by X-Assist.

“Bookings” is a Type 2 SCD that allows change tracking over time by applying a filter to “Bookings – Valid on” or selecting it as a time dimension.

Measures

Count

The number of distinct bookings in the result set.

Segment count

The number of distinct segments in the result set.

Dimensions

Booking reference

The unique ID of the booking from the upstream system. Also known as “file key”, “PNR ID” or “record locator”.

The special value expat identifies expat registrations that were created directly in X-Assist. There can only be a single expat registration for each person at a given time.

When a booking is updated, there will be multiple versions of the booking that all have the same booking reference.

Delivered by

The human-readable name of the organization (TMC) that delivered the booking to X-Assist. This value is optional and will not be present for manual and calendar trip registrations.

Created at

The UTC timestamp at which the booking has been created in X-Assist.

Segment start date

The UTC timestamp at which the segment started.

Segment end date

The UTC timestamp at which the segment ended.

Booking type

The type of the booking.

Possible values:

• PNR (pnr): The booking was delivered to X-Assist by a TMC.
• 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.

Segment type

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.

Flight number

The numeric part of the flight number, without the airline code (“1234” instead of “LH1234”).

For codeshare flights, this will be the flight number of the operating carrier.

Some TMCs deliver poor quality data to X-Assist, which may result in the airline code still being part of the flight number.

Valid on

The UTC period during which the record was valid (i.e. the time from creation to deletion of the record).

Join compatibility

Bookings can be joined with:

• Airlines
• Airports
• Countries
• Organizations
• People