Master Data: Carrier record layout and descriptions

Refer to the table below for a list of data fields and their descriptions in the carrier master data table.

Field Name

Name in Database

Type

Description

IATA Carrier Code

IATA_CARRIER_CODE

VARCHAR (16777216)

IATA (International Air Transport Association) a two-character code of the carrier 

ICAO Carrier Code

ICAO_CARRIER_CODE

VARCHAR (16777216)

ICAO (International Civil Aviation Organization) a three-character code of the carrier. 

Carrier Code

CARRIER_CODE

VARCHAR (16777216)

This field contains a carrier designator code assigned by either: 

– IATA (International Air Transport Association)

– ICAO (International Civil Aviation Organization)

– OAG (Controlled duplicate designators)

OAG Carrier Code

OAG_CARRIER_CODE

VARCHAR (16777216)

Represent OAG’s best recommendation and can be either an IATA or ICAO code

OAG Carrier Code Rank

OAG_CARRIER_CODE_RANK

NUMBER (38,0)

A number indicating the rank OAG’s recommendation for the carrier code

IATA Code Assignment Category

IATA_CODE_ASSIGNMENT_CATEGORY

VARCHAR (16777216)

IATA Code Assignment Category

IATA Code Assignment Description

IATA_CODE_ASSIGNMENT_DESCRIPTION

VARCHAR (16777216)

Description of the IATA assignment code

OAG Outbound Code

OAG_OUTBOUND_CODE

VARCHAR (16777216)

An in-house OAG carrier code used in place the an IATA code, or an ICAO code.

Carrier Alliance

CARRIER_ALLIANCE

VARCHAR (16777216)

Alliance membership of the airline.

IATA Carrier Name 1

IATA_CARRIER_NAME_1

VARCHAR (16777216)

IATA First carrier name for the airline e.g. Lulutai Airlines Limited

IATA Carrier Name 2

IATA_CARRIER_NAME_2

VARCHAR (16777216)

IATA Second carrier name for Joint Venture and Leased Operations e.g. dba Lulutai Airlines  

Carrier Name

CARRIER_NAME

VARCHAR (16777216)

carrier name e.g. Lulutai Airlines Limited

ICAO Carrier Name

ICAO_CARRIER_NAME

VARCHAR (16777216)

ICAO Carrier name

OAG Carrier Name

OAG_CARRIER_NAME

VARCHAR (16777216)

OAG’s best recommendation for carrier name

ICAO Telephony Name

ICAO_TELEPHONY_NAME

VARCHAR (16777216)

ICAO Telephony Name

IATA Accounting Prefix

IATA_ACCOUNTING_PREFIX

VARCHAR (16777216)

IATA Accounting Prefix

Duplicate Carrier Code Flag

DUPLICATE_CARRIER_CODE_FLAG

BOOLEAN

Indicates whether the carrier code is has a duplicate. Can either be true or false

IATA Airline Domicile City

IATA_AIRLINE_DOMICILE_CITY

VARCHAR (16777216)

The IATA domicile city of the carrier

IATA Airline Domicile State

IATA_AIRLINE_DOMICILE_STATE

VARCHAR (16777216)

The IATA domicile state of the carrier

IATA Airline Domicile Country

IATA_AIRLINE_DOMICILE_COUNTRY

VARCHAR (16777216)

The IATA domicile country of the carrier

Airline Domicile State

AIRLINE_DOMICILE_STATE

VARCHAR (16777216)

The airline domicile state of the carrier

Airline Domicile Country

AIRLINE_DOMICILE_COUNTRY

VARCHAR (16777216)

The airline domicile country of the carrier

ICAO Airline Domicile Country

ICAO_AIRLINE_DOMICILE_COUNTRY

VARCHAR (16777216)

The ICAO domicile country of the carrier

ICAO Airline Domicile Country Code

ICAO_AIRLINE_DOMICILE_COUNTRY_CODE

VARCHAR (16777216)

The ICAO 3-character code for the domicile country of the carrier

OAG Airline Domicile Country

OAG_AIRLINE_DOMICILE_COUNTRY

VARCHAR (16777216)

OAG’s best recommendation for the domicile country of the carrier

Domicile Region

DOMICILE_REGION

VARCHAR (16777216)

The domicile region of the carrier e.g. North America

OAG Code Assignment Category

OAG_CODE_ASSIGNMENT_CATEGORY

VARCHAR (16777216)

The OAG recommendation for code assignment category

Domicile Country Dot Code

DOMICILE_COUNTRY_DOT_CODE

VARCHAR (16777216)

The 3-figure US DOT code for the carrier domicile country

Carrier PK

CARRIER_KEY

VARCHAR (16777216)

Unique combination of the IATA, ICAO, OAG carrier codes and Carrier Alliance