| Data element |
Definition |
ID
Indexed - yes
Format - Integer
May be null - no |
Unique identifier for IATA Code (transportation location) in the table.
|
|
IATA_CODE
Indexed - no
Format - varchar2(3)
May be null - yes |
3 character code from IATA for a transportation location.
ie. airports, bus stations, heliports, ports, metropolitan areas, etc. |
IATA_CODE_TYPE
Indexed - no
Format - varchar2(20)
May be null - yes |
IATA Code Type of the location.
ie) 'airport', 'busStation', 'heliport', 'metropolitanArea', 'offlinePoint', 'port', 'rail' |
IATA_CODE_DESCRIPTION
Indexed - no
Format - varchar2(200)
May be null - yes |
Description of the IATA Code (transportation location). |
| IATA_CITY
Indexed - no
Format - varchar2(200)
May be null - yes
|
City or name of the IATA Code (transportation location). |
| COUNTRY_ID
Indexed - no
Format - Integer
May be null - yes
|
Country Id for the IATA Code (transportation location). |
| DISABLED
Indexed - no
Format - varchar2(1)
May be null - yes
|
Is the IATA Code disabled? |
