Schedules record layout & descriptions

Refer to the below for a list of field names and its corresponding description for the schedules database.

For better understanding of the schedules database, we have aggregated the data points into categories:

  • Schedules includes the essential information about a flight.
  • Geography includes enhanced location information.
  • Route includes everything related with the journey.
  • Capacity is information related with passengers and cargo that the equipment can carry.
  • Supplementary includes any non-essential flight information such as inflight services and facilities.
  • Metadata is OAG related information.

The order and categorisation of the data points may not be as shown in the tables in the product.

1. Schedules view

1.1 Schedules

Field Name

Name in Database

Type

Description

Carrier Code

CARRIER

VARCHAR (3)

This field contains a carrier designator code assigned by either:

·      IATA (International Air Transport Association)

·      ICAO (International Civil Aviation Organization)

·      OAG (Controlled duplicate designators)

Carrier Code ICAO

CARRIER_CD_ICAO

VARCHAR (3)

The carrier designator as assigned by ICAO.

Service Number

FLTNO

INTEGER (4)

Up to 4 digit numeric representing the service number.

Operational Suffix

FLTSUFFX

VARCHAR (1)

A code assigned by the administrating carrier for operational purposes.

Stops

STOPS

NUMBER

This is the total number of stops on route.

Flight Date

FLIGHT_DATE

DATE (10)

The date that the operation departs, in YYYY-MM-DD.

Departure Time

DEPTIM

VARCHAR (4)

The local departure time in 24 hour format HHMM, e.g. 0925.

Departure Port Code

DEPAPT

VARCHAR (3)

The departure port code as assigned by IATA e.g. JFK.

Departure Port Code ICAO

DEP_PORT_CD_ICAO

VARCHAR (4)

The departure port code as assigned by ICAO e.g. KJFK.

Departure Terminal

DEPTERM

VARCHAR (2)

Terminal of Departure at the departure port.

Arrival Day

ARRDAY

VARCHAR (1)

The arrival day marker shows if the carrier arrives on a different day to when it departed.
‘1’ = next day, ‘2’ = 2 days later, ‘P’ = arrives on previous day.

Arrival Time

ARRTIM

VARCHAR (4)

The arrival departure time in 24 hour format HHMM, e.g. 1430.

Arrival Port Code

ARRAPT

VARCHAR (3)

The arrival port code as assigned by IATA e.g. LAX.

Arrival Port Code ICAO

ARR_PORT_CD_ICAO

VARCHAR (4)

The arrival port code as assigned by ICAO e.g. KLAX.

Arrival Terminal

ARRTERM

VARCHAR (2)

Terminal of Arrival at the arrival port.

1.2 Geography

Field Name

Name in Database

Type

Description

Departure City Code

DEPCITY

VARCHAR (3)

The departure city code as assigned by IATA.

These are usually the same as the port code unless the port belongs to a multi port city e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports.

Departure Country Code

DEPCTRY

VARCHAR (2)

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

Arrival City Code

ARRCITY

VARCHAR (3)

The arrival city code as assigned by IATA.

These are usually the same as the port code unless the port belongs to a multi port city e.g. LON is the city code for LHR, LGW, LCY, STN and LTN airports.

Arrival Country Code

ARRCTRY

VARCHAR (2)

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

1.3 Route

Field Name

Name in Database

Type

Description

Full Routing

ROUTING

VARCHAR (12)

The full routing which the record belongs to. The ports are shown as 3 letter IATA codes.
The full routing is shown for each leg/sector of every operation. E.g. BA 009 full routing is LHR BKK SYD MEL. This full routing will be shown as ‘LHRBKKSYDMEL’ on every record that makes up this operation.

Distance

DISTANCE

INTEGER

The great circle distance expressed in statute miles between the Departure Port and Arrival Port.

Longest Sector

LONGEST

VARCHAR (1)

Marker to show the operation that stops at all ports within the Full Routing.

Intermediate Ports

INTAPT

VARCHAR (39)

The ports at which any stops occur. These are shown as 3 letter IATA port codes. If there are 2 stops on route at Hong Kong and Delhi it would be shown as HKGDEL. Up to 13 intermediate ports are shown in this field.

1.4 Equipment

Field Name

Name in Database

Type

Description

General Equipment Type

GENACFT

VARCHAR (3)

General equipment type is the IATA generic equipment type code used to describe one or more equipment of a particular type. A 747 equipment type could describe a 747, 741, 742 or a 74R specific equipment type.

Specific Equipment Type

INPACFT

VARCHAR (3)

Specific (or input) equipment type is the specific IATA equipment type code.

Specific Equipment Type ICAO

EQUIPMENT_CD_ICAO

VARCHAR (4)

Specific equipment type as designated by ICAO.

Equipment Change

ACFTCHANGE

VARCHAR (1)

