1. Flight Info FAQs
  2. Flight Info Direct

Passenger Bookings: Data Fields Explained

Refer to the below for a list of field names and their corresponding description in the Passenger Booking Direct table.

Forward Looking MIDT – Booking View

Field Name

Name in Database

Type

Description

Travel Month

TRAVEL_MONTH

DATE

The month of passenger travel

Point Of Sale Country IATA

POINT_OF_SALE_COUNTRY_IATA

VARCHAR (16777216)

Agency Point of Sale

Point Of Origin Airport IATA

POINT_OF_ORIGIN_AIRPORT_IATA

VARCHAR (16777216)

Origin of passenger as an airport code i.e. where they started their journey (linked to point of sale)

Point Of Origin City IATA

POINT_OF_ORIGIN_CITY_IATA

VARCHAR (16777216)

Origin of passenger as a country code i.e. where they started their journey (linked to point of sale)

Point Of Origin Country IATA

POINT_OF_ORIGIN_COUNTRY_IATA

VARCHAR (16777216)

Origin of passenger as a city code i.e. where they started their journey (linked to point of sale)

Scheduled Departure Airport IATA

SCHEDULED_DEPARTURE_AIRPORT_IATA

VARCHAR (16777216)

Departure airport code

Scheduled Departure City IATA

SCHEDULED_DEPARTURE_CITY_IATA

VARCHAR (16777216)

Departure city code

Scheduled Departure Country IATA

SCHEDULED_DEPARTURE_COUNTRY_IATA

VARCHAR (16777216)

Departure country code

Scheduled Arrival Airport IATA

SCHEDULED_ARRIVAL_AIRPORT_IATA

VARCHAR (16777216)

Arrival airport code

Scheduled Arrival City IATA

SCHEDULED_ARRIVAL_CITY_IATA

VARCHAR (16777216)

Arrival city code

Scheduled Arrival Country IATA

SCHEDULED_ARRIVAL_COUNTRY_IATA

VARCHAR (16777216)

Arrival country code

Great Circle Distance Miles

GREAT_CIRCLE_DISTANCE_MILES

FLOAT

Total Great Circle Distance for the route

Dominant Marketing Carrier

DOMINANT_MARKETING_CARRIER

VARCHAR (16777216)

Published Airline Code (Dominant carrier – the one that operates the longest leg of the routing)

Dominant Operating Carrier

DOMINANT_OPERATING_CARRIER

VARCHAR (16777216)

Actual Operating Airline Code (Dominant carrier)

Dominant Owner Carrier

DOMINANT_OWNER_CARRIER

VARCHAR (16777216)

Owner Airline Code (Dominant carrier)

Marketing Carrier Leg 1

MARKETING_CARRIER_LEG_1

VARCHAR (16777216)

Published Airline Code for the First leg of the routing

Marketing Carrier Leg 2

MARKETING_CARRIER_LEG_2

VARCHAR (16777216)

Published Airline Code for the Second leg of the routing

Marketing Carrier Leg 3

MARKETING_CARRIER_LEG_3

VARCHAR (16777216)

Published Airline Code for the Third leg of the routing

Operating Carrier Leg 1

OPERATING_CARRIER_LEG_1

VARCHAR (16777216)

Operating Airline Code for the First leg of the routing

Operating Carrier Leg 2

OPERATING_CARRIER_LEG_2

VARCHAR (16777216)

Operating Airline Code for the Second leg of the routing

Operating Carrier Leg 3

OPERATING_CARRIER_LEG_3

VARCHAR (16777216)

Operating Airline Code for the Third leg of the routing

Connecting Airport 1 IATA

CONNECTING_AIRPORT_1_IATA

VARCHAR (16777216)

Connection 1 Airport code

Connecting City 1 IATA

CONNECTING_CITY_1_ IATA

VARCHAR (16777216)

Connection 1 city code

Connecting Country 1 IATA

CONNECTING_COUNTRY_1_IATA

VARCHAR (16777216)

Connection 1 country code

Connecting Airport 2 IATA

CONNECTING_AIRPORT_2_IATA

VARCHAR (16777216)

