Skip to content

Duty file specification

This document shows you a list of columns that the duty file (CSV and XLSX formats) can contain. The file can contain duties (one per row) for multiple schedules. You can see the mandatory columns together with the optional columns in the table below. See Where to get formats to learn how to download an example duty file.

ColumnName
(+ required)		 Format Description
Reference+ Text A free-text property usually used to indicate a pilot. Use pilot's name or ID.
OnDutyDate+ Date (DD/MM/YYYY) The duty start date.
OnDutyTime+ Time (hh:mm) The duty start time.
StartAirport+ Text The airport at which the duty started. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
OffDutyDate+ Date (DD/MM/YYYY) The duty end date.
OffDutyTime+ Time (hh:mm) The duty end time.
EndAirport+ Text The airport at which the duty ended. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
Sectors Number The number of flights in duty. Default value is 1.
CrewComposition Number Send
  • 2 for 2 Pilots
  • 3 for 3 Pilots
  • 4 for 4 Pilots
  • 9 for Cabin Crew
Default value is 2.
SleepCount Number (0-2) The number of sleeps the pilot or the crew member slept on duty.
SleepOrder Number (1-3) The rank, which the pilot or the crew member slept in. Send
  • 1 for First
  • 2 for Second
  • 3 for Third
SleepClass Number (1-5) Send
  • 1 for Class 1 - Bunk
  • 2 for Class 2 - Cabin seat: 40 degrees or more recline
  • 3 for Class 3 - Flight deck seat
  • 4 for Class 4 - Economy seat: Less than 40 degrees recline
  • 5 for Class 5 - Jump seat
HomeBase+ Text Send ICAO, IATA, or FAA airport codes or a combination of these codes. Default value is Start airport code.
TimeReference+ Number (0-2) The reference time zone. Send
  • 0 for UTC
  • 1 for Base airport timezone
  • 2 for Local timezone
OnPartialAugmentDate Date (DD/MM/YYYY) The time at which the pilot or the crew member started their partial augmentation.
OnPartialAugmentTime Time (hh:mm) The time at which the pilot or the crew member started their partial augmentation.
OffPartialAugmentDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their partial augmentation.
OffPartialAugmentTime Time (hh:mm) The time at which the pilot or the crew member ended their partial augmentation.
FirstRestStartDate Date (DD/MM/YYYY) The date on which the pilot or the crew member started their first rest.
FirstRestStartTime Time (hh:mm) The time at which the pilot or the crew member started their first rest.
FirstRestEndDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their first rest.
FirstRestEndTime Time (hh:mm) The time at which the pilot or the crew member ended their first rest.
SecondRestStartDate Date (DD/MM/YYYY) The date on which the pilot or the crew member started their second rest.
SecondRestStartTime Time (hh:mm) The time at which the pilot or the crew member started their second rest.
SecondRestEndDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their second rest.
SecondRestEndTime Time (hh:mm) The time at which the pilot or the crew member ended their second rest.
SplitShift Number (0-1) Indicates whether the pilot or crew member had rested in between flight. Send
  • 0 for True
  • 1 for False
DutyType Number (1-3) The type of duty. Send
  • 1 for worked duty
  • 2 for worked duty with split shift
  • 3 for standby duty
Fleet Text A free-text property used to indicate fleet message.
Rank Text A free-text property used to indicate a pilot's rank.
Workload Number When the sector count is 0, send
  • 0 for no activity, i.e. doing nothing but not sleeping
  • 10 for average workload on a typical single-sector duty. Equivalent to workload prior to being able to change workload
  • 20 for average workload on a typical four-sector duty
  • 30 for very high workloads
  • 40 for exceptionally high workloads only seen occasionally
  • 50 for extremely high workloads only rarely seen
When the sector count is more than 0, send
  • -50 for half the workload of standard flying this number of sectors
  • 0 for standard duty workloads flying this number of sectors. Equivalent to workload prior to being able to change workload
  • 100 for double the workload of standard flying this number of sectors
CrewPrepTime Number The time taken for crew to prepare. Value indicates minutes. Default value is 60 minutes.
DutyCommuteTime Number The time taken to commute to the duty. Value indicates minutes. Default value is 60 minutes.
CabinCrewSleepPattern Number (0-3) Send
  • 0 for Normal Long-Haul Pattern 1 or 2 sleep periods
  • 1 (ULR Pattern 1 or 2 sleep periods, short service)
  • 2 (ULR Pattern 1 sleep period, 50% cruise phase)
  • 3 (ULR Pattern Main Crew 1 or 2 sleep periods)

Default value is 0. See Cabin Crew Sleep Pattern to learn more.