| Field Name | Description |
|---|
| 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 | |