Connection 2 Airport code

Connecting City 2 IATA

CONNECTING_CITY_2_IATA

VARCHAR (16777216)

Connection 2 city code

Connecting Country 2 IATA

CONNECTING_COUNTRY_2_IATA

VARCHAR (16777216)

Connection 2 country code

Legs Total

LEGS_TOTAL

NUMBER (38,0)

The total number of Legs on the Booking

Passengers Booking Class A

PASSENGERS_BOOKING_CLASS_A

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator A

Passengers Booking Class B

PASSENGERS_BOOKING_CLASS_B

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator B

Passengers Booking Class C

PASSENGERS_BOOKING_CLASS_C

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator C

Passengers Booking Class D

PASSENGERS_BOOKING_CLASS_D

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator D

Passengers Booking Class E

PASSENGERS_BOOKING_CLASS_E

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator E

Passengers Booking Class F

PASSENGERS_BOOKING_CLASS_F

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator F

Passengers Booking Class G

PASSENGERS_BOOKING_CLASS_G

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator G

Passengers Booking Class H

PASSENGERS_BOOKING_CLASS_H

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator H

Passengers Booking Class I

PASSENGERS_BOOKING_CLASS_I

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator I

Passengers Booking Class J

PASSENGERS_BOOKING_CLASS_J

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator J

Passengers Booking Class K

PASSENGERS_BOOKING_CLASS_K

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator K

Passengers Booking Class L

PASSENGERS_BOOKING_CLASS_L

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator L

Passengers Booking Class M

PASSENGERS_BOOKING_CLASS_M

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator M

Passengers Booking Class N

PASSENGERS_BOOKING_CLASS_N

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator N

Passengers Booking Class O

PASSENGERS_BOOKING_CLASS_O

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator O

Passengers Booking Class P

PASSENGERS_BOOKING_CLASS_P

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator P

Passengers Booking Class Q

PASSENGERS_BOOKING_CLASS_Q

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Q

Passengers Booking Class R

PASSENGERS_BOOKING_CLASS_R

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator R

Passengers Booking Class S

PASSENGERS_BOOKING_CLASS_S

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator S

Passengers Booking Class T

PASSENGERS_BOOKING_CLASS_T

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator T

Passengers Booking Class U

PASSENGERS_BOOKING_CLASS_U

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator U

Passengers Booking Class V

PASSENGERS_BOOKING_CLASS_V

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator V

Passengers Booking Class W

PASSENGERS_BOOKING_CLASS_W

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator W

Passengers Booking Class X

PASSENGERS_BOOKING_CLASS_X

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator X

Passengers Booking Class Y

PASSENGERS_BOOKING_CLASS_Y

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Y

Passengers Booking Class Z

PASSENGERS_BOOKING_CLASS_Z

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Z

Passengers Booking Class First

PASSENGERS_BOOKING_CLASS_FIRST

NUMBER (38,0)

Actual total first class bookings from GDS system

Passengers Booking Class Business

PASSENGERS_BOOKING_CLASS_BUSINESS

NUMBER (38,0)

Actual total business class bookings from GDS system

Passengers Booking Class Premium Economy

PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY

NUMBER (38,0)

Actual total premium economy bookings from GDS system

Passengers Booking Class Economy

PASSENGERS_BOOKING_CLASS_ECONOMY

NUMBER (38,0)

Actual total economy class bookings from GDS system

Passengers Booking Class Discount Economy

PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY

NUMBER (38,0)

Actual total discount economy bookings from GDS system

Passengers Total

PASSENGERS_TOTAL

NUMBER (38,0)

Actual total bookings from GDS system

Unadjusted Booking ID

 

UNADJUSTED_BOOKING_ID

 

VARCHAR (16777216)

ID that allows cross reference to segment view data

File Date

FILE_DATE

DATE

Load data of data set

Forward Looking MIDT – Segment View

Field Name

Name in Database

Type

Description

Travel Month

TRAVEL_MONTH

DATE

The month of passenger travel

Point Of Sale Country IATA

POINT_OF_SALE_COUNTRY_IATA

