Connections data record layout and descriptions

Refer to the below for a list of field names and its 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_PORT_CODE

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_PORT_CODE

VARCHAR (16777216)

The arrival port code as designated by IATA.

Effective From Date​

EFFECTIVE_FROM_DATE

Date

The local effective from date shown as “CCYYMMDD”.

Effective To Date​

EFFECTIVE_TO_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​

OPERATING_DAYS_OF_WEEK

VARCHAR (16777216)

The local operating departure days of the week. 1 = Monday, 2 = Tuesday etc.

Arrival Day Marker​

ARRIVAL_DAY_MARKER

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​

CONNECTION_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

FORCED_CONNECTION_SELF_CONNECT

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_PORT_CODE

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_PORT_CODE

VARCHAR (16777216)

The arrival port code of the leg as designated by IATA.

Leg 1 Carrier Code​

LEG_1_CARRIER_CODE

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_FROM_DATE

Date

The local effective from date of the leg shown as “CCYYMMDD”.

Leg 1 Effective To Date​

LEG_1_EFFECTIVE_TO_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_OPERATING_DAYS_OF_WEEK

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_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_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​

LEG_1_ARRIVAL_DAY_MARKER

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_STOPS

NUMBER(38,0)

The number of stops on the leg.

Leg 1 Equipment Code

LEG_1_EQUIPMENT_CODE

VARCHAR (16777216)

The IATA aircraft type code of the leg.

Leg 1 Non-Operating Code Share Flight Numbers​

LEG_1_NON_OPERATING_CODE_SHARE_FLIGHT_NUMBERS

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_OPERATING_FLIGHT_NUMBER

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_LOW_COST_INDICATOR

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_DOMICILE_FLAG

NUMBER(38,0)

Indicates if the carrier for the leg is domicile to the country of departure.

Leg 1 Alliance Flag

LEG_1_ALLIANCE_FLAG

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_EQUIPMENT_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_PORT_CODE

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_PORT_CODE

VARCHAR (16777216)

The arrival port code of the leg as designated by IATA.

Leg 2 Carrier Code​

LEG_2_CARRIER_CODE

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_FROM_DATE

Date

The local effective from date of the leg shown as “CCYYMMDD”.

Leg 2 Effective To Date​

LEG_2_EFFECTIVE_TO_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_OPERATING_DAYS_OF_WEEK

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_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_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_DAY_MARKER

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_STOPS

NUMBER(38,0)

The number of stops on the leg.

Leg 2 Equipment Code

LEG_2_EQUIPMENT_CODE

VARCHAR (16777216)

The IATA aircraft type code of the leg.

Leg 2 Non-Operating Code Share Flight Numbers​

LEG_2_NON_OPERATING_CODE_SHARE_FLIGHT_NUMBERS

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_OPERATING_FLIGHT_NUMBER

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_LOW_COST_INDICATOR

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_DOMICILE_FLAG

VARCHAR (16777216)

Indicates if the carrier for the leg is domicile to the country of departure.

Leg 2 Alliance

LEG_2_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_EQUIPMENT_TYPE_BODY

VARCHAR (16777216)

Shows the equipment body type for the flight leg.