Refer to the below for a list of field names and their corresponding description in the Status Direct table.
For a 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 Type |
FLIGHT_TYPE |
VARCHAR(16777216) |
The definition type of the flight (Scheduled, Unscheduled, General Aviation) |
|
Status |
Flight State |
FLIGHT_STATE |
VARCHAR(16777216) |
Current state of the flight. A flight can be in the following states: |
|
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. |
|
Schedules |
Departure FAA Airport Code |
DEPARTURE_FAA_AIRPORT_CODE |
VARCHAR(16777216) |
The three-to-five-character alphanumeric code assigned by the FAA 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. |
|
Schedules |
Departure Country Code |
DEPARTURE_COUNTRY_CODE |
VARCHAR(16777216) |
The departure country code as per the country code assigned by the ISO (International Standards Organisation) used by IATA. |
|
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. |
|
Schedules |
Arrival IATA Airport Code |
ARRIVAL_IATA_AIRPORT_CODE |
VARCHAR(16777216) |
The three-letter code assigned by IATA to the arrival port. |
|
Schedules |
Arrival ICAO Airport Code |
ARRIVAL_ICAO_AIRPORT_CODE |
VARCHAR(16777216) |
The four-letter code assigned by ICAO to the arrival port. |
|
Schedules |
Arrival FAA Airport Code |
ARRIVAL_FAA_AIRPORT_CODE |
VARCHAR(16777216) |
The three-to-five-character alphanumeric code assigned by the FAA 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. |
|
Schedules |
Arrival Country Code |
ARRIVAL_COUNTRY_CODE |
VARCHAR(16777216) |
The arrival country code as per the country code assigned by the ISO (International Standards Organisation) used by IATA. |
|
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. |
|
Status |
General Aviation Flight Identifier |
GENERAL_AVIATION_FLIGHT_IDENTIFIER |
VARCHAR(16777216) |
The aircraft registration/tail number as supplied by the FAA. |
|
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. |
|
Status |
Diversion FAA Airport Code |
DIVERSION_FAA_AIRPORT_CODE |
VARCHAR(16777216) |
If a flight has been diverted this will show the three-to-five-character alphanumeric code, assigned by the FAA, of the actual arrival port. |
|
Status |
Diversion Country Code |
DIVERSION_COUNTRY_CODE |
VARCHAR(16777216) |
The arrival country code, of a diverted flight, as per the country code assigned by the ISO (International Standards Organisation) used by IATA. |
|
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. If FALSE, then this record relates to a non-operating flight |
|
Capacity |
Actual First Class Seats |
ACTUAL_FIRST_CLASS_SEATS |
NUMBER(38,0) |
Actual available First-Class seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Actual Business Class Seats |
ACTUAL_BUSINESS_CLASS_SEATS |
NUMBER(38,0) |
Actual available Business Class seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Actual Premium Economy Class Seats |
ACTUAL_PREMIUM_ECONOMY_CLASS_SEATS |
NUMBER(38,0) |
Actual available premium economy class seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Actual Economy Plus Class Seats |
ACTUAL_ECONOMY_PLUS_CLASS_SEATS |
NUMBER(38,0) |
Actual available economy plus class seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Actual Economy Class Seats |
ACTUAL_ECONOMY_CLASS_SEATS |
NUMBER(38,0) |
Actual available economy class seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Actual Total Seats |
ACTUAL_TOTAL_SEATS |
NUMBER(38,0) |
Actual available seats for the flight. When the aircraft tail number/registration is known, the known seating values of the aircraft are populated. |
|
Capacity |
Predicted First Class Seats |
PREDICTED_FIRST_CLASS_SEATS |
NUMBER(38,0) |
Predicted available First-Class seats for the flight. |
|
Capacity |
Predicted Business Class Seats |
PREDICTED_BUSINESS_CLASS_SEATS |
NUMBER(38,0) |
Predicted available Business Class seats for the flight. |
|
Capacity |
Predicted Premium Economy Class Seats |
PREDICTED_PREMIUM_ECONOMY_CLASS_SEATS |
NUMBER(38,0) |
Predicted available premium economy class seats for the flight. |
|
Capacity |
Predicted Economy Plus Class Seats |
PREDICTED_ECONOMY_PLUS_CLASS_SEATS |
NUMBER(38,0) |
Predicted available economy plus class seats for the flight. |
|
Capacity |
Predicted Economy Class Seats |
PREDICTED_ECONOMY_CLASS_SEATS |
NUMBER(38,0) |
Predicted available economy class seats for the flight. |
|
Capacity |
Predicted Total Seats |
PREDICTED_TOTAL_SEATS |
NUMBER(38,0) |
Predicted 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 in UTC. |