VARCHAR (16777216)

Agency Point of Sale

Point Of Origin Airport IATA

POINT_OF_ORIGIN_AIRPORT_IATA

VARCHAR (16777216)

Origin of passenger as an airport code i.e. where they started their journey (linked to point of sale)

Point Of Origin City IATA

POINT_OF_ORIGIN_CITY_IATA

VARCHAR (16777216)

Origin of passenger as a country code i.e. where they started their journey (linked to point of sale)

Point Of Origin Country IATA

POINT_OF_ORIGIN_COUNTRY_IATA

VARCHAR (16777216)

Origin of passenger as a city code i.e. where they started their journey (linked to point of sale)

Scheduled Departure Airport IATA

SCHEDULED_DEPARTURE_AIRPORT_IATA

VARCHAR (16777216)

Departure airport code

Scheduled Departure City IATA

SCHEDULED_DEPARTURE_CITY_IATA

VARCHAR (16777216)

Departure city code

Scheduled Departure Country IATA

SCHEDULED_DEPARTURE_COUNTRY_IATA

VARCHAR (16777216)

Departure country code

Scheduled Arrival Airport IATA

SCHEDULED_ARRIVAL_AIRPORT_IATA

VARCHAR (16777216)

Arrival airport code

Scheduled Arrival City IATA

SCHEDULED_ARRIVAL_CITY_IATA

VARCHAR (16777216)

Arrival city code

Scheduled Arrival Country IATA

SCHEDULED_ARRIVAL_COUNTRY_IATA

VARCHAR (16777216)

Arrival country code

Great Circle Distance Miles

GREAT_CIRCLE_DISTANCE_MILES

FLOAT

Great Circle Distance for the leg

Marketing Carrier

MARKETING_CARRIER

VARCHAR (16777216)

Published Airline Code for the routing

Operating Carrier

OPERATING_CARRIER

VARCHAR (16777216)

Operating Airline Code for the routing

Leg

LEG

NUMBER (1,0)

The leg from the original booking this record relates to

Legs Total

LEGS_TOTAL

NUMBER (38,0)

The total number of Legs on the Booking

Passengers Booking Class A

PASSENGERS_BOOKING_CLASS_A

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator A

Passengers Booking Class B

PASSENGERS_BOOKING_CLASS_B

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator B

Passengers Booking Class C

PASSENGERS_BOOKING_CLASS_C

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator C

Passengers Booking Class D

PASSENGERS_BOOKING_CLASS_D

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator D

Passengers Booking Class E

PASSENGERS_BOOKING_CLASS_E

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator E

Passengers Booking Class F

PASSENGERS_BOOKING_CLASS_F

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator F

Passengers Booking Class G

PASSENGERS_BOOKING_CLASS_G

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator G

Passengers Booking Class H

PASSENGERS_BOOKING_CLASS_H

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator H

Passengers Booking Class I

PASSENGERS_BOOKING_CLASS_I

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator I

Passengers Booking Class J

PASSENGERS_BOOKING_CLASS_J

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator J

Passengers Booking Class K

PASSENGERS_BOOKING_CLASS_K

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator K

Passengers Booking Class L

PASSENGERS_BOOKING_CLASS_L

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator L

Passengers Booking Class M

PASSENGERS_BOOKING_CLASS_M

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator M

Passengers Booking Class N

PASSENGERS_BOOKING_CLASS_N

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator N

Passengers Booking Class O

PASSENGERS_BOOKING_CLASS_O

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator O

Passengers Booking Class P

PASSENGERS_BOOKING_CLASS_P

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator P

Passengers Booking Class Q

PASSENGERS_BOOKING_CLASS_Q

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Q

Passengers Booking Class R

PASSENGERS_BOOKING_CLASS_R

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator R

Passengers Booking Class S

PASSENGERS_BOOKING_CLASS_S

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator S

Passengers Booking Class T

PASSENGERS_BOOKING_CLASS_T

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator T

Passengers Booking Class U

PASSENGERS_BOOKING_CLASS_U

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator U

Passengers Booking Class V

