Scope - Crew Roster

Scope - Crew Roster

Overview

The Crew Roster scope covers crew roster entries — planned and confirmed crew assignments to flights, duties, and standby periods. Each record represents a single duty assignment for one crew member, including the duty name and type, timing across multiple time zones, associated airport, aircraft, and a range of crew-specific attributes.

Operators use this scope to analyze scheduling efficiency, crew utilization, and roster composition. It is particularly useful for reviewing duty coverage across a time period, monitoring standby and request patterns, and producing reports for crew management or regulatory purposes.


What reports can you build with this scope?

Examples of typical reports operators build with this scope:

  • Monthly duty summary by crew member — list all duties per crew member within a given month, including start/end times and duration

  • Standby and on-call coverage report — filter by duty type to review standby patterns across the roster

  • FTL-relevant duties report — filter by duties included in FTL calculations to support fatigue risk management compliance

  • Crew label or group utilization — analyze duty distribution across specific crew groups or labels

  • Duty request status report — review pending, approved, or rejected duty requests across the team


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.

Duty identification

Column

Column key

Description

Column

Column key

Description

Name

duty_name

The name of the duty as defined in the roster

Unique ID

unique_id

A system-generated unique identifier for the roster entry

Legend

legend

The legend label associated with the duty type

Duty type

duty_type

The category or type of duty (e.g. flight duty, standby, day off)

Duty color definition

duty_color_definition

The color coding assigned to this duty type in the roster view

Highest position type

highest_position_type

The highest crew position type associated with this duty

Times — UTC

Column

Column key

Description

Column

Column key

Description

Start date [UTC]

start_date_utc

The start date of the duty expressed in UTC

Start time [UTC]

start_time_utc

The start time of the duty expressed in UTC

End time [UTC]

end_time_utc

The end time of the duty expressed in UTC

End date [UTC]

end_date_utc

The end date of the duty expressed in UTC

Clock in time [UTC]

in_time

The time the crew member clocked in, expressed in UTC

Clock out time [UTC]

out_time

The time the crew member clocked out, expressed in UTC

Times — Local Time

Column

Column key

Description

Column

Column key

Description

Start date [LT]

start_date_lt

The start date of the duty expressed in local time

Start time [LT]

start_time_lt

The start time of the duty expressed in local time

End time [LT]

end_time_lt

The end time of the duty expressed in local time

End date [LT]

end_date_lt

The end date of the duty expressed in local time

Times — Base Time

Column

Column key

Description

Column

Column key

Description

Start date [BT]

start_date_bt

The start date of the duty expressed in base time

Start time [BT]

start_time_bt

The start time of the duty expressed in base time

End time [BT]

end_time_bt

The end time of the duty expressed in base time

End date [BT]

end_date_bt

The end date of the duty expressed in base time

Duty details

Column

Column key

Description

Column

Column key

Description

Duty duration

duration

The total duration of the duty

Included in FTL

included_in_ftl_calculations

Indicates whether this duty is counted in FTL (Flight Time Limitations) calculations

Times to be confirmed

tbc

Indicates whether the duty times are still to be confirmed

Positioning required

positioning_required

Indicates whether positioning travel is required for this duty

Note

duty_note

General note attached to the duty

Pilot note

duty_pilot_note

Note visible to the pilot assigned to the duty

Planner note

duty_planner_note

Note added by the planner for this duty

Day Trading Note

duty_account_note

Accounting or day trading note associated with the duty

Duty account

duty_account

The account or cost center associated with the duty

Duty Tags

tags

Tags applied to the duty for classification or filtering

Renewal endorsement

revalidated_endorsement_list

Endorsements that are being renewed in connection with this duty

Duty requests

Column

Column key

Description

Column

Column key

Description

Request

request

Indicates whether this duty entry originated from a crew request

Duty request status

duty_request_status

The current status of the duty request (e.g. pending, approved, rejected)

Duty request approved

duty_request_approved

Indicates whether the duty request has been approved

Crew information

Column

Column key

Description

Column

Column key

Description

Crew member

crew_member

The name of the crew member assigned to this duty

Crew code

crew_code

The short code identifying the crew member

Crew notes

crew_notes

Notes associated with the crew member's profile

Crew ID card

crew_id_card

The ID card number or reference for the crew member

Crew permission group

crew_permission_group

The permission group the crew member belongs to in Leon

Crew user base

crew_user_base

The base location assigned to the crew member

Crew home base ICAO

crew_home_base_icao

The crew member's home base airport in ICAO format

Crew home base IATA

crew_home_base_iata

The crew member's home base airport in IATA format

Crew Labels

labels

Labels assigned to the crew member for grouping or categorization

Freelancer

is_freelancer

Indicates whether the crew member is a freelancer

Clock in/out location

Column

Column key

Description

Column

Column key

Description

Clock in localization

in_localization

The geographic location where the crew member clocked in

Clock out localization

out_localization

The geographic location where the crew member clocked out

Airport and aircraft

Column

Column key

Description

Column

Column key

Description

Airport ICAO

airport_icao

The ICAO code of the airport associated with the duty

Airport IATA

airport_iata

The IATA code of the airport associated with the duty

Airport city

airport_city

The city of the airport associated with the duty

Aircraft

aircraft_registration

The aircraft registration associated with this duty

Aircraft Type [ICAO]

aircraft_type_icao

The ICAO type designator of the aircraft associated with this 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 by operator (relevant for multi-operator setups)

Aircraft

Limit results to duties associated with a specific aircraft

Day of week [UTC]

Filter duties by day of the week, expressed in UTC

Duty name

Filter by the name of the duty

Duty type

Filter by duty type (e.g. flight duty, standby, training)

Included in FTL calculations

Include only duties that count towards FTL calculations

Crew member

Filter by a specific crew member

Crew label

Filter by crew label to target specific groups or categories

Airport

Filter by the airport associated with the duty

Freelancers

Include or exclude freelance crew members

Show pending duty requests

Include duties that are pending crew request approval

Show only duty requests

Show only duties that originated from crew requests

Duty tag

Filter by duty tag

Times to be confirmed

Filter for duties where times have not yet been confirmed

User status

Filter by the crew member's account status in Leon

Positioning required

Filter for duties that require positioning travel

Duty request status

Filter by the current status of duty requests

Show rejected duty requests

Include duties whose requests were rejected

Duty request approved

Filter for duties where the request has been approved