Field Name Description Support Table
ItinID Itinerary ID
MktID Market ID
MktCoupons Number of Coupons in the Market Get Lookup Table
Year Year
Quarter Quarter (1-4) Get Lookup Table
OriginAirportID Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. Get Lookup Table
OriginAirportSeqID Origin Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. Get Lookup Table
OriginCityMarketID Origin Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. Get Lookup Table
Origin Origin Airport Code Get Lookup Table
OriginCountry Origin Airport, Country Code
OriginStateFips Origin Airport, State FIPS Code Get Lookup Table
OriginState Origin Airport, State Code Get Lookup Table
OriginStateName Origin State Name
OriginWac Origin Airport, World Area Code Get Lookup Table
DestAirportID Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. Get Lookup Table
DestAirportSeqID Destination Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. Get Lookup Table
DestCityMarketID Destination Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. Get Lookup Table
Dest Destination Airport Code Get Lookup Table
DestCountry Destination Airport, Country Code
DestStateFips Destination Airport, State FIPS Code Get Lookup Table
DestState Destination Airport, State Code Get Lookup Table
DestStateName Destination State Name
DestWac Destination Airport, World Area Code Get Lookup Table
AirportGroup Airport Group
WacGroup World Area Code Group
TkCarrierChange Ticketing Carrier Change Indicator (1=Yes) Get Lookup Table
TkCarrierGroup Ticketing Carrier Group
OpCarrierChange Operating Carrier Change Indicator (1=Yes) Get Lookup Table
OpCarrierGroup Operating Carrier Group
RPCarrier Reporting Carrier Code Get Lookup Table
TkCarrier Ticketing Carrier Code for On-line Itineraries (otherwise equal to 99) Get Lookup Table
OpCarrier Operating Carrier Code for On-line Itineraries (otherwise equals to 99) Get Lookup Table
BulkFare Bulk Fare Indicator (1=Yes) Get Lookup Table
Passengers Number of Passengers
MktFare Market Fare (ItinYield*MktMilesFlown)
MktDistance Market Distance (Including Ground Transport)
MktDistanceGroup Distance Group, in 500 Mile Intervals Get Lookup Table
MktMilesFlown Market Miles Flown (Track Miles)
NonStopMiles Non-Stop Market Miles (Using Radian Measure)
ItinGeoType Itinerary Geography Type Get Lookup Table
MktGeoType Market Geography Type Get Lookup Table