PASSENGERS_BOOKING_CLASS_V

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator V

Passengers Booking Class W

PASSENGERS_BOOKING_CLASS_W

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator W

Passengers Booking Class X

PASSENGERS_BOOKING_CLASS_X

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator X

Passengers Booking Class Y

PASSENGERS_BOOKING_CLASS_Y

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Y

Passengers Booking Class Z

PASSENGERS_BOOKING_CLASS_Z

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Z

Passengers Booking Class First

PASSENGERS_BOOKING_CLASS_FIRST

NUMBER (38,0)

Actual total first class bookings from GDS system

Passengers Booking Class Business

PASSENGERS_BOOKING_CLASS_BUSINESS

NUMBER (38,0)

Actual total business class bookings from GDS system

Passengers Booking Class Premium Economy

PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY

NUMBER (38,0)

Actual total premium economy bookings from GDS system

Passengers Booking Class Economy

PASSENGERS_BOOKING_CLASS_ECONOMY

NUMBER (38,0)

Actual total economy class bookings from GDS system

Passengers Booking Class Discount Economy

PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY

NUMBER (38,0)

Actual total discount economy bookings from GDS system

Passengers Total

PASSENGERS_TOTAL

NUMBER (38,0)

Actual total bookings from GDS system

Unadjusted Booking ID

 

UNADJUSTED_BOOKING_ID

 

VARCHAR (16777216)

ID that allows cross reference to segment view data

File Date

FILE_DATE

DATE

Load data of data set

Backward Looking Full Market – Booking View

Field Name

Name in Database

Type

Description

Travel Month

TRAVEL_MONTH

DATE

The month of passenger travel

Point Of Sale Country IATA

POINT_OF_SALE_COUNTRY_IATA

VARCHAR (16777216)

Agency Point of Sale

Point Of Origin Airport IATA

POINT_OF_ORIGIN_AIRPORT_IATA

VARCHAR (16777216)

Origin of passenger as an airport code i.e. where they started their journey (linked to point of sale)

Point Of Origin City IATA

POINT_OF_ORIGIN_CITY_IATA

VARCHAR (16777216)

Origin of passenger as a country code i.e. where they started their journey (linked to point of sale)

Point Of Origin Country IATA

POINT_OF_ORIGIN_COUNTRY_IATA

VARCHAR (16777216)

Origin of passenger as a city code i.e. where they started their journey (linked to point of sale)

Scheduled Departure Airport IATA

SCHEDULED_DEPARTURE_AIRPORT_IATA

VARCHAR (16777216)

Departure airport code

Scheduled Departure City IATA

SCHEDULED_DEPARTURE_CITY_IATA

VARCHAR (16777216)

Departure city code

Scheduled Departure Country IATA

SCHEDULED_DEPARTURE_COUNTRY_IATA

VARCHAR (16777216)

Departure country code

Scheduled Arrival Airport IATA

SCHEDULED_ARRIVAL_AIRPORT_IATA

VARCHAR (16777216)

Arrival airport code

Scheduled Arrival City IATA

SCHEDULED_ARRIVAL_CITY_IATA

VARCHAR (16777216)

Arrival city code

Scheduled Arrival Country IATA

SCHEDULED_ARRIVAL_COUNTRY_IATA

VARCHAR (16777216)

Arrival country code

Great Circle Distance Miles

GREAT_CIRCLE_DISTANCE_MILES

FLOAT

Total Great Circle Distance for the route

Dominant Marketing Carrier

DOMINANT_MARKETING_CARRIER

VARCHAR (16777216)

Published Airline Code (Dominant carrier – the one that operates the longest leg of the routing)

Dominant Operating Carrier

DOMINANT_OPERATING_CARRIER

VARCHAR (16777216)

Actual Operating Airline Code (Dominant carrier)

Dominant Owner Carrier

DOMINANT_OWNER_CARRIER

VARCHAR (16777216)

Owner Airline Code (Dominant carrier)

Marketing Carrier Leg 1

MARKETING_CARRIER_LEG_1

VARCHAR (16777216)

Published Airline Code for the First leg of the routing

