Field Name Description Support Table
ItinID Itinerary ID
Coupons Number of Coupons in the Itinerary Get Lookup Table
Year Year
Quarter Quarter (1-4) Get Lookup Table
Origin Origin Airport Code 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
OriginCountry Origin Airport, Country
OriginStateFips Origin Airport, State FIPS Get Lookup Table
OriginState Origin Airport, State Get Lookup Table
OriginStateName Origin State Name
OriginWac Origin Airport, World Area Code Get Lookup Table
RoundTrip Round Trip Indicator (1=Yes) Get Lookup Table
OnLine Single Carrier Indicator (1=Yes) Get Lookup Table
DollarCred Dollar Credibility Indicator Get Lookup Table
FarePerMile Itinerary Fare Per Miles Flown in Dollars (ItinFare/MilesFlown).
RPCarrier Reporting Carrier Get Lookup Table
Passengers Number of Passengers
ItinFare Itinerary Fare Per Person
BulkFare Bulk Fare Indicator (1=Yes) Get Lookup Table
Distance Itinerary Distance (Including Ground Transport)
DistanceGroup Distance Group, in 500 Mile Intervals Get Lookup Table
MilesFlown Itinerary Miles Flown (Track Miles)
ItinGeoType Itinerary Geography Type Get Lookup Table
