|
|
|
Glossary of Data Terms
Additional Amount Paid / Amount Credited — For exchanged tickets you will see the original ticket cost and then any additional expenses that were incurred or refunded to the traveler when there was a ticket exchange. This will be the difference between the original ticket amount and the new ticket amount.
Additional Reporting Fields — Refers to a company's Custom Data Fields, if a Travel Manager has elected to create new fields
Airline PNR Number — Passenger Name Record: A booked reservation
Air Purchase Window — The number of days prior to the initial date of air travel that a flight is purchased
Airline — These are the Airlines that were used for your company travel
Alternative Airport Missed Savings —
Associated with Alternate Airports policy. Defines the cost ($) that could have been saved if alternate airports would have been selected for a given trip.
Alternative Airport Savings —
Associated with Alternate Airports policy. Defines the cost savings ($) reached with the selection of an alternative airport versus the primary airport.
Amount Lost — The difference between the original ticket cost and a refund
Amount Refunded — The amount that was refunded. There might be full refunds or partial refunds depending on the ticket type.
ARC Reconciliation Date — The date a transaction is reconciled with the Airlines Reporting Corporation (ARC), which may be different by a few days from the actual date the reservation was made by an agent. The ARC week closes at midnight each Sunday.
Attendee Group — The current attendee group associated with the traveler.
Average Gross Bookings per Segment — Gross bookings divided by the number of segments
Average Nightly Rate / Average Rate per Night / Average Daily Rate / Average Rate per Day — The Total Hotel Base Cost divided by Total Nights or the Total Car Company Base Cost, divided by Total Rental Days
Average Stay — Sum of Total Nights divided by Total Rooms
Average Ticket Price — The Total Ticket Spend divided by the number of tickets sold. Refers to the average price paid per ticket for flights booked by a company, whether it's for all air purchases made through Egencia, for a specific airline or for a specific city pair
Car Type — The class or car that a traveler rented. Note that for Agency Cars, if the traveler changed the car class at pick up time, Expedia will not be notified of any additional charges
Cancellation Fees / Cancellation Penalty — Fees charged by an airline, hotel or other service provider for cancellations of planned / reserved travel
Change Fees — Fees charged by an airline, hotel or other service provider for changes made to planned / reserved travel
Check-In Date — Date of check-in to a hotel
Check-Out Date — Date of check-out from a hotel
City — The city and state where a traveler stayed
City Pairs — The Air City Origin and Air City Destination mappings
Class of Service — The class of service as specified by the Airline. Note that class of services differ across Airlines and are not determined by Expedia
Comparison Origin — Associated with Alternate Airports policy. This displays the airport or metro code that is associated with the origin airport.
Comparison Destination — Associated with Alternate Airports policy. This displays the airport or metro code that is associated with the destination airport.
Confirmation Number / Ticket Number — This can be found on reports that Agents booked for inventory that could not be sold through Expedia at this time. You can find such reports under Special Request Reporting. Sometimes the value may be blank as the third party vendor did not provide this to us
Days Advance Purchase — The number of days between the purchase date and the travel start date
Department — The name of the department that the traveler was associated with at the time of making the purchase. Travelers are not tied to a department — departmental information is selected on the billing and delivery page at the time of purchase. If no department codes are set up, then all travelers will be mapped to an "unassigned" group.
Destination — The airport of the arrival flight
Domestic — Domestic flight. Domestic, as defined by the Airline Reporting Corporation (ARC), is travel within the 50 United States. Everything else is International.
Effective Date — For online reservations, the Effective Date is the date the transaction was made online. If the reservation is made via an agent, then the Effective Date is the date the transaction is reconciled with the Airlines Reporting Corporation (ARC), which may be different by a few days from the actual date the reservation was made by an agent.
Exchange Date — The date that a ticket was exchanged
Expedia Low Fare — The lowest fare found overall at the time of search. This might be an out-of-policy setting, but will show you the prices that Expedia could have offered
Expiration Date — The date an unused air e-ticket expires or is no longer usable for travel
Fare Class — The class of service as determined by the airline
Fare Taken / Negotiated Fare — The fare that was paid for a company-negotiated contract ticket
Fare Type — The type of fare that your travelers used. This includes: company-negotiated fares, published fares or Expedia low fares, etc...
Gross Bookings — Total bookings for travel
Hotel — This is the hotel name of where travelers stayed
Issue Date — The date an air ticket was issued for or sent to its user
Itinerary Number — The Expedia Itinerary number that relates to a travelers booked travel
International — International flight. International, as defined by the Airline Reporting Corporation (ARC), is any travel outside of the 50 United States.
Lowest Comparison Fare — Associated with Alternate Airports policy. The lowest fare associated with the trip taking into account all possible alternate airport fares.
Lowest Logical Comparison Fare — If you have a primary airport configured, this will compare purchased fare against the against lowest logical fare for that airport. See also: (Lowest Logical Fare below.)
Lowest Logical Fare — The Lowest Logical Fare is the lowest in-policy fare matching your Reasonable Flight settings. This takes into account company policy settings, departure time windows (number of minutes before or after the traveler-specified departure time that travelers should consider), maximum trip duration, and a maximum number of connections.
Market Share — Airline market share based on number of tickets sold
Meeting — The meeting name associated with the travel transaction being reported.
Missed Savings — Ticket cost minus Expedia Low Fare
Multi-Leg — A trip with multiple destinations. This does not refer to layovers or connections, which are not broken out separately.
Negotiated Savings — How much a company can save with their negotiated rates in comparison to full published fares
One-Way — A trip with one destination but no return flight scheduled within the same itinerary
Origin — Airport of the outbound flight
Original Transaction Cost — Original transaction/ticket cost before an exchange occurred
Partial Refunds — The original cost of a ticket/reservation minus any change fee or penalty
Passenger — Traveler
Penalties — An airline penalty amount that may be charged when an exchange takes place
Percent of Total Tickets (%) — The percentage of tickets bought within a particular advance purchase window
PFC or PFCS — Passenger Facility Charge, a fee that is added to your ticket price for using a particular facility (airport)
Pick-Up Date — The date that a car was picked up from a car rental company
Pick-Up Location — The city and state where reserved cars were picked up
PNR or PNR Locator — Passenger Name Record: A booked reservation
Post-Purchase Activity — A "yes" or "no" value for Post-Purchase Activity will denote whether or not any action (change, transfer, cancellation, etc) has been taken on a given item since its original purchase date.
Published Fare — The Equivalent Published/Undiscounted Rate to the negotiated rate, including taxes (segment tax, PFCS, U.S. tax, surcharges, AY tax, etc)
Purchase Date — The date that the transaction was made on Egencia
Rate per Reservation — Average rate paid per entire car rental, as shown for a specific car vendor and rental location
Reason Code — If policy has been set up by the Travel Manager, travelers select a Reason Code (special exception) to explain any travel arranged that is arranged out-of-policy. The Travel Manager can sets up the Reason Codes.
Refund Date — The date that a ticket was refunded
Reservations — Total number of car rentals booked by a company, as shown for all car rentals purchased through Egencia or for a specific car vendor and rental location
Round Trip — A trip with a single destination and a departing and return flight within the same itinerary
Routing — The legs of an air trip that a traveler will be flying. Note that for Domestic flights if there is a stopover greater than 4 hours, then the end route will be the one that the traveler is at for that time, whereas the delay is greater than 12 hours for International
Segments — The number of segments associated with a city pair
Ticket — Refers to a single ticket associated with a single traveler
Ticket Cost — The ticket price that was paid and includes Airline service fees and taxes
Ticketing Airline — Air carrier on which travel was purchased
Ticket Number — The number assigned your air ticket
Tickets / Air Tickets — The number of tickets sold during a period of time
Total Air Spend — The Total Air Spend over a given period of time. It will not include cancellation fees.
Total Car Spend / Total Hotel Spend — Hotel or car base cost minus taxes and fees. The reason that we show base cost on the reports is that for Agency hotels and cars we will not know the taxes and fees. These are only attached to total cost at checkout or drop off.
Total Cost — Total Cost is the sum of transactions by spend
Total Nights / Total Days Reserved — Total amount of nights that travelers in the company stayed at a particular hotel, or total number of days that a car was rented for
Total Rentals — Total number of cars that were rented over a given period of time
Total Rooms — Total amount of rooms that travelers in the company stayed at a particular hotel
Total Spend — Total amount spent by the company; may refer to total spending on air, hotel or car, or all three together depending on context
Transactions — Refers to a single purchase occurring on the site or through a Corporate Travel Agent whether it be air, hotel, car rental, etc. (See also Original Transaction Cost.)
Transaction Date — The Transaction Date is the date an action occurred on an itinerary (air, hotel, car): Purchase Date, Exchange Date, Cancellation Date, Refund Date.
Transaction Type — The type of action applied to an airline ticket, e.g. Purchase, Exchange, Refund, Partial Refund, Reservation, Cancellation, etc.
Travel Date — Start date of travel
Traveler — Name of the traveler that travel was purchased for
Vendor — The selling company of goods or services
|
