InsertUpdateSlotScheduleInfo

Term / TypeComments / Description
SlotCoordinatedAirportIATA / AirportIATA
The AirportIATA code for the Airport that the schedule is relative to. For slot coordinated airports schedule data is typically given as arrival and departure information (turnaround). Schedules in general are flight oriented.

ArrivalFlightId 

The FlightId of an arriving flight.
DepartureFlightId 
The FlightId of a departing flight.
ScheduleSeason
Defines the season this schedule applies to. Three character string where the first character defines the season and the tho next the year.
ScheduleStartDate / DateUTC
The first day of the Schedule.
ScheduleEndDate / DateUTC
The last day of the schedule. This is actually the last day for the arriving flight. A departing flight can be up to ScheduleOverMidnights days later.
ScheduleFlightDays
Also known as DOOP, days of operation. This is a pattern that defines the days of the week which has scheduled flights.
The string is always seven characters long. '0' indicates no flight on that day, the day number ('1'..'7') indicates a flight on that day. The first day of the week is always Monday.
"1234567" - flights on all days.
"1234500" - flights on Monday - Friday, no flights on Saturday and Sunday.
"1030500" - flights on Moday, Wednesday and Friday.
For flights staying at the SlotCoordinatedAirportIATA over midnight UTC time, see ScheduleOverMidnights, the pattern indicates the day of the arriving flight.
ScheduleFlightWeeks
Also known as WOOP, weeks of operation. Allowed values are:
OriginAirport / AirportIATAorICAO

Use the IATA code if it exists.

Either the AirportIATA code or the AirportICAO code for the airport where a multi leg flight originated. For single leg flights it will be the same as the departure airport.
See also: OriginAirportIATA, OriginAirportICAO 

PreviousAirport / AirportIATAorICAO 

Use the IATA code if it exists.

Either the AirportIATA code or the AirportICAO code for the previous airport of a multi leg flight. For single leg flights it will be the same as the origin airport.
See also: PreviousAirportIATA, PreviousAirportICAO

NextAirport / AirportIATAorICAO 

Use the IATA code if it exists.

Either the AirportIATA code or the AirportICAO code for the next airport of a multi leg flight. For single leg flights it will be the same as the final airport.
See also: NextAirportIATA, NextAirportICAO

FinalAirport / AirportIATAorICAO 

Use the IATA code if it exists.

Either the AirportIATA code or the AirportICAO code for the final airport of a multi leg flight. For single leg flights it will be the same as the arrival airport.
See also: FinalAirportIATA, FinalAirportICAO

SIBTotp / TimeUTC

The time (not including the date) that an aircraft is scheduled to arrive at its first parking position. Always TimeUTC. For a Schedule it is only meaningful to use only a time (and not date and time as is necessary for one flight).

SOBTotp / TimeUTC
The time (not including the date) that an aircraft is scheduled to depart from its first parking position. Always TimeUTC. For a Schedule it is only meaningful to use only a time (and not date and time as is necessary for one flight).
ScheduleOverMidnights / Count
Gives the number of midnights that pass between the arrival (SIBT) and the departure (SOBT) of an aircraft on an airport, during a turnaround. This value applies to all flights in ScheduleFlightDays.
The usual values are:
  • 0: Same day, SOBT is after SIBT and the date is the same.
  • 1: SOBT is next day
ArrivalFlightServiceTypeIATA / FlightServiceTypeIATA
The  FlightServiceTypeIATA for an arriving flight.
DepartureFlightServiceTypeIATA / FlightServiceTypeIATA 
The  FlightServiceTypeIATA for a departing flight.
AircraftIATAType
3 character code as designated by International Air Transport Association (IATA) to uniquely designate Aircraft Type. Local (non-IATA) codes can be added as required as long as they are unique for aircraft types within the defined context.
Reference Document: IATA codeset 7800.
AircraftICAOType
3-4 character code as designated by International Civil Aviation Organisation (ICAO) to uniquely designate Aircraft Type. Local (non-ICAO) codes can be added as required as long as they are unique for aircraft types within the defined context.
Reference Document: ICAO document 8643.
AircraftRegistration
An aircraft registration is a unique alphanumeric string that identifies an aircraft. In accordance with the Convention on International Civil Aviation all aircraft must be registered with a national aviation authority and they must carry proof of this registration in the form of a legal document called a Certificate of Registration at all times when in operation.

An aircraft can be re-registered in special cases, for instance if it's sold to an operator in another country.
AircraftSeatingCapacity / Count
Maximum number of passengers that can be seated in the aircraft with the current configuration.