Marker to show equipment change on route.

Equipment Owner

ACFT_OWNER

VARCHAR (3)

The carrier that owns the equipment.

1.5 Supplementary

Field Name

Name in Database

Type

Description

Elapsed Journey Time

ELPTIM

VARCHAR (5)

The elapsed journey time shown as HHHMM.

Service Type

SERVICE

VARCHAR (1)

Indicates the utilisation of the equipment whether passenger, cargo etc. For a list of IATA service type codes and their descriptions, please click here.

Inflight Service

INFLTSERVICE

VARCHAR (42)

Denotes the use of in-flight services in relation to the IATA standard. This is a “/” separated string. For a list of in-flight service codes and their descriptions, please click here.

Meals

MEALS

VARCHAR (23)

A field identifying the meal service codes (defined by IATA) in the First/Business/Premium Economy/Economy cabins for the operation. Variations in meal service by compartments are separated by a “/” character. A “-“ (hyphen) indicates no meal service for that specific compartment. For a list of meal codes, please click here.

Comment 010/050

COMM10_50

VARCHAR (3)

Details the DEI 010/050 value relating to Duplicate Leg Cross Reference:

010 = Operating carrier.

050 = Non-operating carrier.
011 = Part of the stopping service has a comment 010.
055 = Part of the stopping service has a comment 050.
015 = Part of the stopping service has a comment 010 and another part has a comment 050.

Operating/Non-Operating Marker

OPERATING

VARCHAR (1)

A marker to show if the carrier is operating or non-operating the operation when a code share relationship exists. For operations with no code share the entry will be blank.

O = Operating
N = Non-Operating

Ghost Flight

GHOST

VARCHAR (1)

A marker to show non-operating ghost/funnel flights.

Duplicate Services

DUPCARFL

VARCHAR (160)

Every service number that duplicates with the operation. All are shown for the operating service and just the operating carrier for a non-operating service.

If the record is representing a stopping service with different code share service numbers on each leg the entry will be blank. The correct information will still be shown on the respective non-stopping legs.

Shared Airline Designator Code

SAD

VARCHAR (3)

Shows the carrier that operates the service in a shared airline agreement. Where an airline integrates their schedules with another airline and sometimes shares the airline code. In a typical case some or all the services operated by a commuter airline are identified with the code of the airline with which it has a special agreement. In some cases both carriers will show a schedule for the operation.

Shared Airline Designator Name

SAD_NAME

VARCHAR (63)

Represents the name of the Shared Airline Designator.

Restriction

RESTRICT

VARCHAR (1)

The restriction code that applies to traffic rights, stopovers or transfer connections.

Domestic/International MCT Marker

DOMINT

VARCHAR (2)

The passenger status for Minimum Connection Times (MCT) for the purpose of building connections. The first value is the arrival status and the second is the departure status. These can be used with MCT information published.

Government Approval

GOVT_APP

VARCHAR (1)

Marker to show service is subject to government approval.

Secure Flight

SECUREFLT

VARCHAR (1)

This data element is present when there is a legal requirement to disclose full Secure Flight passenger data for flights that are operated by a carrier (operating and marketing) flying to/from/within/over the U.S.

S indicates TSA regulations apply.

1.6 Metadata

Field Name

Name in Database

Type

Description

Schedule Fingerprint

OAG_SCHEDULE_FINGERPRINT

VARCHAR (64)

This is a unique key based on all of the fields except FILE_DATE. If two rows have the same schedule fingerprint then they are identical.

File Date

FILE_DATE

DATE (10)

Represents the date on which that row of data was uploaded into the database e.g. YYYY-MM-DD.

2.1 Seats View

Field Name

Name in Database

Type

Description

Passenger Classes

PX

VARCHAR (52)

The passenger classes available on the operation.

Freight Classes

FRTCLASS

VARCHAR (2)

The freight classes indicate the type of cargo that can be loaded onto the equipment.

Freight Tons

TONS

NUMBER (6)

The maximum amount of freight tons that can be carried on the operation. Where specific freight data by carrier is not available equipment defaults are used. This is displayed as 0000.0.

Available Total Seats

TOTAL_SEATS

NUMBER (4)

Available seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.

Available First Class Seats

FIRST_CLASS_SEATS

NUMBER (4)

Available First Class seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.

Available Business Class Seats

BUSINESS_CLASS_SEATS

NUMBER (4)

Available Business Class seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.

Available Premium Economy Class Seats

PREMIUM_ECONOMY_CLASS_SEATS

NUMBER (4)

Available Premium Economy seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.

Available Economy Class Plus Seats

ECONOMY_PLUS_CLASS_SEATS

NUMBER (4)

Available Economy Plus seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.

Available Economy Class Seats

ECONOMY_CLASS_SEATS

NUMBER (4)

Available Economy seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model.