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 |