Scope - Passenger Flights

Overview

The Passenger Flights scope provides detailed, passenger-level data for every flight in your operation. Where the standard Flights scope focuses on the flight itself — routing, times, and aircraft — this scope adds a full manifest layer: who was on board, their travel documents, boarding status, special preferences, and transfer logistics. Each row in a report built on this scope represents one passenger on one flight, making it the primary source for passenger manifests, visa and document compliance checks, and ground-transfer coordination.

Operators use this scope whenever they need to answer questions at the individual-passenger level: which documents a specific traveller carried on a given leg, whether a passenger's travel document was valid for the departure or arrival country, who was on board across a date range, or how ground transfers were arranged. It is also the right scope for SIFL (Standard Industry Fare Level) calculations and passenger-preference tracking.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Passenger manifest by flight — a list of all passengers on each flight with their names, nationalities, and travel document details
Document expiry and compliance check — review travel document types, issue dates, and expiry dates used at departure and arrival for a selected period
Birthday on flight day — identify passengers whose birthday falls on the date of travel, useful for VIP service planning
SIFL calculation report — produce the data required for Standard Industry Fare Level tax computations, including employee status flags
Ground transfer and logistics summary — list pick-up times, transfer companies, and limousine suppliers for passengers at departure and arrival stations

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.

Passenger identification

Column	Column key	Description

Column	Column key	Description
PAX name	`pax_name`	First name of the passenger
PAX surname	`pax_surname`	Surname of the passenger
PAX Known As	`pax_known_as`	Preferred or informal name used for the passenger
PAX Nationality Code	`pax_nationality_code`	Two-letter nationality code of the passenger
PAX Date of birth	`pax_date_of_birth`	Passenger's date of birth
PAX Place of birth	`pax_place_of_birth`	City or location where the passenger was born
PAX Country of birth	`pax_country_of_birth`	Country where the passenger was born
PAX Birthday on flight day [UTC]	`pax_birthday_on_flight_day`	Indicates whether the passenger's birthday falls on the flight date (UTC)
Gender	`gender`	Gender of the passenger
PAX Contact ID	`pax_contact_id`	Internal identifier for the passenger's contact record

Flight identification and routing

Column	Column key	Description

Column	Column key	Description
Flight number	`flightNo`	Flight number as entered in the schedule
Date of flight [UTC]	`date_of_flight`	Date of the flight expressed in UTC
Date of flight [LT]	`date_of_flight_lt`	Date of the flight expressed in local time
ADEP ICAO	`adep_icao`	Departure airport ICAO code
ADES ICAO	`ades_icao`	Arrival airport ICAO code
ADEP IATA	`adep_iata`	Departure airport IATA code
ADES IATA	`ades_iata`	Arrival airport IATA code
ADEP city	`adep_city`	City of the departure airport
ADES city	`ades_city`	City of the arrival airport
ADEP name [Plan]	`adep_name_plan`	Full name of the departure airport as planned
ADES name [Plan]	`ades_name_plan`	Full name of the arrival airport as planned
ADEP country code [JL]	`adep_log_country_code`	Country code of the departure airport recorded in the Journey Log
ADES country code [JL]	`ades_log_country_code`	Country code of the arrival airport recorded in the Journey Log
ADEP country name [JL]	`adep_log_country_name`	Country name of the departure airport recorded in the Journey Log
ADES country name [JL]	`ades_log_country_name`	Country name of the arrival airport recorded in the Journey Log
ADEP country code [Plan]	`adep_plan_country_code`	Country code of the departure airport as planned
ADES country code [Plan]	`ades_plan_country_code`	Country code of the arrival airport as planned
ADEP country name [Plan]	`adep_plan_country_name`	Country name of the departure airport as planned
ADES country name [Plan]	`ades_plan_country_name`	Country name of the arrival airport as planned
Handler name [ADEP]	`handler_name_adep`	Name of the ground handling agent at the departure airport
Handler name [ADES]	`handler_name_ades`	Name of the ground handling agent at the arrival airport
Pax on flight	`pax_count`	Total number of passengers on the flight

Times

Column	Column key	Description