Marketing Carrier Leg 2

MARKETING_CARRIER_LEG_2

VARCHAR (16777216)

Published Airline Code for the Second leg of the routing

Marketing Carrier Leg 3

MARKETING_CARRIER_LEG_3

VARCHAR (16777216)

Published Airline Code for the Third leg of the routing

Operating Carrier Leg 1

OPERATING_CARRIER_LEG_1

VARCHAR (16777216)

Operating Airline Code for the First leg of the routing

Operating Carrier Leg 2

OPERATING_CARRIER_LEG_2

VARCHAR (16777216)

Operating Airline Code for the Second leg of the routing

Operating Carrier Leg 3

OPERATING_CARRIER_LEG_3

VARCHAR (16777216)

Operating Airline Code for the Third leg of the routing

Connecting Airport 1 IATA

CONNECTING_AIRPORT_1_IATA

VARCHAR (16777216)

Connection 1 Airport code

Connecting City 1 IATA

CONNECTING_CITY_1_IATA

VARCHAR (16777216)

Connection 1 city code

Connecting Country 1 IATA

CONNECTING_COUNTRY_1_IATA

VARCHAR (16777216)

Connection 1 country code

Connecting Airport 2 IATA

CONNECTING_AIRPORT_2_IATA

VARCHAR (16777216)

Connection 2 Airport code

Connecting City 2 IATA

CONNECTING_CITY_2_IATA

VARCHAR (16777216)

Connection 2 city code

Connecting Country 2 IATA

CONNECTING_COUNTRY_2_IATA

VARCHAR (16777216)

Connection 2 country code

Connecting Airport 1 A IATA

CONNECTING_AIRPORT_1_A_IATA

VARCHAR (16777216)

The Leg 2 departure IATA airport code. Represents inter-city connections where next flight departs from a different airport.

Connecting City 1 A IATA

CONNECTING_CITY_1_A_IATA

VARCHAR (16777216)

The Leg 2 departure IATA city code. Represents inter-city connections where next flight departs from a different airport.

Connecting Country 1 A IATA

CONNECTING_COUNTRY_1_A_IATA

VARCHAR (16777216)

The Leg 2 departure IATA country code. Represents inter-city connections where next flight departs from a different airport.

Connecting Airport 2 A IATA

CONNECTING_AIRPORT_2_A_IATA

VARCHAR (16777216)

The Leg 3 departure IATA airport code. Represents inter-city connections where next flight departs from a different airport.

Connecting City 2 A IATA

CONNECTING_CITY_2_A_IATA

VARCHAR (16777216)

The Leg 3 departure IATA city code. Represents inter-city connections where next flight departs from a different airport.

Connecting Country 2 A IATA

CONNECTING_COUNTRY_2_A_IATA

VARCHAR (16777216)

The Leg 3 departure IATA country code. Represents inter-city connections where next flight departs from a different airport.

Stopping Airport 1 Leg 1 IATA

STOPPING_AIRPORT_1_LEG_1_IATA

VARCHAR (16777216)

Shows Leg 1 1st stopping IATA airport if applicable

Stopping Airport 2 Leg 1 IATA

STOPPING_AIRPORT_2_LEG_1_IATA

VARCHAR (16777216)

Shows Leg 1 2nd stopping IATA airport if applicable

Stopping Airport 3 Leg 1 IATA

STOPPING_AIRPORT_3_LEG_1_IATA

VARCHAR (16777216)

Shows Leg 1 3rd stopping IATA airport if applicable

Stopping Airport 1 Leg 2 IATA

STOPPING_AIRPORT_1_LEG_2_IATA

VARCHAR (16777216)

Shows Leg 2 1st stopping IATA airport if applicable

Stopping Airport 2 Leg 2 IATA

STOPPING_AIRPORT_2_LEG_2_IATA

VARCHAR (16777216)

Shows Leg 2 2nd stopping IATA airport if applicable

Stopping Airport 3 Leg 2 IATA

STOPPING_AIRPORT_3_LEG_2_IATA

VARCHAR (16777216)

Shows Leg 2 3rd stopping IATA airport if applicable

