MCT: Data Fields Explained

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

VARCHAR (16777216)

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

MINIMUM_CONNECTING_TIME

TIME

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

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

VARCHAR (16777216)

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

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

BOOLEAN

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

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

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

BOOLEAN

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

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

VARCHAR (16777216)

Identification of the aircraft type at the arrival station.

ARRIVAL_AIRCRAFT_BODY_CODE

VARCHAR (16777216)

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

DEPARTURE_AIRCRAFT_TYPE_IATA

VARCHAR (16777216)

Identification of the aircraft type at a departure station.

DEPARTURE_AIRCRAFT_BODY_CODE

VARCHAR (16777216)

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

ARRIVAL_TERMINAL

VARCHAR (16777216)

The terminal code the passenger arrives in.

DEPARTURE_TERMINAL

VARCHAR (16777216)

The terminal of a code the passenger departs from.

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

VARCHAR (16777216)

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

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

VARCHAR (16777216)

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

ARRIVAL_FLIGHT_NUMBER_RANGE_START

VARCHAR (16777216)

The starting number of flight number range for arriving flights.

ARRIVAL_FLIGHT_NUMBER_RANGE_END

VARCHAR (16777216)

The ending number of flight number range for arriving flights.

DEPARTURE_FLIGHT_NUMBER_RANGE_START

VARCHAR (16777216)

The starting number of flight number range for departing flights.

DEPARTURE_FLIGHT_NUMBER_RANGE_END

VARCHAR (16777216)

The ending number of flight number range for departing flights.

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

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

VARCHAR (16777216)

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

NEXT_REGION_CODE_IATA

VARCHAR (16777216)

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

EFFECTIVE_FROM_DATE_LOCAL

DATE

Indicates the date when the MCT becomes effective.

EFFECTIVE_TO_DATE_LOCAL

DATE

Indicates the date when the MCT is not effective anymore.

SUPPRESSION_INDICATOR

BOOLEAN

Indicates whether connections should be suppressed or not.

SUPPRESSION_REGION_CODE_IATA

VARCHAR (16777216)

Indicates the region where the suppression will occur.

SUPPRESSION_COUNTRY_CODE

VARCHAR (16777216)

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

SUPPRESSION_STATE_CODE

VARCHAR (16777216)

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

SUBMITTING_CARRIER_CODE_IATA

VARCHAR (16777216)

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

FILING_DATE

DATE

Indicates the date OAG processed the MCT onto the database.

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

NUMBER (38,0)

Line number of the record indicating record hierarchy order.

SNAPSHOT_DATE

DATE

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