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) |
The number of passengers booked in first class. |
|
Passengers Booking Class Business |
PASSENGERS_BOOKING_CLASS_BUSINESS |
NUMBER (38,0) |
The number of passengers booked in business class. |
|
Passengers Booking Class Premium Economy |
PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in premium economy class. |
|
Passengers Booking Class Economy |
PASSENGERS_BOOKING_CLASS_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in economy class. |
|
Passengers Booking Class Discount Economy |
PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in discount economy. |
|
Passengers Total |
PASSENGERS_TOTAL |
NUMBER (38,0) |
The total number of passengers booked. |
|
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) |
The number of passengers booked in first class. |
|
Passengers Booking Class Business |
PASSENGERS_BOOKING_CLASS_BUSINESS |
NUMBER (38,0) |
The number of passengers booked in business class. |
|
Passengers Booking Class Premium Economy |
PASSENGERS_BOOKING_CLASS_PREMIUM_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in premium economy class. |
|
Passengers Booking Class Economy |
PASSENGERS_BOOKING_CLASS_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in economy class. |
|
Passengers Booking Class Discount Economy |
PASSENGERS_BOOKING_CLASS_DISCOUNT_ECONOMY |
NUMBER (38,0) |
The number of passengers booked in discount economy. |
|
Passengers Total |
PASSENGERS_TOTAL |
NUMBER (38,0) |
The total number of passengers booked. |
|
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) |
Total passengers booked |
|
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 |