Status Direct: Data Fields Explained

Refer to the below for a list of field names and their corresponding description in the Status Direct table.

For better understanding of the status table, we have aggregated the data points into categories:

  • Status data has come from our live operational feeds.
  • Schedules data includes the essential information about a planned flight.
  • Capacity is information related to passengers and cargo that the equipment can carry.
  • Metadata is OAG-related information.

The order and categorisation of the data points may not be as shown in the tables in the product.

Source Data

Field Name

Name in Database

Type

Description

Status

Status Key

STATUS_KEY

VARCHAR(16777216)

A unique key for the status records relating to one flight instance

Schedules

IATA Carrier Code

IATA_CARRIER_CODE

VARCHAR(16777216)

A two-character code assigned by IATA.

Schedules

ICAO Carrier Code

ICAO_CARRIER_CODE

VARCHAR(16777216)

A three-character code assigned by ICAO.

Schedules

Flight Number

FLIGHT_NUMBER

NUMBER(38,0)

The numeric part (up to 4 digits) of the flight number of the operation.

Status

Flight State

FLIGHT_STATE

VARCHAR(16777216)

Current state of the flight. A flight can be in the following states:
- Scheduled
- OutGate
- InAir
- Landed
- InGate
- Canceled
- Diverted

Schedules

Departure IATA Airport Code

DEPARTURE_IATA_AIRPORT_CODE

VARCHAR(16777216)

The three-letter code assigned by IATA to the departure port.

Schedules

Departure ICAO Airport Code

DEPARTURE_ICAO_AIRPORT_CODE

VARCHAR(16777216)

The four-letter code assigned by ICAO to the departure port.

Status

Departure Terminal

DEPARTURE_TERMINAL

VARCHAR(16777216)

The departure terminal code.

Status

Departure Gate

DEPARTURE_GATE

VARCHAR(16777216)

The actual airport departure gate.

Status

Check In Counter

CHECK_IN_COUNTER

VARCHAR(16777216)

The departure checkin counter.

Schedules

Scheduled Departure Time Local

SCHEDULED_DEPARTURE_TIME_LOCAL

TIMESTAMP_NTZ(9)

The scheduled local passenger departure date/time.

Schedules

Scheduled Departure Date Local

SCHEDULED_DEPARTURE_DATE_LOCAL

DATE

The scheduled local passenger departure date.

Status

Departure Estimated Outgate Timeliness

DEPARTURE_ESTIMATED_OUTGATE_TIMELINESS

VARCHAR(16777216)

Shows one of three values; Early, OnTime or Delayed based on the estimated difference between the scheduled departure time and the estimated departure time

Status

Departure Estimated Outgate Variation

DEPARTURE_ESTIMATED_OUTGATE_VARIATION

VARCHAR(16777216)

The time variation between the scheduled departure time and the estimated departure time in d.HH:mm:ss format (d is an optional number of days).

Status

Departure Estimated Outgate UTC

DEPARTURE_ESTIMATED_OUTGATE_UTC

TIMESTAMP_NTZ(9)

The estimated UTC time that the aircraft will leave the gate.

Status

Departure Estimated Outgate Local

DEPARTURE_ESTIMATED_OUTGATE_LOCAL

TIMESTAMP_NTZ(9)

The estimated local time that the aircraft will leave the gate.

Status

Departure Estimated Offground UTC

DEPARTURE_ESTIMATED_OFFGROUND_UTC

TIMESTAMP_NTZ(9)

The estimated UTC time that the aircraft will take off.

Status

Departure Estimated Offground Local

DEPARTURE_ESTIMATED_OFFGROUND_LOCAL

TIMESTAMP_NTZ(9)

The estimated local time that the aircraft will take off.

Status

Departure Actual Outgate Timeliness

DEPARTURE_ACTUAL_OUTGATE_TIMELINESS

VARCHAR(16777216)

Shows one of three values; Early, OnTime or Delayed based on the difference between the scheduled departure time and the actual departure time

Status

Departure Actual Outgate Variation

DEPARTURE_ACTUAL_OUTGATE_VARIATION

VARCHAR(16777216)

The time variation between the scheduled departure time and the actual departure time in d.HH:mm:ss format (d is an optional number of days).

Status

Departure Actual Outgate UTC