Stopping Airport 1 Leg 3 IATA

STOPPING_AIRPORT_1_LEG_3_IATA

VARCHAR (16777216)

Shows Leg 3 1st stopping IATA airport if applicable

Stopping Airport 2 Leg 3 IATA

STOPPING_AIRPORT_2_LEG_3_IATA

VARCHAR (16777216)

Shows Leg 3 2nd stopping IATA airport if applicable

Stopping Airport 3 Leg 3 IATA

STOPPING_AIRPORT_3_LEG_3_IATA

VARCHAR (16777216)

Shows Leg 3 3rd stopping IATA airport if applicable

Passengers Booking Class A

PASSENGERS_BOOKING_CLASS_A

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator A

Passengers Booking Class B

PASSENGERS_BOOKING_CLASS_B

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator B

Passengers Booking Class C

PASSENGERS_BOOKING_CLASS_C

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator C

Passengers Booking Class D

PASSENGERS_BOOKING_CLASS_D

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator D

Passengers Booking Class E

PASSENGERS_BOOKING_CLASS_E

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator E

Passengers Booking Class F

PASSENGERS_BOOKING_CLASS_F

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator F

Passengers Booking Class G

PASSENGERS_BOOKING_CLASS_G

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator G

Passengers Booking Class H

PASSENGERS_BOOKING_CLASS_H

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator H

Passengers Booking Class I

PASSENGERS_BOOKING_CLASS_I

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator I

Passengers Booking Class J

PASSENGERS_BOOKING_CLASS_J

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator J

Passengers Booking Class K

PASSENGERS_BOOKING_CLASS_K

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator K

Passengers Booking Class L

PASSENGERS_BOOKING_CLASS_L

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator L

Passengers Booking Class M

PASSENGERS_BOOKING_CLASS_M

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator M

Passengers Booking Class N

PASSENGERS_BOOKING_CLASS_N

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator N

Passengers Booking Class O

PASSENGERS_BOOKING_CLASS_O

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator O

Passengers Booking Class P

PASSENGERS_BOOKING_CLASS_P

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator P

Passengers Booking Class Q

PASSENGERS_BOOKING_CLASS_Q

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Q

Passengers Booking Class R

PASSENGERS_BOOKING_CLASS_R

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator R

Passengers Booking Class S

PASSENGERS_BOOKING_CLASS_S

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator S

Passengers Booking Class T

PASSENGERS_BOOKING_CLASS_T

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator T

Passengers Booking Class U

PASSENGERS_BOOKING_CLASS_U

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator U

Passengers Booking Class V

PASSENGERS_BOOKING_CLASS_V

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator V

Passengers Booking Class W

PASSENGERS_BOOKING_CLASS_W

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator W

Passengers Booking Class X

PASSENGERS_BOOKING_CLASS_X

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator X

Passengers Booking Class Y

PASSENGERS_BOOKING_CLASS_Y

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Y

Passengers Booking Class Z

PASSENGERS_BOOKING_CLASS_Z

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Z

Passengers Booking Class Unknown

PASSENGERS_BOOKING_CLASS_UNKNOWN

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Unknown

Passengers Booking Class First

PASSENGERS_BOOKING_CLASS_FIRST

NUMBER (38,0)

Actual total first class bookings from GDS system

Passengers Booking Class Business

PASSENGERS_BOOKING_CLASS_BUSINESS

NUMBER (38,0)

Actual total business class bookings from GDS system

Passengers Booking Class Premium Economy

PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY

NUMBER (38,0)

Actual total premium economy bookings from GDS system

Passengers Booking Class Economy

PASSENGERS_BOOKING_CLASS_ECONOMY

NUMBER (38,0)

Actual total economy class bookings from GDS system

Passengers Booking Class Discount Economy

PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY

NUMBER (38,0)

Actual total discount economy bookings from GDS system

Passengers Total

PASSENGERS_TOTAL

NUMBER (38,0)

Actual total bookings from GDS system

Adjusted Booking ID

 

ADJUSTED_BOOKING_ID

 

VARCHAR (16777216)

