| Field Name | Description |
|---|
| ItinID | Itinerary ID | |
| 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 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 | |
| AirportGroupString | Airport Group | |
| DwellTimeGroup | Dwell Time Group | |
| RoundTrip | Round Trip Indicator (1=Yes) | |
| RpCarrierAirlineID | Reporting Carrier ID | |
| RpCarrier | Reporting Carrier Code | |
| IssuingCarrierAirlineID | Issuing Carrier ID
| |
| IssuingCarrier | Issuing Carrier Code | |
| MktCarrierGroupString | Marketing Carrier Group String | |
| OpCarrierGroupString | Operating Carrier Group String | |
| OnLine | Single Carrier Indicator (1=Yes) | |
| Passengers | Number of Passengers | |
| ItinYield | Itinery fare per itinerary miles flown. The itinerary includes all segments of a journey form origin to destination. | |
| TotalAmount | 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 | |
| TaxAmount | All aggregated taxes and fees imposed by the U.S. or a foreign government, such as, but not limited to, Federal excise taxes, flight segment taxes, U.S. passenger facility surcharges, September 11 security fees, U.S. or international departure and ar | |
| DollarCred | Dollar Credibility Indicator | |
| PurchaseWindowGroup | Purchase Window Group | |
| TotalDistance | Itinerary Distance (Including Ground Transport) | |
| MilesTraveled | Itinerary Miles Traveled (Track Miles) | |
| GroundDistance | Ticketed and unticketed ground segment distances | |
| DistanceGroup | Distance Group, in 500 Mile Intervals | |
| ItinGeoType | Itinerary Geography Type | |
| BreakLegacyLogic | Code flag as on if legacy logic break matches new logic break | |
