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