ID that allows cross reference to segment view data

Backward Looking Full Market – Segment View

Field Name

Name in Database

Type

Description

Travel Month

TRAVEL_MONTH

DATE

The month of passenger travel

Point Of Sale Country IATA

POINT_OF_SALE_COUNTRY_IATA

VARCHAR (16777216)

Agency Point of Sale

Point Of Origin Airport IATA

POINT_OF_ORIGIN_AIRPORT_IATA

VARCHAR (16777216)

Origin of passenger as an airport code i.e. where they started their journey (linked to point of sale)

Point Of Origin City IATA

POINT_OF_ORIGIN_CITY_IATA

VARCHAR (16777216)

Origin of passenger as a country code i.e. where they started their journey (linked to point of sale)

Point Of Origin Country IATA

POINT_OF_ORIGIN_COUNTRY_IATA

VARCHAR (16777216)

Origin of passenger as a city code i.e. where they started their journey (linked to point of sale)

Scheduled Departure Airport IATA

SCHEDULED_DEPARTURE_AIRPORT_IATA

VARCHAR (16777216)

Departure airport code

Scheduled Departure City IATA

SCHEDULED_DEPARTURE_CITY_IATA

VARCHAR (16777216)

Departure city code

Scheduled Departure Country IATA

SCHEDULED_DEPARTURE_COUNTRY_IATA

VARCHAR (16777216)

Departure country code

Scheduled Arrival Airport IATA

SCHEDULED_ARRIVAL_AIRPORT_IATA

VARCHAR (16777216)

Arrival airport code

Scheduled Arrival City IATA

SCHEDULED_ARRIVAL_CITY_IATA

VARCHAR (16777216)

Arrival city code

Scheduled Arrival Country IATA

SCHEDULED_ARRIVAL_COUNTRY_IATA

VARCHAR (16777216)

Arrival country code

Great Circle Distance Miles

GREAT_CIRCLE_DISTANCE_MILES

FLOAT

Great Circle Distance for the Leg

Marketing Carrier

MARKETING_CARRIER

VARCHAR (16777216)

Published Airline Code for the leg

Operating Carrier

OPERATING_CARRIER

VARCHAR (16777216)

Operating Airline Code for the leg

Stopping Airport 1 IATA

STOPPING_AIRPORT_1_IATA

VARCHAR (16777216)

Shows Leg 1 1st stopping IATA airport if applicable

Stopping Airport 2 IATA

STOPPING_AIRPORT_2_IATA

VARCHAR (16777216)

Shows Leg 1 2nd stopping IATA airport if applicable

Stopping Airport 3 IATA

STOPPING_AIRPORT_3_IATA

VARCHAR (16777216)

Shows Leg 1 3rd stopping IATA airport if applicable

Leg

LEG

NUMBER (38,0)

The leg from the original booking this record relates to

Legs Total

LEGS_TOTAL

NUMBER (38,0)

The total number of Legs on the Booking

Passengers Booking Class A

PASSENGERS_BOOKING_CLASS_A

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator A

Passengers Booking Class B

PASSENGERS_BOOKING_CLASS_B

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator B

Passengers Booking Class C

PASSENGERS_BOOKING_CLASS_C

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator C

Passengers Booking Class D

PASSENGERS_BOOKING_CLASS_D

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator D

Passengers Booking Class E

PASSENGERS_BOOKING_CLASS_E

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator E

Passengers Booking Class F

PASSENGERS_BOOKING_CLASS_F

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator F

Passengers Booking Class G

PASSENGERS_BOOKING_CLASS_G

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator G

Passengers Booking Class H

PASSENGERS_BOOKING_CLASS_H

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator H

Passengers Booking Class I

PASSENGERS_BOOKING_CLASS_I

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator I

Passengers Booking Class J

PASSENGERS_BOOKING_CLASS_J

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator J

Passengers Booking Class K

PASSENGERS_BOOKING_CLASS_K

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator K

Passengers Booking Class L

PASSENGERS_BOOKING_CLASS_L

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator L

Passengers Booking Class M

