Scope - FTL Sector

Overview

The FTL Sector scope covers individual sectors (flight legs) from the crew Flight Time Limitation (FTL) perspective. Each record represents a single sector flown by one crew member — one leg between a departure and an arrival airport — together with the duty it belongs to. The scope captures crew identification, actual and planned sector times, the surrounding duty times, block and flight times, route, aircraft, and the operating AOC.

Where the FTL Duty scope works at the level of a whole duty period, the FTL Sector scope drills down to each individual leg within those duties. It is the right scope when you need per-sector detail rather than per-duty aggregates.

This scope is used for crew activity and flight-time analysis. Operators use it to break duties down into their constituent legs, compare planned vs. actual sector block times, and analyse crew working patterns in the crew member's own base time.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Crew block/flight hours report — block and flight time per sector and per crew member
Sector-by-sector activity report — every leg a crew member operated in a period
Planned vs. actual block time report — comparison of planned and actual sector duration
Route activity report — which routes each crew member flew, with which aircraft
Crew base-time report — sector and duty times expressed in the crew member's base time for fatigue analysis

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.

The following time-zone tags are used:

[UTC] — value expressed in UTC
[CREW BT] — value expressed in the crew member's base time

A sector is a single flight leg; a duty is the continuous working period that contains one or more sectors.

Identification

Column	Column key	Description
Scope row unique ID	`scope_row_unique_id`	Internal unique identifier of the report row (hidden by default)
Duty unique ID	`duty_unique_id`	Internal identifier of the duty this sector belongs to
Flight number	`flight_no`	Flight number of the sector
Activity type	`activity_type`	Type of activity for this sector (e.g. flight, positioning)
Position	`position`	Crew position held on this sector

Crew identification

Column	Column key	Description
Crew member	`crew_member`	Full name of the crew member who flew the sector
Crew code	`crew_code`	Short identifier code assigned to the crew member
Crew permission group	`crew_permission_group`	Permission group the crew member belongs to in Leon
Crew user base	`crew_user_base`	Base location assigned to the crew member's user account
Crew home base ICAO	`crew_home_base_icao`	Crew member's home base airport(s) in ICAO format
Crew home base IATA	`crew_home_base_iata`	Crew member's home base airport(s) in IATA format
Crew DOB	`crew_dob`	Date of birth of the crew member
Crew phone number	`crew_phone_number`	Phone number on record for the crew member
Crew email	`crew_email`	Email address on record for the crew member
Crew gender	`crew_gender`	Gender of the crew member (M / F / U)

Sector times — actual [UTC]

Column	Column key	Description
Sector start date [UTC]	`sector_start_date_utc`	Date the sector started, in UTC
Sector start time [UTC]	`sector_start_time_utc`	Time the sector started, in UTC
Sector end date [UTC]	`sector_end_date_utc`	Date the sector ended, in UTC
Sector end time [UTC]	`sector_end_time_utc`	Time the sector ended, in UTC

Sector times — planned [UTC]

Column	Column key	Description
Planned sector start date [UTC]	`planned_sector_start_date_utc`	Planned date the sector started, in UTC
Planned sector start time [UTC]	`planned_sector_start_time_utc`	Planned time the sector started, in UTC
Planned sector end date [UTC]	`planned_sector_end_date_utc`	Planned date the sector ended, in UTC
Planned sector end time [UTC]	`planned_sector_end_time_utc`	Planned time the sector ended, in UTC

Sector times — crew base time [CREW BT]

Column	Column key	Description
Sector start date [CREW BT]	`sector_start_date_crew_bt`	Date the sector started, in the crew member's base time
Sector start time [CREW BT]	`sector_start_time_crew_bt`	Time the sector started, in the crew member's base time
Sector end date [CREW BT]	`sector_end_date_crew_bt`	Date the sector ended, in the crew member's base time
Sector end time [CREW BT]	`sector_end_time_crew_bt`	Time the sector ended, in the crew member's base time

Duty times [UTC]

Column	Column key	Description
Duty start date [UTC]	`duty_start_date_utc`	Date the duty started, in UTC
Duty start time [UTC]	`duty_start_time_utc`	Time the duty started, in UTC
Duty end date [UTC]	`duty_end_date_utc`	Date the duty ended, in UTC
Duty end time [UTC]	`duty_end_time_utc`	Time the duty ended, in UTC

Duty times [CREW BT]

Column	Column key	Description
Duty start date [CREW BT]	`duty_start_date_crew_bt`	Date the duty started, in the crew member's base time
Duty start time [CREW BT]	`duty_start_time_crew_bt`	Time the duty started, in the crew member's base time
Duty end date [CREW BT]	`duty_end_date_crew_bt`	Date the duty ended, in the crew member's base time
Duty end time [CREW BT]	`duty_end_time_crew_bt`	Time the duty ended, in the crew member's base time

Flight & block times

Column	Column key	Description
Block time	`block_time`	Actual block time of the sector (off-block to on-block)
Flight time	`flight_time`	Actual flight time of the sector (airborne, take-off to landing)
Planned block time	`planned_block_time`	Planned block time of the sector

Route & aircraft

Column	Column key	Description
Aircraft registration	`aircraft_registration`	Registration of the aircraft operated on the sector
Departure ICAO	`departure_icao`	Departure airport in ICAO format
Departure IATA	`departure_iata`	Departure airport in IATA format
Arrival ICAO	`arrival_icao`	Arrival airport in ICAO format
Arrival IATA	`arrival_iata`	Arrival airport in IATA format

Operator

Column	Column key	Description
AOC	`aoc`	Air Operator Certificate (AOC) under which the sector was performed

Summary (totals)

In addition to the per-sector rows, the report provides summary totals across all sectors matching the filters:

Summary field	Key	Description
Block time	`block_time`	Sum of actual block time across all sectors
Flight time	`flight_time`	Sum of actual flight time across all sectors
Planned block time	`planned_block_time`	Sum of planned block time across all sectors

Available filters

Filters let you narrow down the data to the specific subset you need. Every report is bounded by a date range (with a configurable maximum span). All other filters below are optional and can be combined.

Filter	Filter key	Description
Operator	`operator`	Filter sectors by operator
Crew members	`crew_member_list`	Filter sectors for specific crew members
Crew ratings	`crew_rating_list`	Filter by the crew positions / ratings held