| Field Name | Description |
|---|
| ItinID | Itinerary ID | |
| MktID | Market ID | |
| GateID | If market includes international | |
| MktCoupons | Number of Coupons in the Market | |
| RpYear | Reporting YeaR | |
| RpQuarter | Reporting Quarter (1-4) | |
| RpMonth | Reporting Month (1-12) | |
| SchFlYear | Scheduled flight year of first coupon on the market. "Scheduled" as ticket was sold.
. | |
| SchFlQuarter | Scheduled flight quarter of first coupon on the market. "Scheduled" as ticket was sold.
| |
| SchFlMonth | Scheduled month year of first coupon on the market. "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 | |
| AirportGroup | Airport Group | |
| WacGroup | World Area Code Group | |
| DwellTimeGroup | Dwell Time Group | |
| SegmentViaGroup | Segment Via Group | |
| RpCarrierAirlineID | Reporting Carrier ID | |
| RpCarrier | Reporting Carrier Code | |
| IssuingCarrierAirlineID | Issuing Carrier ID
| |
| IssuingCarrier | Issuing Carrier Code | |
| MktCarrierAirlineID | Marketing Carrier ID
| |
| MktCarrier | Marketing Carrier Code | |
| MktCarrierGroup | Marketing Carrier Group
| |
| MktCarrierChange | Marketing Carrier Change Indicator (1=Yes) | |
| OpCarrierAirlineID | Operating Carrier ID | |
| OpCarrier | Operating Carrier Code for On-line Itineraries (otherwise equals to 99) | |
| OpCarrierGroup | Operating Carrier Group
| |
| OpCarrierChange | Operating Carrier Change Indicator (1=Yes) | |
| Passengers | Number of Passengers | |
| MktAmout | Gross total of funds collected on a ticket by the Issuing Carrier for the transportation of a passenger, inclusive of taxes and fees imposed by non-carrier entities or air carriers | |
| MktTax | Market tax amount applied | |
| V_Yield | Verified Market Yield | |
| PurchaseWindowGroup | Purchase Window Group | |
| TotalDistance | Market Distance (Including Ground Transport) | |
| MilesTraveled | Itinerary Miles Traveled (Track Miles) | |
| NonStop | Code flag indicating a nonstop market | |
| NonStopMiles | Non-Stop Market Miles (Using Radian Measure) | |
| MktDistanceGroup | Distance Group, in 500 Mile Intervals | |
| MktGeoType | Marekt Geography Type | |
| ItinGeoType | Itinerary Geography Type | |
| BreakLegacyLogic | Code flag as on if legacy logic break matches new logic break | |