PASSENGERS_BOOKING_CLASS_M

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator M

Passengers Booking Class N

PASSENGERS_BOOKING_CLASS_N

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator N

Passengers Booking Class O

PASSENGERS_BOOKING_CLASS_O

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator O

Passengers Booking Class P

PASSENGERS_BOOKING_CLASS_P

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator P

Passengers Booking Class Q

PASSENGERS_BOOKING_CLASS_Q

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Q

Passengers Booking Class R

PASSENGERS_BOOKING_CLASS_R

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator R

Passengers Booking Class S

PASSENGERS_BOOKING_CLASS_S

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator S

Passengers Booking Class T

PASSENGERS_BOOKING_CLASS_T

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator T

Passengers Booking Class U

PASSENGERS_BOOKING_CLASS_U

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator U

Passengers Booking Class V

PASSENGERS_BOOKING_CLASS_V

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator V

Passengers Booking Class W

PASSENGERS_BOOKING_CLASS_W

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator W

Passengers Booking Class X

PASSENGERS_BOOKING_CLASS_X

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator X

Passengers Booking Class Y

PASSENGERS_BOOKING_CLASS_Y

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Y

Passengers Booking Class Z

PASSENGERS_BOOKING_CLASS_Z

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Z

Passengers Booking Class Unknown

PASSENGERS_BOOKING_CLASS_UNKNOWN

NUMBER (38,0)

The number of passengers booked under Passenger Reservation Booking Designator Unknown

Passengers Booking Class First

PASSENGERS_BOOKING_CLASS_FIRST

NUMBER (38,0)

Actual total first class bookings from GDS system

Passengers Booking Class Business

PASSENGERS_BOOKING_CLASS_BUSINESS

NUMBER (38,0)

Actual total business class bookings from GDS system

Passengers Booking Class Premium Economy

PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY

NUMBER (38,0)

Actual total premium economy bookings from GDS system

Passengers Booking Class Economy

PASSENGERS_BOOKING_CLASS_ECONOMY

NUMBER (38,0)

Actual total economy class bookings from GDS system

Passengers Booking Class Discount Economy

PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY

NUMBER (38,0)

Actual total discount economy bookings from GDS system

Passengers Total

PASSENGERS_TOTAL

NUMBER (38,0)

Actual total bookings from GDS system

Adjusted Booking ID

 

ADJUSTED_BOOKING_ID

 

VARCHAR (16777216)

ID that allows cross reference to segment view data

Load Factor View

Field Name

Name in Database

Type

Description

Travel Month

TRAVEL_MONTH

DATE

The month of passenger travel

Operating Carrier

OPERATING_CARRIER

VARCHAR (16777216)

Operating Airline Code for the leg

Scheduled Departure Airport IATA

SCHEDULED_DEPARTURE_AIRPORT_IATA

VARCHAR (16777216)

Departure airport code

Scheduled Departure City IATA

SCHEDULED_DEPARTURE_CITY_IATA

VARCHAR (16777216)

Departure city code

Scheduled Departure Country IATA

SCHEDULED_DEPARTURE_COUNTRY_IATA

VARCHAR (16777216)

Departure country code

Scheduled Arrival Airport IATA

SCHEDULED_ARRIVAL_AIRPORT_IATA

VARCHAR (16777216)

Arrival airport code

Scheduled Arrival City IATA

SCHEDULED_ARRIVAL_CITY_IATA

VARCHAR (16777216)

Arrival city code

Scheduled Arrival Country IATA

SCHEDULED_ARRIVAL_COUNTRY_IATA

VARCHAR (16777216)

Arrival country code

Great Circle Distance Miles

GREAT_CIRCLE_DISTANCE_MILES

FLOAT

Great Circle Distance for the Leg

Passengers Total

PASSENGERS_TOTAL

NUMBER (38,0)

Actual total bookings from GDS system

Capacity Total

 

CAPACITY_TOTAL

 

NUMBER (38,0)

The capacity for the carrier on this route for this travel month

Load Factor

LOAD_FACTOR

FLOAT

The Load Factor for the carrier on this route for this travel month expressed as a decimal