Michael Isr

Product Features and Overview

Sales Data Exchange Product • Uses ATPCO core competence of data collection and distribution to gather sales transactions globally and output a single file per day to the customer – Economies of scale – Leveraging industry solutions – Reliability of data processing – Neutrality 2

ATPCO Collection and Distribution • Avoids...

3

ATPCO Collection and Distribution • Promotes...

4

Data Features • • • • • • • • •

Record 01: Core sales elements (e.g., agency code, date of sale) Record 02: Marketing elements (e.g., time of booking) Record 03: Ticket face data (e.g., fare, taxes, total) Record 04: Financial information (e.g., fare numeric, commissions, tax) Record 05: Coupon information (e.g., board, off, flight numbers) Record 07: Form of Payment details (e.g., credit card number) Record 08: Fare Calculation Area Record 09: Exchange ticket details (e.g., Original Issue place, date, agency) Structures also built for – Record 15/16: Miscellaneous Document – Record 80/81/82: Structured fare calculation data – Record 30/32: Net information from BSP

5

Sales Data Value-Added Features • The following additional value-added features are available through the ATPCO Sales Data Exchange – – – – – – – 6

Centralized codeshare Net data removal on bilateral instruction Filtering of file to match output requirement Credit Card BIN processing File copy Duplicate ticket removal Backup recovery for up to 45 days

Sales Data Exchange Summary • Robust and efficient daily process for collection and distribution of sales information • ATPCO value-added features within the sales data exchange to promote reliability and accuracy • Comprises TCN and BSP data handling (ISR) • Access to other value added services as a “onestop shop”

7

Market Trends

Market Statistics • 101 Sales Data Exchange customers – – – –

36 ISR customers 4 credit card companies 2 rail companies 95 airline companies

• 550 million TCNs processed in last 12 months, of which – 23 million TCNs codeshared – 10 million credit card bin processed items – 124 million ISR records output

9

Market Trends • 35 of the top 50 passenger carrying airlines by volume are ATPCO sales data exchange customers • Over 80% of the total sales volume of these customers is processed through the exchange

10

Data Distribution Channels

Direct Airline Reservations TCN 10%

Direct Airline Reservations ET 6%

GDS 65%

Direct Airline Reservations Hosted 19%

11

ISR Users

ISR Customers STAR SkyTeam oneworld Non-Alliance

12

14 3 3 16

Total Members 21 10 11 -

% 67 30 27 -

Market Development • • • • •

13

Remaining large carriers not yet customers Any carrier in top 250 who interlines Remaining BSP transactions ARC transactions Electronic tickets....?

Market Growth Summary • •

• • •

Net increase in customers of 10% in last 12 months Total volume output has decreased year on year by around 10% reflecting greater focus on interline transactions Huge increase in ISR in the second year of operation (450%) BSP transactions starting to flow through exchange Anticipated room for sustained growth from – BSP and ARC transactions – New small- to mid-sized carriers

•

14

Product provides value for much smaller carriers than first group

120

100

80

60

40

20

0 2000

2001

2002

2003

2004

2005

Sales Data Exchange Customers ISR Customers BSP Data Suppliers

2006

The Industry Sales Record

ISR Product Description The Industry Sales Record is a robust sales data feed incorporating TCN, BSP, and ARC data into one consolidated record, which is virtually the same as the existing TCN format

16

Industry Sales Record Flow TCN 1300 daily Note that ‘n’ is defined number of days per plating carrier and country of sale, allowing flexibility between maximum data matching and minimum data delay

BSP 1300 daily CAT 1300 daily 17

C O D E S H A R E P R O C E S S I N G

Does the form number indicate agency stock?

YES

NO Is the plating carrier and country code on the ISR hold table?

YES

NO

Is the first flight date within ‘n’ days?

YES

NO Set release date to table defined (+0 to +6) Check for match on:

Match (BSP/ARC/TCN)

TDNR CDGT AGTN

Set release date to immediate (+0)

ISR DATABASE

No Match (BSP/ARC only) Date Expired (TCN only)

ISR File Created

Industry Sales Record Benefits • Single file format • Centralized data processing by ATPCO once for the industry • Consolidates the different sources of ticket data into one transaction • Automatically copies and distributes to all codeshare partners that require receiving the transaction • Consolidation of sale and cancel information into one transaction • Enables 100% First & Final™ automated interline billing

18

Achieving the Benefits • To receive these benefits you need to 1. Transmit all BSP to ATPCO (and ARC when available) 2. Transmit all direct sales to ATPCO 3. Talk to your interline partners about ISR 4. Test ISR file to align systems

19

ISR and TCN Formats • The following differences apply for TCN-created ISR transactions – Application ID (APID) – Data Foundation (FNDT) – Sale Cancel Indicators

• The following differences apply for BSP-created ISR transactions – – – – 20

Ticketing Airline Code (TACN) ISO Country Code (ISOC) System Provider Code (SASI) Record 30 and 32

ISR: Common Misconceptions “My sales data will be held beyond its useful lifespan”

Sales data is held only if there is the possibility for a BSP/ARC match and only as long as you wish – Only if the ticket is agency stock (by form code) – Only if the ticket is plated on a carrier supplying daily BSP (by plating carrier in TDNR) – Only if the ticket is sold in a country where daily BSP is being supplied (by first 3 positions of AGTN) – Only if the first flight date is beyond the hold period

Only if all of these criteria are met will the TCN be held 21

ISR: Common Misconceptions “ISR is a different format from TCN and requires significant system changes” The only change required is in the header (APID = ‘ISR’); all other changes used existing filler Allows you to receive TCN immediately and develop to your own timescale to take advantage of other data fields When you are ready, you can elect to receive new BSPonly Records 30 and 32 including net information 22

ISR: Common Misconceptions “Until other carriers join ISR, the benefits are small” Immediate benefits from switching to ISR today include – Processing efficiencies like duplicate removal across files – Sale and Cancel merge – BSP data is already being supplied and distributed multilaterally to existing ISR customers leading to improved coverage of sales data

More benefits will accrue as more carriers join the ISR with no additional cost

23

ISR: Common Misconceptions “Sending BSP data involves a major effort by the providing carrier” There are three ways to send your BSP to ATPCO – Direct to ATPCO from your carrier systems (7 carriers today) – Instruct iiNet to copy the file to ATPCO (2 carriers today) – Instruct the individual DPC to forward the file to ATPCO

Depending upon carrier preference, these files can be – Zipped or unzipped – Concatenated or separated by country

24

What To Do Now • ATPCO recommends that each airline – Sign the ISR contract (nothing changes until you are ready) • No volume = No charge if you are not an existing customer

– Take a test file based on your existing TCN for comparison – Document your daily BSP/ARC files – Supply a BSP file for testing so that you can evaluate the format of all types of ISR • TCN only • BSP/ARC only • TCN/BSP/ARC merge 25

Sales Data Utopia [noun] ideally perfect state...ideas which could be/are considered able to radically change our world are often called Utopian ideas. •

Every customer supplies – 100% of your direct reservation data to ATPCO, addressed to marketing carriers in the itinerary – 100% of your BSP data – 100% of your ARC data (when available) – Regularly updated codeshares for operating and marketing carriers – Justification to their top interline partners on the joint benefits of ISR

•

Every customer receives – All GDS TCN available through ATPCO – ISR to enable BSP and ARC distribution – Neutrally prorated results to enable First & Final™ relationships

•

Every customer allows – Data file to be transmitted to ARC for use in post-sales processing only

26