Master Data: Location record layout and descriptions

Refer to the below for a list of field names and its corresponding description for the locations master data table.

Field Name

Name in Database

Type

Description

Terminal IATA ICAO FAA Location PK

LOCATION_KEY

VARCHAR (16777216)

Unique combination of the IATA, ICAO, FAA, FAA location type and Terminal codes

IATA Airport Code

IATA_AIRPORT_CODE

VARCHAR (16777216)

IATA (International Air Transport Association) a three-character code for the port or city code, e.g. LGW, STN or LON. 

Terminal Code

TERMINAL_CODE

VARCHAR (16777216)

Code for the airport terminal e.g. ‘B’

Terminal Name

TERMINAL_NAME

VARCHAR (16777216)

Name of the terminal e.g. ‘Terminal B’

ICAO Location Code

ICAO_LOCATION_CODE

VARCHAR (16777216)

4 letter ICAO Airport/City code. E.g. EBFS = florennes Air Base

FAA Location Code

FAA_LOCATION_CODE

VARCHAR (16777216)

4 Character FAA Airport/City code. E.g.35IL = Clarion Field Airport

IATA Location Type

IATA_LOCATION_TYPE

VARCHAR (16777216)

IATA location type e.g. Airport, Heliport

FAA Location Type

FAA_LOCATION_TYPE

VARCHAR (16777216)

FAA location type e.g. Airport, Heliport

OAG Location Type

OAG_LOCATION_TYPE

VARCHAR (16777216)

OAG recommendation for the location type e.g. Airport, Heliport

IATA Airport Name

IATA_AIRPORT_NAME

VARCHAR (16777216)

IATA name for the port. E.g. London Gatwick.

ICAO Airport Name

ICAO_AIRPORT_NAME

VARCHAR (16777216)

ICAO name for the port

FAA Airport Name

FAA_AIRPORT_NAME

VARCHAR (16777216)

FAA name for the port e.g. Clarion Field Airport

OAG Airport Name

OAG_AIRPORT_NAME

VARCHAR (16777216)

OAG recommended name for the port

City State

CITY_STATE

VARIANT

Multiple values exist for this field, meaning that more than one value exist for the field e.g. ICAO Airport name: Yancheng

"CITY_CODE": "YNZ",

"CITY_NAME": "YANCHENG",

"STATE_CODE": ""

FAA City Name

FAA_CITY_NAME

VARCHAR (16777216)

FAA city name. e.g. Newburyport

FAA State

FAA_STATE

VARCHAR (16777216)

2 letter FAA designator for the state e.g. Newburyport = MA

OAG City State

OAG_CITY_STATE

VARIANT

Multiple values exist for this field. OAG recommendation for city state

IATA Country Code

IATA_COUNTRY_CODE

VARCHAR (16777216)

Country codes as per the country codes assigned by the ISO (International Standards Organisation) used by IATA.

FAA Country Code

FAA_COUNTRY_CODE

VARCHAR (16777216)

Country codes as per the country codes assigned by the ISO

OAG Country Code

OAG_COUNTRY_CODE

VARCHAR (16777216)

OAG recommendation for country code

ICAO Country Name

ICAO_COUNTRY_NAME

VARCHAR (16777216)

ICAO country name

OAG Country Name

OAG_COUNTRY_NAME

VARCHAR (16777216)

OAG recommendation for country name

Time Zone Code

TIME_ZONE_CODE

VARCHAR (16777216)

Designator code for the time zone e.g. ‘01’

Time Zone Info

TIME_ZONE_INFO

VARIANT

Multiple values exist for this field. Some countries, e.g. USA, Canada and Russia are split up into various time zones. E.g. China

"DST_END_DATE": "",

"DST_END_TIME": "",

"DST_START_DATE": "",

"DST_START_TIME": "",

"DST_VARIATION": "",

"END_STATUS_MARKER": "",

"GMT_UTC_VARIATION": "+0800",

"SEQUENCE_NUMBER": "01",

"START_STATUS_MARKER": ""

Latitude

LATITUDE

VARCHAR (16777216)

Latitude shown in degrees, minutes and seconds.

ICAO Latitude

ICAO_LATITIUDE

VARCHAR (16777216)

ICAO Latitude shown in degrees, minutes and seconds.

OAG Latitude

OAG_LATITUDE

VARCHAR (16777216)

OAG Latitude shown in degrees, minutes and seconds.

Longitude

LONGITUDE

VARCHAR (16777216)

Longitude shown in degrees, minutes and seconds

ICAO Longitude

ICAO_LONGITUDE

VARCHAR (16777216)

ICAO Longitude shown in degrees, minutes and seconds

OAG Longitude

OAG_LONGITUDE

VARCHAR (16777216)

OAG Longitude shown in degrees, minutes and seconds