Field Name Description Support Table
ItinID Itinerary ID
MktID Market ID
SegmentID In international travel, the port where customs clearance takes place
SeqNum Coupon Sequence Number
RpYear Reporting YeaR
RpQuarter Reporting Quarter (1-4)
RpMonth Reporting Month (1-12)
SchFlYear Scheduled flight year of segment. "Scheduled" as ticket was sold.
SchFlQuarter Scheduled flight quarter of segment. "Scheduled" as ticket was sold.
SchFlMonth Scheduled month year of segment. "Scheduled" as ticket was sold.
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.
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.
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.
Origin Origin airport code. A three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can change o
OriginCountry Origin Airport, Country
OriginStateFips Origin Airport, State FIPS
OriginState Origin Airport, State
OriginStateName Origin State Name
OriginWac Origin Airport, World Area Code. Numeric codes used to identify geopolitical areas such as countries, states (U.S.), provinces (Canada), and territories or possessions of certain countries. The codes are used within the various data banks maintained
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.
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.
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.
Dest Destination airport code. A three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can ch
DestCountry Destination Airport, Country
DestStateFips Destination Airport, State FIPS
DestState Destination Airport, State
DestStateName Destination State Name
DestWac Destination Airport, World Area Code. Numeric codes used to identify geopolitical areas such as countries, states (U.S.), provinces (Canada), and territories or possessions of certain countries. The codes are used within the various data banks mainta
RpCarrierAirlineID Reporting Carrier ID
RpCarrier Reporting Carrier Code
IssuingCarrierAirlineID Issuing Carrier ID
IssuingCarrier Issuing Carrier Code
MktCarrierAirlineID Marketing Carrier ID
MktCarrier Marketing Carrier Code for On-line Itineraries (otherwise equal to 99)
OpCarrierAirlineID Operating Carrier ID
OpCarrier Operating Carrier Code for On-line Itineraries (otherwise equals to 99)
Passengers Number of Passengers
SegDistance Individual segments distances and update mkt_distance and seg_distance names
DistanceGroup Distance group
ItinGeoType Itinerary Geography Type