DEPARTURE_ACTUAL_OUTGATE_UTC

TIMESTAMP_NTZ(9)

The actual UTC time that the aircraft will leave the gate.

Status

Departure Actual Outgate Local

DEPARTURE_ACTUAL_OUTGATE_LOCAL

TIMESTAMP_NTZ(9)

The actual local time that the aircraft will leave the gate.

Status

Departure Actual Offground UTC

DEPARTURE_ACTUAL_OFFGROUND_UTC

TIMESTAMP_NTZ(9)

The actual UTC time that the aircraft took off.

Status

Departure Actual Offground Local

DEPARTURE_ACTUAL_OFFGROUND_LOCAL

TIMESTAMP_NTZ(9)

The actual local time that the aircraft took off.

Schedule

Arrival IATA Airport Code

ARRIVAL_IATA_AIRPORT_CODE

VARCHAR(16777216)

The three-letter code assigned by IATA to the arrival port.

Schedule

Arrival ICAO Airport Code

ARRIVAL_ICAO_AIRPORT_CODE

VARCHAR(16777216)

The four-letter code assigned by ICAO to the arrival port.

Status

Arrival Terminal

ARRIVAL_TERMINAL

VARCHAR(16777216)

The arrival terminal code.

Status

Arrival Gate

ARRIVAL_GATE

VARCHAR(16777216)

The actual airport arrival gate.

Status

Baggage

BAGGAGE

VARCHAR(16777216)

The arrival baggage counter.

Schedules

Scheduled Arrival Time Local

SCHEDULED_ARRIVAL_TIME_LOCAL

TIMESTAMP_NTZ(9)

The scheduled local passenger arrival time.

Status

Arrival Estimated Ingate Timelines

ARRIVAL_ESTIMATED_INGATE_TIMELINESS

VARCHAR(16777216)

Shows one of three values; Early, OnTime, Delayed based on the estimated difference between the scheduled arrival time and the estimated arrival time

Status

Arrival Estimated Ingate Variation

ARRIVAL_ESTIMATED_INGATE_VARIATION

VARCHAR(16777216)

The time variation between the scheduled arrival time and the estimated arrival time in d.HH:mm:ss format (d is an optional number of days).

Status

Arrival Estimated Onground UTC

ARRIVAL_ESTIMATED_ONGROUND_UTC

TIMESTAMP_NTZ(9)

The estimated UTC time that the aircraft will arrive at the gate.

Status

Arrival Estimated Onground Local

ARRIVAL_ESTIMATED_ONGROUND_LOCAL

TIMESTAMP_NTZ(9)

The estimated local time that the aircraft will arrive at the gate.

Status

Arrival Estimated Ingate UTC

ARRIVAL_ESTIMATED_INGATE_UTC

TIMESTAMP_NTZ(9)

The estimated UTC time that the aircraft will land.

Status

Arrival Estimated Ingate Local

ARRIVAL_ESTIMATED_INGATE_LOCAL

TIMESTAMP_NTZ(9)

The estimated local time that the aircraft will land.

Status

Arrival Actual Ingate Timeliness

ARRIVAL_ACTUAL_INGATE_TIMELINESS

VARCHAR(16777216)

Shows one of three values; Early, OnTime, Delayed based on the difference between the scheduled arrival time and the actual arrival time

Status

Arrival Actual Ingate Variation

ARRIVAL_ACTUAL_INGATE_VARIATION

VARCHAR(16777216)

The time variation between the scheduled arrival time and the actual arrival time in d.HH:mm:ss format (d is an optional number of days).

Status

Arrival Actual Ingate UTC

ARRIVAL_ACTUAL_INGATE_UTC

TIMESTAMP_NTZ(9)

The actual UTC time that the aircraft arrived at the gate.

Status

Arrival Actual Ingate Local

ARRIVAL_ACTUAL_INGATE_LOCAL

TIMESTAMP_NTZ(9)

The actual local time that the aircraft arrived at the gate.

Status

Arrival Actual Onground UTC

ARRIVAL_ACTUAL_ONGROUND_UTC

TIMESTAMP_NTZ(9)

The actual UTC time that the aircraft landed.

Status

Arrival Actual Onground Local

ARRIVAL_ACTUAL_ONGROUND_LOCAL

