MCT: Data Fields Explained

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

Field Name

Name in Database

Type

Description

Record Type

RECORD_TYPE

NUMBER (38,0)

  • Record Type 2 – MCT Data – All MCT data records are this record type.
  • Record Type 3 – Connection Building Filter – Used by carriers.
Arrival Airport Code IATA

ARRIVAL_AIRPORT_CODE_IATA

VARCHAR (16777216)

The arriving station where the connection will occur (e.g., ORD = O’Hare International Airport, Chicago).

Minimum Connecting Time

MINIMUM_CONNECTING_TIME

TIME

The minimum connecting time required to connect given the other parameters of the record.

International Domestic Status

INTERNATIONAL_DOMESTIC_STATUS

VARCHAR (16777216)

Identification of the international/domestic status on each flight leg to control the correct generation of flight connections between two flights.

  • DD = Domestic to Domestic

  • DI = Domestic to International

  • ID = International to Domestic

  • II = International to International

Departure Airport Code IATA

DEPARTURE_AIRPORT_CODE_IATA

VARCHAR (16777216)

The departing station where the connection will occur (e.g., LGW = London Gatwick Airport).

Arrival Carrier Code IATA

ARRIVAL_CARRIER_CODE_IATA

VARCHAR (16777216)

The 2-letter airline designator of the delivering carrier at a specified arrival station. This airline designator will also be used for the ticket and be displayed on the electronic flight/value coupons (e.g., AA = American Airlines).

Arrival Codeshare Indicator

ARRIVAL_CODESHARE_INDICATOR

BOOLEAN

An indicator to advise the MCT applies to codeshare flights where a DEI 050 is published.

Arrival Codeshare Operating Carrier Code IATA

ARRIVAL_CODESHARE_OPERATING_CARRIER_CODE_IATA

VARCHAR (16777216)

The 2 letter airline designator for the operating carrier at the arrival station.

Departure Carrier Code IATA

DEPARTURE_CARRIER_CODE_IATA

VARCHAR (16777216)

The 2-letter airline designator of the receiving carrier at a specified departure station. This airline designator will also be used for the ticket and be displayed on the electronic flight/value coupons (e.g., UA = United Airlines).

Departure Codeshare Indicator

DEPARTURE_CODESHARE_INDICATOR

BOOLEAN

An indicator to advise the MCT applies to codeshare flights where a DEI 050 is published.

Departure Codeshare Operating Carrier Code IATA

DEPARTURE_CODESHARE_OPERATING_CARRIER_CODE_IATA

VARCHAR (16777216)

The 2 letter airline designator for the operating carrier at the departure station.

Arrival Aircraft Type IATA

ARRIVAL_AIRCRAFT_TYPE_IATA

VARCHAR (16777216)

Identification of the aircraft type at the arrival station.

Arrival Aircraft Body Code

ARRIVAL_AIRCRAFT_BODY_CODE

VARCHAR (16777216)

Details if the arriving aircraft is (W)ide bodied or (N)arrow bodied.

Departure Aircraft Type IATA

DEPARTURE_AIRCRAFT_TYPE_IATA

VARCHAR (16777216)

Identification of the aircraft type at a departure station.

Departure Aircraft Body Code

DEPARTURE_AIRCRAFT_BODY_CODE

VARCHAR (16777216)

Details if the departing aircraft is (W)ide bodied or (N)arrow bodied.

Arrival Terminal

ARRIVAL_TERMINAL

VARCHAR (16777216)

The terminal code the passenger arrives in.

Departure Terminal

DEPARTURE_TERMINAL

VARCHAR (16777216)

The terminal of a code the passenger departs from.

Previous Country Code

PREVIOUS_COUNTRY_CODE

VARCHAR (16777216)

The 2-letter ISO code indicating the previous country of the arriving flight (e.g., GB = United Kingdom).

Previous Airport Code IATA

PREVIOUS_AIRPORT_CODE_IATA

VARCHAR (16777216)

The previous station of the arriving flight (e.g., EWR = Newark, New Jersey).

Next Country Code

NEXT_COUNTRY_CODE

VARCHAR (16777216)

The 2-letter ISO code indicating the next country of the departing flight (e.g., US = United States).

Next Airport Code IATA

NEXT_AIRPORT_CODE_IATA

VARCHAR (16777216)

The next station of the departing flight (e.g., EWR = Newark, New Jersey).

Arrival Flight Number Range Start

ARRIVAL_FLIGHT_NUMBER_RANGE_START

VARCHAR (16777216)

The starting number of flight number range for arriving flights.

Arrival Flight Number Range End

ARRIVAL_FLIGHT_NUMBER_RANGE_END

VARCHAR (16777216)

The ending number of flight number range for arriving flights.

Departure Flight Number Range Start

DEPARTURE_FLIGHT_NUMBER_RANGE_START

VARCHAR (16777216)

The starting number of flight number range for departing flights.

Departure Flight Number Range End

DEPARTURE_FLIGHT_NUMBER_RANGE_END

VARCHAR (16777216)

The ending number of flight number range for departing flights.

Previous State Code

PREVIOUS_STATE_CODE

VARCHAR (16777216)

The 2-letter code indicating the previous state of the arriving flight (e.g., NS for New South Wales in the Australia).

Next State Code

NEXT_STATE_CODE

VARCHAR (16777216)

The 2-letter code indicating the next state of the departing flight (e.g., LA for Louisiana in the US).

Previous Region Code IATA

PREVIOUS_REGION_CODE_IATA

VARCHAR (16777216)

Indicates the previous region of the arriving flight (e.g., EUR for Europe).

Next Region Code IATA

NEXT_REGION_CODE_IATA

VARCHAR (16777216)

Indicates the next region of the departing flight (e.g., SCH for Schengen).

Effective From Date Local

EFFECTIVE_FROM_DATE_LOCAL

DATE

Indicates the date when the MCT becomes effective.

Effective To Date Local

EFFECTIVE_TO_DATE_LOCAL

DATE

Indicates the date when the MCT is not effective anymore.

Suppression Indicator

SUPPRESSION_INDICATOR

BOOLEAN

Indicates whether connections should be suppressed or not.

Suppression Region Code IATA

SUPPRESSION_REGION_CODE_IATA

VARCHAR (16777216)

Indicates the region where the suppression will occur.

Suppression Country Code

SUPPRESSION_COUNTRY_CODE

VARCHAR (16777216)

The 2-letter ISO code indicating the country where the suppression will occur.

Suppression State Code

SUPPRESSION_STATE_CODE

VARCHAR (16777216)

The 2-letter code indicating the state where the suppression will apply.

Submitting Carrier Code IATA

SUBMITTING_CARRIER_CODE_IATA

VARCHAR (16777216)

The 2-character airline designator of the carrier that submitted the MCT.

Filing Date

FILING_DATE

DATE

Indicates the date OAG processed the MCT onto the database.

Partner Carrier Codes IATA

PARTNER_CARRIER_CODES_IATA

VARIANT

Defines the carrier (s) that are allowed to connect with the submitting carrier. Applies to record type 4 only.

Record Serial Number

RECORD_SERIAL_NUMBER

NUMBER (38,0)

Line number of the record indicating record hierarchy order.

Snapshot Date

SNAPSHOT_DATE

DATE

The date when the data was captured for the output as a snapshot.