Field Name Description Support Table
ItinID Itinerary ID
MktID Market ID
SeqNum Coupon Sequence Number
Coupons Number of Coupons in the Itinerary
RpYear Reporting YeaR
RpQuarter Reporting Quarter (1-4)
RpMonth Reporting Month (1-12)
SchFlYear Scheduled flight year of first segment on the coupon. "Scheduled" as ticket was sold.
SchFlQuarter Scheduled flight quarter of first segment on the coupon. "Scheduled" as ticket was sold.
SchFlMonth Scheduled month year of first segment on the coupon. "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
DwellTime Dwell time minutes at destination. Dwell Time means scheduled elapsed time (in minutes) between each ticketed coupon. Dwell Time is not required to be reported at Via Airport stops.
Viapoint Via Point Group
RpCarrierAirlineID Reporting Carrier ID
RpCarrier Reporting Carrier Code
IssuingCarrier Issuing Carrier Code
IssuingCarrierAirlineID Issuing Carrier ID
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
TotalDistance Market Distance (Including Ground Transport)
MilesTraveled Itinerary Miles Traveled (Track Miles)
NonStopMiles Non-Stop Market Miles (Using Radian Measure)
DistanceGroup Distance group
CouponGeoType Coupon Geography Type
TripBreak DB1B trip break logic
TripBreakProvisional Provisional OD40 trip break logic
CouponType Coupon Type
ItinGeoType Itinerary Geography Type
Gateway In international travel, the port where customs clearance takes place. Binary for coupon that has an international/domestic points. Left or arrived US