Column	Column key	Description
STD [UTC]	`start_time`	Scheduled Time of Departure (STD) expressed in UTC
STA [UTC]	`end_time`	Scheduled Time of Arrival (STA) expressed in UTC
STD [LT]	`start_time_lt`	Scheduled Time of Departure expressed in local time
STA [LT]	`end_time_lt`	Scheduled Time of Arrival expressed in local time
BLOFF [JL][UTC]	`start_time_log`	Block-off time recorded in the Journey Log, in UTC
BLOFF [JL][LT]	`start_time_log_lt`	Block-off time recorded in the Journey Log, in local time
BLON [JL][UTC]	`end_time_log`	Block-on time recorded in the Journey Log, in UTC
BLON [JL][LT]	`end_time_log_lt`	Block-on time recorded in the Journey Log, in local time
Block time [Plan]	`block_time_plan`	Planned block time for the flight (in minutes)
Block time [JL]	`block_time_journey_log`	Actual block time recorded in the Journey Log (in minutes)
Flight time [JL]	`flight_time`	Actual flight time recorded in the Journey Log (in minutes)
Estimated flight time [Plan]	`estimated_flight_time_plan`	Estimated flight time as planned (in minutes)

Aircraft

Column	Column key	Description

Column	Column key	Description
Aircraft	`aircraft_registration`	Registration of the aircraft operating the flight
MTOW	`acft_mtow`	Maximum Take-Off Weight of the aircraft
Distance [JL]	`flight_distance_jl`	Flight distance recorded in the Journey Log
Distance [Plan]	`flight_distance_plan`	Planned flight distance

Travel documents

Column	Column key	Description

Column	Column key	Description
Travel Document Number ADEP	`travel_document_number_adep`	Travel document number used at the departure airport
Travel Document Number ADES	`travel_document_number_ades`	Travel document number used at the arrival airport
Travel Document Country ADEP	`travel_document_country_adep`	Country code of the travel document used at departure
Travel Document Country ADES	`travel_document_country_ades`	Country code of the travel document used at arrival
Travel Document Country Name ADEP	`travel_document_country_name_adep`	Country name of the travel document used at departure
Travel Document Country Name ADES	`travel_document_country_name_ades`	Country name of the travel document used at arrival
Travel Document Nationality ADEP	`travel_document_nationality_adep`	Nationality stated on the travel document used at departure
Travel Document Nationality ADES	`travel_document_nationality_ades`	Nationality stated on the travel document used at arrival
Travel Document Date Of Issue ADEP	`travel_document_date_of_issue_adep`	Issue date of the travel document used at departure
Travel Document Date Of Issue ADES	`travel_document_date_of_issue_ades`	Issue date of the travel document used at arrival
Travel Document Expires ADEP	`travel_document_expires_adep`	Expiry date of the travel document used at departure
Travel Document Expires ADES	`travel_document_expires_ades`	Expiry date of the travel document used at arrival
Travel Document Type ADEP	`travel_document_type_adep`	Type of travel document (e.g. passport, visa) used at departure
Travel Document Type ADES	`travel_document_type_ades`	Type of travel document used at arrival

Trip and commercial data

Column	Column key	Description

Column	Column key	Description
Trip number	`trip_number`	Number of the trip this flight belongs to
Trip type	`trip_type`	Type or category of the trip
Tags	`flight_tags`	All tags applied to the flight and its trip
Flight Tags	`flight_tags_only`	Tags applied directly to the flight
Trip Tags	`trip_tags_only`	Tags applied to the trip
Client name	`client_name`	Name of the client associated with the trip
Client code	`client_code`	Short code identifying the client
Client Contact ID	`client_contact_nid`	Internal identifier for the client contact record
Host	`host`	Name of the host for this passenger on the flight
Host Contact ID	`host_contact_id`	Internal identifier for the host's contact record
PAX Company	`pax_company`	Company the passenger is associated with
Cost centre	`cost_centre`	Cost centre assigned to the passenger or flight
Project number	`project_number`	Project number associated with the passenger or flight

SIFL

Column	Column key	Description

Column	Column key	Description
Calculate SIFL	`calculate_sifl`	Indicates whether SIFL calculation applies to this passenger record
SIFL employee status	`sifl_employee_status`	Employee status used for the SIFL tax computation

Ground transfer and logistics

Column	Column key	Description

Column	Column key	Description
Pick-up time in resident address	`pickup_time_in_resident_address`	Scheduled pick-up time at the passenger's residence
Pick-up time in destination address	`pickup_time_in_destination_address`	Scheduled pick-up time at the destination address
Arrival transfer company	`arrival_transfer_company`	Transfer company arranged for the passenger upon arrival
Departure transfer company	`departure_transfer_company`	Transfer company arranged for the passenger at departure
Residence Address	`residence_address`	Passenger's home address used for transfer logistics
Destination Address	`destination_address`	Destination address used for transfer logistics
Limousine ADEP supplier [Chkl]	`ADEP_pax_transport_name`	Limousine or transport supplier at the departure airport, from the checklist
Limousine ADES supplier [Chkl]	`ADES_pax_transport_name`	Limousine or transport supplier at the arrival airport, from the checklist

Labels and preferences

Column

Column