TIMESTAMP_NTZ(9)

The actual local time that the aircraft landed.

Status

Aircraft Type IATA

AIRCRAFT_TYPE_IATA

VARCHAR(16777216)

The three-character code of the equipment type in use, as assigned by IATA.

Status

Aircraft Type ICAO

AIRCRAFT_TYPE_ICAO

VARCHAR(16777216)

The four-character code of the equipment type in use, as assigned by ICAO.

Status

Aircraft Registration Number

AIRCRAFT_REGISTRATION_NUMBER

VARCHAR(16777216)

The aircraft registration/tail number.

Schedules

Service Type

SERVICE_TYPE

VARCHAR(16777216)

The single character service type classification (IATA standard) of the flight.

Status

Diversion IATA Airport Code

DIVERSION_IATA_AIRPORT_CODE

VARCHAR(16777216)

If a flight has been diverted this will show the three-letter code, assigned by IATA, of the actual arrival port.

Status

Diversion ICAO Airport Code

DIVERSION_ICAO_AIRPORT_CODE

VARCHAR(16777216)

If a flight has been diverted this will show the four-letter code, assigned by ICAO, of the actual arrival port.

Schedules

Schedule Instance Key

SCHEDULE_INSTANCE_KEY

VARCHAR(16777216)

Schedule instance key that uniquely identifies operating and non-operating schedule instance records that status is related to.

Schedules

Operating Schedule Instance Key

OPERATING_SCHEDULE_INSTANCE_KEY

VARCHAR(16777216)

For non-operating flights this unique key refers to the schedule record of operating flight.

Empty (null) if status record is for operating flight.

Schedules

Is Operating Carrier

IS_OPERATING_CARRIER

BOOLEAN

If TRUE, then this record relates to an operating flight.

Capacity

Actual First Class Seats

ACTUAL_FIRST_CLASS_SEATS

NUMBER(38,0)

Actual Available First-Class seats for the flight.

Capacity

Actual Business Class Seats

ACTUAL_BUSINESS_CLASS_SEATS

NUMBER(38,0)

Actual Available Business Class seats for the flight.

Capacity

Actual Premium Economy Class Seats

ACTUAL_PREMIUM_ECONOMY_CLASS_SEATS

NUMBER(38,0)

Actual Available premium economy class seats for the flight.

Capacity

Actual Economy Plus Class Seats

ACTUAL_ECONOMY_PLUS_CLASS_SEATS

NUMBER(38,0)

Actual Available economy plus class seats for the flight.

Capacity

Actual Economy Class Seats

ACTUAL_ECONOMY_CLASS_SEATS

NUMBER(38,0)

Actual Available economy class seats for the flight.

Capacity

Actual Total Seats

ACTUAL_TOTAL_SEATS

NUMBER(38,0)

Actual Available seats for the flight.

Capacity

Predicted First Class Seats

PREDICTED_FIRST_CLASS_SEATS

NUMBER(38,0)

Actual Available First-Class seats for the flight.

Capacity

Predicted Business Class Seats

PREDICTED_BUSINESS_CLASS_SEATS

NUMBER(38,0)

Actual Available Business Class seats for the flight.

Capacity

Predicted Premium Economy Class Seats

PREDICTED_PREMIUM_ECONOMY_CLASS_SEATS

NUMBER(38,0)

Actual Available premium economy class seats for the flight.

Capacity

Predicted Economy Plus Class Seats

PREDICTED_ECONOMY_PLUS_CLASS_SEATS

NUMBER(38,0)

Actual Available economy plus class seats for the flight.

Capacity

Predicted Economy Class Seats

PREDICTED_ECONOMY_CLASS_SEATS

NUMBER(38,0)

Actual Available economy class seats for the flight.

Capacity

Predicted Total Seats

PREDICTED_TOTAL_SEATS

NUMBER(38,0)

Actual Available seats for the flight.

Metadata

Origin Message ID

ORIGIN_MESSAGE_ID

VARCHAR(16777216)

ID that relates to the status message received by OAG. Can be provided to OAG support if querying specific data.

Metadata

Origin Message Timestamp

ORIGIN_MESSAGE_TIMESTAMP

TIMESTAMP_NTZ(9)

Timestamp of status message.