Scope - Hotel Booking

Overview

The Hotel Booking scope covers hotel reservations made for crew members as part of trip and flight operations. Each record represents a booking at a specific hotel for one or more crew members, capturing check-in and check-out times, the associated airport, booking status, and cost information.

Operators use this scope to track where crew is accommodated during layovers and multi-leg trips, monitor booking confirmation status, identify missing bookings, and analyze accommodation costs. It is particularly useful for crew logistics coordinators and finance teams reviewing hotel expenditures across a time period.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Crew accommodation summary — list all hotel bookings for a given period with hotel name, check-in/out times, and crew assigned
Missing bookings report — identify flights or duties where a hotel booking has not yet been made for the crew
Cost analysis by airport — review hotel pricing and currency per destination to compare accommodation costs
Booking status overview — filter bookings by confirmation status to track pending vs. confirmed reservations
Crew PNR reference report — export booking numbers and PNR codes for crew members for travel coordination purposes

Available columns

Columns are the data fields that can appear in your report. When building a report, select the columns most relevant to your analysis.

Hotel and location

Column	Column key	Description

Column	Column key	Description
Hotel name	`hotel_name`	The name of the hotel where the booking was made
Airport	`airport_name`	The name of the airport associated with the hotel booking
Airport ICAO	`airport_icao`	The ICAO code of the airport associated with the booking
Airport IATA	`airport_iata`	The IATA code of the airport associated with the booking
Location	`hotel_booking_location`	The location or address of the hotel

Booking details

Column	Column key	Description

Column	Column key	Description
Status	`status`	The current status of the hotel booking (e.g. confirmed, pending, cancelled)
Booking number	`booking_number`	The hotel or agency booking reference number
Paid	`paid`	Indicates whether the booking has been paid
Price	`price`	The price of the hotel booking
Currency	`curr_id`	The currency in which the price is expressed
Note	`note`	Internal note associated with the hotel booking
Crew note	`crew_note`	Note visible to the crew member regarding the booking

Times — UTC

Column	Column key	Description

Column	Column key	Description
Start date time [UTC]	`start_time`	Check-in date and time expressed in UTC
End date time [UTC]	`end_time`	Check-out date and time expressed in UTC
Start date [UTC]	`start_date`	Check-in date only, expressed in UTC

Times — Local and Base

Column	Column key	Description

Column	Column key	Description
Start date time [LT]	`local_datetime_start`	Check-in date and time expressed in local time at the booking location
End date time [LT]	`local_datetime_end`	Check-out date and time expressed in local time at the booking location
Start date time [BT]	`base_datetime_start`	Check-in date and time expressed in the operator's base time
End date time [BT]	`base_datetime_end`	Check-out date and time expressed in the operator's base time

Crew

Column	Column key	Description

Column	Column key	Description
Crew codes	`crew_codes`	Short codes identifying the crew members included in the booking
Crew names	`crew_names`	Full names of the crew members included in the booking
Crew PNR	`crew_pnrs`	Passenger Name Record (PNR) codes assigned to crew members for this booking
Aircraft registration	`aircraft_registration`	The registration of the aircraft associated with the related flight or duty

Available filters

Filters let you narrow down the data to the specific subset you need — by date range, aircraft, status, and more.

Filter	Description

Filter	Description
Operator	Filter bookings by operator
Airport	Filter bookings by the associated airport
Status	Filter by booking status (e.g. confirmed, pending, cancelled)
User status	Filter by the status assigned at the user level
Date range type	Select the type of date range to apply (e.g. check-in date, check-out date)
Show missing bookings only	When enabled, shows only records where a hotel booking has not been made
Crew names	Filter bookings by specific crew members