ARC Travel Demand Glossary

ARC Travel Demand Glossary

ARC Travel Demand pulls from the world’s most comprehensive source of global air travel intelligence. Global coverage spans flights from more than 4,600 airports in 234 countries and territories.

This product provides a clear view of daily air travel purchases, cancellations and departure dates for passengers traveling from/to specific countries or airport destinations, as well as a daily breakdown of air travel volume and total fares paid by point-of-sale country, class of service and stop-over destination airports.

Term

Element Name

Example

Definition

TRANSACTION TYPE

Transaction Code

E, I, R

A code that identifies the type of transaction

E = Exchanges

I = Issued

R = Refunds

DATA SOURCE CHANNEL

Data Source Code

1, 2, 3, 4

1 = ASP

2 = DIR

3 = BSP

4 = IND

LOAD DATE

Load Time Stamp

2020-06-23

Load date of the transactions in the ARC systems

Format: YYYY-MM-DD

DATE OF ISSUE

Date of Issue

2020-06-23

Date when the ticket was issued

Format: YYYY-MM-DD

DATE OF DEPARTURE

Flight Date

2020-07-30

The scheduled date of departure

Format: YYYY-MM-DD

FARE TOTAL

Regressed Fares

764.35

The sum of total fares based on multiplying each ticket fare by the Random Factor

CABIN CLASS

Aggregated by Cabin based on Reservation Booking Designator (Individual Airline RBKD)

Aggregated by Cabin

Using IATA Resolution 728 mappings, the following service class categories are applicable: First-F, Business-C, Economy-Y, Discount Economy-DY, All Others-AO

POINT OF SALE COUNTRY CODE

ISO Country Code

US

The two-letter country code for the origin of ticket issuance

ORIGIN COUNTRY NAME

Origin Country Name

United States

The country name for the origin of the travel segment

DESTINATION COUNTRY NAME

Destination Country Name

Brazil

The country name for the destination of the travel segment

ORIGIN AIRPORT CODE

Origin Airport Code

LAX

The origin airport code for the origin of the travel segment

DESTINATION AIRPORT CODE

Destination Airport Code

JFK

The destination airport code for the destination of the travel segment

TRUEOD

True OD

JFKLHR

Origin-Destination pair based on stop-over of the itinerary derived based time on ground logic

SEGMENT PAX COUNT

Sum of Segment Coupons

527

The count of travel / passenger segments

Notes:

  • Data Level: Data is aggregated at the segment level, with the option to roll up on other dimensions.
  • ARUNK: Surface segments (Arrival Unknown) are excluded from the dataset population.
  • Data Load: Data is loaded based on the load date of the transactions in ARC systems.
  • Pax Total: To find the net count of passenger segments between two airports, one needs to net out refunds based on specific departure date/dates. Using the transaction code, the following logic can be applied (e.g., Issued+Exchanges-Refund (I+E-R)).
  • Fare Total: To find the net fare total between two airports on a specific departure date, special logic does not need to be applied, since refunds are stored with a negative value. Simply, add all fare values together (e.g., I+E+R).