Refer to the below for a list of field names and their corresponding description in the Connections table.
Field Name |
Name in Database |
Type |
Description |
Connection ID |
CONNECTION_ID |
NUMBER(38,0) |
A unique connection/flight identifier can be used to identify the records from one connection. |
Departure City Code |
DEPARTURE_CITY_CODE |
VARCHAR (16777216)
|
The departure city code as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Departure Port Code |
DEPARTURE_AIRPORT_IATA |
VARCHAR (16777216) |
The departure port code as designated by IATA. |
Arrival City Code |
ARRIVAL_CITY_CODE |
VARCHAR (16777216)
|
The arrival city code as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Arrival Port Code |
ARRIVAL_AIRPORT_IATA |
VARCHAR (16777216) |
The arrival port code as designated by IATA. |
Effective From Date |
EFFECTIVE_PERIOD_START_DATE |
Date |
The local effective from date shown as “CCYYMMDD”. |
Effective To Date |
EFFECTIVE_PERIOD_END_DATE |
Date
|
The local effective to date shown as “CCYYMMDD.” If a schedule is effective beyond that of the period chosen the date will appear as 20380101 |
Operating Days of Week |
DAYS_OF_OPERATION |
VARCHAR (16777216) |
The local operating departure days of the week. 1 = Monday, 2 = Tuesday etc. |
Arrival Day Marker |
ARRIVAL_INTERVAL_DAYS |
NUMBER(38,0)
|
The arrival day marker shows if the connection arrives on a different day to when it departed e.g. ‘-1’ = previous day,’0’ = same day,‘1’ = next day, ‘2’ = 2 days later etc. |
Connection Elapsed Time |
ELAPSED_TIME |
NUMBER(38,0) |
The elapsed journey time of the connection in minutes. |
QSI |
QSI |
VARCHAR (16777216) |
The QSI value calculated for the connection. This will be the same on all legs related to the connection |
Frequency |
FREQUENCY |
NUMBER(38,0) |
Frequency for the connection. |
Circuity |
CIRCUITY |
NUMBER(38,0)
|
The circuity for the connection, where a value of 100 equals a direct GCD between the origin and destination. |
Self/Forced Connection |
IS_SELF_CONNECTION |
NUMBER(38,0)
|
Indicates if connection restrictions were ignored and the record is a forced connection which requires self-connecting by passengers. |
Connection Type |
CONNECTION_TYPE |
VARCHAR (16777216) |
Indicates if the connection is Online (O), Offline (N), or Interline (I). |
Leg 1 Departure City Code |
LEG_1_DEPARTURE_CITY_CODE |
VARCHAR (16777216)
|
The departure city code of the leg as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Leg 1 Departure Port Code |
LEG_1_DEPARTURE_AIRPORT_IATA |
VARCHAR (16777216) |
The departure port code of the leg as designated by IATA. |
Leg 1 Arrival City Code |
LEG_1_ARRIVAL_CITY_CODE |
VARCHAR (16777216)
|
The arrival city code of the leg as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Leg 1 Arrival Port Code |
LEG_1_ARRIVAL_AIRPORT_IATA |
VARCHAR (16777216) |
The arrival port code of the leg as designated by IATA. |
Leg 1 Carrier Code |
LEG_1_CARRIER_CODE_IATA |
VARCHAR (16777216)
|
The airline designator code of the leg assigned by either: · IATA · ICAO · OAG (IATA Controlled duplicate designators with 7 prefix) |
Leg 1 Flight Number |
LEG_1_FLIGHT_NUMBER |
NUMBER(38,0) |
The four digit flight number of the leg |
Leg 1 Effective From Date |
LEG_1_EFFECTIVE_PERIOD_START_DATE |
Date |
The local effective from date of the leg shown as “CCYYMMDD”. |
Leg 1 Effective To Date |
LEG_1_EFFECTIVE_PERIOD_END_DATE |
Date
|
The local effective to date of the leg shown as “CCYYMMDD.” If a schedule is effective beyond that of the period chosen the date will appear as 20380101 |
Leg 1 Operating Days of Week |
LEG_1_DAYS_OF_OPERATION |
VARCHAR (16777216) |
The local operating departure days of the week of the leg. 1 = Monday, 2 = Tuesday etc. |
Leg 1 Departure Time |
LEG_1_DEPARTURE_LOCAL_TIME |
VARCHAR (16777216) |
The local departure time of the leg. The time is in 24 hour format expressed as hh:mm:ss. |
Leg 1 Arrival Time |
LEG_1_ARRIVAL_LOCAL_TIME |
VARCHAR (16777216) |
The local arrival time of the leg. The time is in 24 hour format expressed as hh:mm:ss |
Leg 1 Arrival Day Marker |
LLEG_1_ARRIVAL_INTERVAL_DAYS |
NUMBER(38,0) |
The arrival day marker shows if the leg arrives on a different day to when it departed e.g. ‘-1’ = previous day,’0’ = same day,‘1’ = next day, ‘2’ = 2 days later etc. |
Leg 1 Elapsed Time |
LEG_1_ELAPSED_TIME |
NUMBER(38,0) |
The elapsed journey time of the leg in minutes. |
Leg 1 Stops |
LEG_1_NUMBER_OF_STOPS |
NUMBER(38,0) |
The number of stops on the leg. |
Leg 1 Equipment Code |
LEG_1_EQUIPMENT |
VARCHAR (16777216) |
The IATA aircraft type code of the leg. |
Leg 1 Non-Operating Code Share Flight Numbers |
LEG_1_COMMENTS_010 |
VARCHAR (16777216) |
If the flight has a DEI010, indicating this is the operating carrier, then the non-operating carrier and flight number that duplicates with the leg will appear here. |
Leg 1 Operating Flight Number |
LEG_1_COMMENT_050 |
VARCHAR (16777216) |
If the flight has a DEI050, indicating this is not the operating carrier, then the operating carrier and flight number that duplicates with the leg will appear here. |
Leg 1 Distance |
LEG_1_DISTANCE |
NUMBER(38,0)
|
The great circle distance between the departure and arrival port on the leg expressed in kilometres. |
Leg 1 Departure Country |
LEG_1_DEPARTURE_COUNTRY |
VARCHAR (16777216) |
The departure country code of the leg assigned by the ISO and used by IATA. |
Leg 1 Arrival Country |
LEG_1_ARRIVAL_COUNTRY |
VARCHAR (16777216) |
The arrival country code of the leg assigned by the ISO and used by IATA. |
Leg 1 Connection Time |
LEG_1_CONNECTION_TIME |
NUMBER(38,0) |
The time in minutes to connect to the next flight leg in the record |
Leg 1 Low Cost Indicator |
LEG_1_IS_LOW_COST |
NUMBER(38,0) |
A value of 1 indicates that the specific flight leg is a low-cost carrier. |
Leg 1 MCT Status |
LEG_1_MCT_STATUS |
VARCHAR (16777216) |
Indicates the type of connection in terms of II (International-International), ID (International-Domestic), DI (Domestic-International) or DD (Domestic-Domestic). |
Leg 1 Traffic Restriction |
LEG_1_TRAFFIC_RESTRICTION |
VARCHAR (16777216) |
Indicates the traffic restriction code if any of the flight leg. |
Leg 1 Domicile Flag |
LEG_1_IS_DOMICILE_CARRIER |
NUMBER(38,0) |
Indicates if the carrier for the leg is domicile to the country of departure. |
Leg 1 Alliance Flag |
LEG_1_IS_IN_ALLIANCE |
NUMBER(38,0) |
Indicates if the carrier for the leg has an alliance membership |
Leg 1 Service Type |
LEG_1_SERVICE_TYPE |
VARCHAR (16777216) |
Indicates the IATA service type code of the flight leg. |
Leg 1 Equipment Type/Body |
LEG_1_TYPE_BODY |
VARCHAR (16777216) |
Shows the equipment body type for the flight leg. |
Leg 2 Departure City Code |
LEG_2_DEPARTURE_CITY_CODE |
VARCHAR (16777216)
|
The departure city code of the leg as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Leg 2 Departure Port Code |
LEG_2_DEPARTURE_AIRPORT_IATA |
VARCHAR (16777216) |
The departure port code of the leg as designated by IATA. |
Leg 2 Arrival City Code |
LEG_2_ARRIVAL_CITY_CODE |
VARCHAR (16777216) |
The arrival city code of the leg as designated by IATA. These are usually the same as the airport code unless the airport belongs to a multi airport city, e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports. |
Leg 2 Arrival Port Code |
LEG_2_ARRIVAL_AIRPORT_IATA |
VARCHAR (16777216) |
The arrival port code of the leg as designated by IATA. |
Leg 2 Carrier Code |
LEG_2_CARRIER_CODE_IATA |
VARCHAR (16777216) |
The airline designator code of the leg assigned by either: · IATA · ICAO · OAG (IATA Controlled duplicate designators with 7 prefix) |
Leg 2 Flight Number |
LEG_2_FLIGHT_NUMBER |
NUMBER(38,0) |
The four digit flight number of the leg. |
Leg 2 Effective From Date |
LEG_2_EFFECTIVE_PERIOD_START_DATE |
Date |
The local effective from date of the leg shown as “CCYYMMDD”. |
Leg 2 Effective To Date |
LEG_2_EFFECTIVE_PERIOD_END_DATE |
Date |
The local effective to date of the leg shown as “CCYYMMDD.” If a schedule is effective beyond that of the period chosen the date will appear as 20380101 |
Leg 2 Operating Days of Week |
LEG_2_DAYS_OF_OPERATION |
VARCHAR (16777216) |
The local operating departure days of the week of the leg. 1 = Monday, 2 = Tuesday etc. |
Leg 2 Departure Time |
LEG_2_DEPARTURE_LOCAL_TIME |
VARCHAR (16777216) |
The local departure time of the leg. The time is in 24 hour format expressed as hh:mm:ss. |
Leg 2 Arrival Time |
LEG_2_ARRIVAL_LOCAL_TIME |
VARCHAR (16777216) |
The local departure time of the leg. The time is in 24 hour format expressed as hh:mm:ss.. |
Leg 2 Arrival Day Marker |
LEG_2_ARRIVAL_INTERVAL_DAYS |
NUMBER(38,0)
|
The arrival day marker shows if the leg arrives on a different day to when it departed e.g. ‘-1’ = previous day,’0’ = same day,‘1’ = next day, ‘2’ = 2 days later etc. |
Leg 2 Elapsed Time |
LEG_2_ELAPSED_TIME |
NUMBER(38,0) |
The elapsed journey time of the leg in minutes. |
Leg 2 Stops |
LEG_2_NUMBER_OF_STOPS |
NUMBER(38,0) |
The number of stops on the leg. |
Leg 2 Equipment Code |
LEG_2_EQUIPMENT |
VARCHAR (16777216) |
The IATA aircraft type code of the leg. |
Leg 2 Non-Operating Code Share Flight Numbers |
LEG_2_COMMENTS_010 |
VARCHAR (16777216) |
If the flight has a DEI010, indicating this is the operating carrier, then the non-operating carrier and flight number that duplicates with the flight will appear here |
Leg 2 Operating Flight Number |
LEG_2_COMMENT_050 |
VARCHAR (16777216) |
If the flight has a DEI050, indicating this is not the operating carrier, then the operating carrier and flight number that duplicates with the flight will appear here. |
Leg 2 Distance |
LEG_2_DISTANCE |
NUMBER(38,0) |
The great circle distance between the departure and arrival port on the leg expressed in kilometres. |
Leg 2 Departure Country |
LEG_2_DEPARTURE_COUNTRY |
VARCHAR (16777216) |
The departure country code of the leg assigned by the ISO and used by IATA. |
Leg 2 Arrival Country |
LEG_2_ARRIVAL_COUNTRY |
VARCHAR (16777216) |
The arrival country code of the leg assigned by the ISO and used by IATA. |
Leg 2 Low Cost Indicator |
LEG_2_IS_LOW_COST |
VARCHAR (16777216) |
A value of 1 indicates that the specific flight leg is a low-cost carrier. |
Leg 2 Traffic Restriction |
LEG_2_TRAFFIC_RESTRICTION |
VARCHAR (16777216) |
Indicates the traffic restriction code if any of the flight leg |
Leg 2 Domicile Flag |
LEG_2_IS_DOMICILE_CARRIER |
VARCHAR (16777216) |
Indicates if the carrier for the leg is domicile to the country of departure. |
Leg 2 Alliance |
LEG_2_IS_IN_ALLIANCE |
VARCHAR (16777216) |
Indicates if the carrier for the leg has an alliance membership |
Leg 2 Service Type |
LEG_2_SERVICE_TYPE |
VARCHAR (16777216) |
Indicates the IATA service type code of the flight leg. |
Leg 2 Equipment Type/Body |
LEG_2_TYPE_BODY |
VARCHAR (16777216) |
Shows the equipment body type for the flight leg. |