Field Name Description Support Table
ItinID Itinerary ID
MktID Market ID
SeqNum Coupon Sequence Number
Coupons Number of Coupons in the Itinerary Get Lookup Table
Year Year
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
Quarter Quarter (1-4) 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
Break Trip Break Code Get Lookup Table
CouponType Coupon Type Code Get Lookup Table
TkCarrier Ticketing Carrier Code Get Lookup Table
OpCarrier Operating Carrier Code Get Lookup Table
RPCarrier Reporting Carrier Code Get Lookup Table
Passengers Number of Passengers
FareClass Fare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis. Get Lookup Table
Distance Coupon Distance
DistanceGroup Distance Group, in 500 Mile Intervals Get Lookup Table
Gateway Gateway Indicator (1=Yes) Get Lookup Table
ItinGeoType Itinerary Geography Type Get Lookup Table
CouponGeoType Coupon Geography Type Get Lookup Table
