Docstoc

Untitled - ATPCO

Document Sample
Untitled - ATPCO Powered By Docstoc
					1
      S l Data E h
ATPCO Sales D t Exchange

         Annual Forum
    Data Subscriber Session
          0900 – 1200
       12 October 2009
                    General Housekeeping

• General administration
• Breaks
• Introductions
    –   Name
    –       p y
        Company
    –   Business area
    –   Main objective for today




3
                 Corporate Mission

• Lead the airline industry in defining
  standards and implementing industry
  solutions
• Collect and distribute airline fare-related
  data reliably and efficiently
  data,
• Provide products and services that reduce
  distribution costs and protect or increase
  airline revenue

4
                       ATPCO Business Model

Decentralized Collection & Distribution   ATPCO Collection & Distribution


                                                                
                                                                
                                                                
                                                        
                                                                
                                                                
                                                                




5
                   Industry Solutions

• Building solutions using ATPCO as an
  industry provider
    – Delivers benefit to whole community
    – Provides and maintains one solution
    – Shares best practice through industry
      knowledge
• Eliminates duplicate builds


6
Sales Data Exchange
S l D t E h


  Setting the Scene
                                 Agenda

                                       g
    – Overview of the Sales Data Exchange
    – Optimizing the value of the data
       • Maximize throughput
       • Maximize content
       • Leveraging value-added products with your sales data
    – Sales Data Exchange Guide
       • Current state
       • Future direction and objectives
    – Q&A
    – Session summary


8
       Sales Data Exchange History

1990   TCN launched
1996   Concept of Version 4.0 launched
2004                      3.0
       Eliminated Version 3 0
2005   First ISR Customer implemented
2006   Concept of Sales Data Exchange




9
            Sales Data Exchange History

• Purpose
     – Only source of other airline sales data
     – Faster than any other data source
     – More comprehensive data than any other
       source




10
              Sales Data Exchange History

• ATPCO role




     – Handling of large volumes of data reliably
     – Secure data transmission
       Switching l between sender and receiver
     – S it hi sales b t            d     d       i
        • One file in per supplier
        • One file out per receiver


11
                    Changing Direction

The value of the ATPCO Sales Data Exchange
has shifted from…
     – Fast data
     – Comprehensive data


to the following…
     – Centralized processing and merging
     – Neutral organization to manage and secure the
       data
     – Adding value to the sales data

12
                           ATPCO Value

• ATPCO estimates the following value to
  our customers of providing central service
     –   Central collection and distribution
     –   Codeshare generation of additional data
     –             g
         BSP/ARC generation of additional data
     –   Central consultancy to troubleshoot
     –   BSP/ARC enhanced data
     –   Single source into First &Final™ and GFS Fast Track
     –   Value-added processing


13
                         Better with ATPCO

      p                   ,y
• To optimize the benefits, you need to
     – Secure comprehensive coverage of data
     – Ensure quality of data content
     –L            l     dd d    d t
       Leverage value-added products
          • Centralized processes
          • More uses for the sales data
• At this session, you will discover
     –   How to grow your data coverage
     –   How to improve your data content
     –   Value-added products you can use
     –                     g
         Where to find the guide information

14
   Overview of the
Sales Data Exchange
           The ATPCO Sales Data Exchange

• The largest community exchanging sales
  data through one industry solution
• Increases coverage and maximizes value
  with the following
     – Inclusion of BSP and ARC data
     – Inclusion of carrier ET data
     – Central codeshare to the operating carrier
• ATPCO strategy is to incorporate all
  sources into one comprehensive and
  robust data source

16
                  Sales Data Metrics

                            140
• Currently 124 sales             Sales Data Exchange Customers
                                  ISR Customers
  data customers            120
                                  BSP Data Suppliers


• Over 500 million sales    100


  data transactions         80


  processed in last 12      60

  months                    40

• 67 providers of various   20
  f         f l d
  formats of sales data
                             0
  into the exchange


17
                 Sources of Sales Data

• Airlines receive sales data from
     – GDS companies in TCN format
     – Electronic tickets for operational purposes
     – ARC and IATA BSP settlement files

• ATPCO strategy is to incorporate all
  sources into one comprehensive and
  robust data source

18
                        Sources of Sales Data

• ATPCO Sales Data is collected from
     –   Airlines’ hosted or own direct sales systems
         Airlines
     –   Airlines or ARC/IATA sending settlement data for conversion
     –   Agency TCN data from ticketing systems
     –            d t d t data
         GNE and student d t sources

                                                        Carrier Direct Sales


                                                        Carrier BSP/ARC Sales


                                                        Agency & Host TCN


                                                        Other (Student, GNE)




19
                        Sales Data by Source

•    12 agency sales providers                Sales Data Source
     sending TCN
•    5 host providers sending direct
     sales for 52 airlines                     9%   67%
•    37 airlines sending direct sales     7%
                                                                  TCN
•    39 airlines sending BSP/ARC
                                                                  BSP
                                        17%
                                                                  ARC
                                                                  ET




20
           Sales Data Acceptance Summary

• The exchange is large and still growing
     – Customers represent 75% of flown volume
     – All major ticketing systems supply around 60% of global
       sales volumes processed
     – Many customers receiving 90-100% of their data through
       the exchange
     – 5 carriers joined the exchange in 2009
             i           t d to    in
     – 4 carriers converted t ISR i 2009
• Potential for growth to benefit community
     – 124 current customers
     – 140 carriers are not customers but use IDEC
     – Just under 1 billion sales per annum in the global market
       today


21
     Sales Data Exchange P
     S l D t E h                i
                         Processing




22
       ATPCO Collection and Distribution

  Avoids...
• Avoids




23
      ATPCO Collection and Distribution

  Promotes...
• Promotes




24
     Sales Data Daily Timeline




25
                          Key Principles

                                                g
• Three distinct formats of data into the exchange
     – TCN is addressed to all customers in the address
       label sent by the provider (carrier or GDS)
                                           g
     – BSP is addressed to the validating carrier and all
       marketing carriers in the itinerary
     – ARC is addressed to the validating carrier and all
                g                        y
       marketing carriers in the itinerary

• When the transaction is addressed to a
            carrier,
  marketing carrier ATPCO attempts to
  codeshare the transaction to the operating
  carrier


26
     The Sales Data Exchange




27
         Why Addressing Is Important

• The sender of the data has the right to
  direct where the data is sent
• Marketing carrier can agree (codeshare
  contract) to have their transaction copied
      p        g
  to operating carriers based on their own
  instruction
• ATPCO reports operating carrier counts to
              p     p       g
  the GDS senders of the data each month
  for billing purposes

28
               Addressing Example

• Key information

• Providing system is 1K
• Marketing Carriers are XX and BB
• Operating Carriers are ZZ and CC

• Only XX has TCN agreement with 1K

• Both XX and BB file code shares correctly
29
     Addressing Example




30
              Industry Sale Record (ISR)

             y                 p
• The Industry Sales Record provides a consolidated
  and comprehensive source of sales data that can be
  used throughout airline processes

• Benefits
   – Increased sales data coverage
   –C                                     f
     Comprehensive and timely revenue information.
   – Software processing efficiency saves processing
     costs
   – Supports a move to 100% First & Final ™




31
                                     ISR Options

• Inbound files
     – Who receives your ARC/BSP
• ATPCO processing
     – TCN hold period
          • Default is 6 days from date of issue
          • Receiving carrier can override by
              – Validating Carrier
                Country
              – Co ntr
• Your Industry Sales Record file
     –   Duplicate BSP and ARC data removal
     –   F       t fd t t i l d R       d
         Format of data to include Records 30 & 32
     –   Filter your data
     –   Masking credit card data


32
                                                    How ISR Works
                                Does the form number 
                                indicate agency stock?
                                                                                                                                          NO
   TCN
 1300 daily                                      Is the plating carrier 
                                   YES           and country code on                                                               NO
                                                 the ISR hold table?
Note that ‘n’ is defined 
number of days per plating 
                                                                           Is the first flight date 
carrier and country of sale,                                YES            within ‘n’ days?                                 YES
allowing flexibility between 
maximum data matching 
and minimum data delay
                                                                                  NO


                                                                     Set release date to table                              Set release date to 
   BSP                                                                  defined (+0 to +6)
                                                                        defined (+0 to +6)                                   immediate (+0)
                                                                                                                             immediate (+0)
1300 daily
                                      Check for match on:                                                   Match 
                                                                                                        (BSP/ARC/TCN)
                                             TDNR
                                                                                                   No Match (BSP/ARC 
    CAT                                      CDGT                                                        only)
                                                                                                           l )                ISR File 
                                                                                                                              ISR File
 1300 daily                                  AGTN                                                      Date Expired (TCN      Created
                                                                                                             only)

 33
                           Industry Sales Record


                                                                                 ACCOUNTING and
     DATA TYPE           OPERATIONAL                  MARKETING
                                                                                   SETTLEMENT



                                                                                     BSP – HOT
      Known As                 ET                         TCN
                                                                                     ARC – CAT




       Timing              Real Time                    Next Day                      Periodic




                   Ticket Face Information: Passenger Name, Fare Calculation, Fares, Taxes, Total
     Common Data   Form of Payment Details
                   Itinerary Details

                                                   Booking Location
                                                                               Net Remit Information
                                                   Pseudo City Code
                   Structured Fare Calculation                                Net Agency Settlement
     Unique Data                                    Time of Booking
                         Coupon Usage                                         Non-ticket Transactions
                                                    Passenger Type
                                                                                   Agency Totals
                                                      Booked RBD




34
                           Industry Sales Record


     DATA TYPE           OPERATIONAL                 MARKETING, ACCOUNTING, and SETTLEMENT




      Known As                 ET                                          ISR




       Timing              Real Time                              As Soon As Reported




                   Ticket Face Information: Passenger Name, Fare Calculation, Fares, Taxes, Total
     Common Data   Form of Payment Details
                   Itinerary Details

                                                 - Booking Location       - Net Remit Information
                                                 - Pseudo City Code       - Net Agency Settlement
                   Structured Fare Calculation
     Unique Data                                 - Time of Booking        - Non-ticket Transactions
                         Coupon Usage
                                                 - Passenger Type         - Agency Totals
                                                 - Booked RBD




35
                           Industry Sales Record


     DATA TYPE                 OPERATIONAL, MARKETING, ACCOUNTING, and SETTLEMENT




      Known As                                     ISR (To be Developed)




       Timing                                       As Soon As Reported




                   Ticket Face Information: Passenger Name, Fare Calculation, Fares, Taxes, Total
                   Form of Payment Details
                   Itinerary Details
     Common Data
                    - Structured Fare Calculation - Booking Location         - Net Remit Information
                    - Coupon Usage                - Pseudo City Code         - Net Agency Settlement
                                                  - Time of Booking          - Non-ticket Transactions
                                                  - Passenger Type           - Agency Totals
                                                  - Booked RBD




36
                       Easy To Implement

• TCN 4.05 is industry-accepted format
• Conversion from TCN to ISR
     – Same price structure
     – Same data format (filler used for BSP/ARC data)
     – Same transmission process
• The switch immediately provides
     – More data
     – Better quality settlement data
     – Ability to share BSP and ARC with your partners
• Only one change
     – Header record field (APID) switches to ‘ISR’
     – Can be implemented in matter of hours!


37
              ISR: Common Misconceptions

“ISR is a different format from TCN and requires significant system
changes”



• Actually, the only change required is in the
  header (APID = ‘ISR’); all other changes used
  existing FILLER!
• Allows you to receive like TCN immediately and
  work to take advantage of other data fields
• When you are ready, you can elect to receive
  new BSP/ARC only records 30 and 32

38
               ISR: Common Misconceptions

“Until my largest interline partners join ISR, the benefits are small”

• The majority of carriers in the exchange are already on the
  ISR format
  There are immediate benefits t b h d f
• Th        i     di t b                            it hi to
                               fit to be had from switching t ISR
  today
     – Processing efficiencies like duplicate removal across files
     – Sale and Cancel merge
     – BSP/ARC data is already being supplied and distributed
       multilaterally to existing ISR customers leading to improved
       coverage of sales data
• And more benefits will accrue as more carriers join the ISR
  and send their data with no additional cost!



39
             ISR: Common Misconceptions

“Sending BSP/ARC data involves a major effort by the providing
    i ”
carrier”

                    y          your BSP to ATPCO
• There are three ways to send y
     – Direct to ATPCO from your own system
     – Instruct iinet to copy the file to ATPCO
     – Instruct ARC to forward the file to ATPCO

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

40
              Value Add – File Processing

• File conversion and formats
     – Send your data in TCN, BSP, or ARC data
       formats and ATPCO will convert to single
       standard – the development is done so you
       don’t need to
• Backup recovery
     – Holds files for up to 45 days from initial send
       so that if your processing or recovery fails, the
       data is immediately available on request

41
                  Value Add – File Integrity

    p
• Duplicate ticket removal
     – Checks duplicates across multiple files for up to 90
       days from initial receipt to avoid the costs of
       processing the same ticket on multiple occasions
• ISR special processing
     – Cleansing the data to ensure that elements are
       standardized into one industry set of logic for creation
       of your file
• Conjunction handling
     – Ensures that conjunction tickets are held together so
       no errors occur in your processing due to poorly
       sorted conjunction tickets


42
               Value Add – Data Merging

• Sales data merging
     – Putting the same ticket together from BSP,
       ARC,
       ARC and TCN sources and using the best of
       these to give you optimum quality data for
       accounting and settlement
                 g
• Integration of cancel and sale records
     – Merging sales and cancels so you can avoid
       the transaction cost of processing sales which
       did not materialize into flown revenue

43
                         Value Add – Data Sharing

•    Private Data Masking
      – Ensure commission and other private data is not shared where you do not want it to
        be, and open your data to trusted interline partners
•    Codeshare
      – Improve coverage and accuracy of sales data for sales data sharing and proration
        purposes
        p p
•    File copy
      – Sends files to multiple locations on request recognizing that your revenue accounting
        functions may be distributed or outsourced
•                            g
     Sales data file filtering
      – Only receive the transactions that you need in your business process and avoid
        intensive filtering and unnecessary volume within your own systems
•    Credit card BIN processing
      – Allows you to address all of your data to credit card companies, and allows ATPCO to
                                file,
        allocate to the correct file resulting in better customer information and fewer charge
        backs for the airline
•    Data security including credit card masking
      – Secures your data and offers protection of personal account numbers to avoid the risk
                y        y
        of costly security breaches



44
             Summary: How the Exchange Works


• The exchange is large and growing
• The process works by taking
     –      g
         Large number of different format files
     –   Value-added processing and conversion
     –   Merging and matching of tickets
     –   Distribution in one industry standard cleansed file
         per customer
• ISR builds on using best of each format
• Value-added processing to support the
  customer
45
Maximizing Your Value
             Working Together: Sales Data

• To maximize the benefits of sales data
  exchange, the following actions need to be
  addressed
     – Maximize the coverage of sales data
     – Optimize the content of the data being received
     –L          the l      f    il bl    d t
       Leverage th value of available products

• Objective to increase the value of the
  exchange to members via a community
   pp
  approach

48
          Step 1. Maximizing Your Coverage

• To maximize the benefits of sales data
  exchange, a three-phase approach should
  be taken
     – Phase 1 – supply of direct (own office) sales data
     – Phase 2 – receiving ISR format data
     – Phase 3 – supply of BSP/ARC (agency) sales




49
             Phase 1: Carrier Direct Sales

• Three options to supply
     – Request your host provider to send for you
     – Develop feed to ATPCO
       • TCN 4.05 format addressed to your partners
       • BSP HOT format – ATPCO will address to
          – All marketing carriers
          – Operating carriers determined by ATPCO codeshare




50
             Phase 2: Receive ISR Format Data


• You will need to take the following steps
     – Sign ATPCO ISR contract
     – Ensure FTP process set up
     – Express user preferences
       •   Address (to yourself or third party processor)
       •   Days of week of receipt
       •   Masking of credit card data
       •   Inclusion of Records 30 and 32
       •   Acceptance of duplicates
       •        p
           Hold period to match yyour TCN to BSP/ARC data

51
         Phase 3: Supply BSP & ARC Data

• You will need to take the following steps
     – Advise ATPCO of your daily BSP countries
     – Either
       • Send the data from your own system
       • Request that source systems supply to ATPCO
          – iinetcare@iata.org (nominal fee)
          – chd@arccorp.com (free service)
                 y
       • Express your preferences
          – Whom you will send your BSP/ARC data to
          – Filter preferences (if you do not need the data addressed
            back to you)


52
                             Current Position

     Sales Data Customers          124

     Industry Sales Record         84       (68%)
         TCN                       40

     Direct Sales                  89       (72%)

         From Carrier              37

         From Hosted Supplier      50

         From Both Sources          2

     BSP and/or ARC                39       (31%)

         BSP                       39

         ARC                       22




53
                    Key Point

       customer,
• As a customer you need to make sure you
  have contracted with all providers so that
  they address their data to you




54
                Providers of Sales Data

• GDS
     – Agency and host data (marketing, accounting,
       and settlement)
     – Electronic ticket data (operational)
• Airlines
     – Station sales data (marketing, accounting,
       and settlement)
     – Electronic ticket data (operational)


55
                ATPCO and Data Suppliers

• GDS data
     – ATPCO has contracts on data use with GDS providers of
       data
     – Permission required when your data is sent to a third party
     – Codeshare counts reported monthly for billing
• Other TCN
     – Address label dictates who receives the ticket
     – Distribution in control of the sender
• BSP/ARC
     – ATPCO makes address label for each ticket
     – Validating carrier (sender) can specify to whom to send




56
                        Questions To Ask

• Own sales
     – Correct GDS contracts in place?
• Main interline partners
     –   Supplying direct sales?
     –              host
         If through host, do you have a contract?
     –   Supplying BSP and ARC?
     –                          non-daily?
         BSP and ARC daily or non daily?
• You the customer
     – Are you doing all of the above for your partners?

57
            Step 2. Optimize the Content

• You can optimize the content for yourself
  and your interline partners by closely
  managing the following
     – Codeshare ranges filed with ATPCO
     – Private data masking preferences




58
                     ATPCO Codeshare

• You will need to take the following steps
     – Sign an ATPCO Codeshare contract
       (marketing carrier)
     – File your marketing carrier ranges with
       ATPCO
     – Contact your marketing carrier partners and
       request that they either
         q             y
       • File their ranges with ATPCO for you as operator
       • Give you written permission to file on their behalf


59
                 ATPCO Codeshare Template




•    Key fields
      – Action Code
      – Operating Carrier
      – Marketing Carrier
      – Mkt Flt # Begin and End


60
                      Codeshare Data Sharing

               g
• The marketing carrier can share sales data with the
  operating carrier
     – Marketing carrier has a codeshare contract with ATPCO
     – Initial transaction is addressed to marketing carrier
     – Range on that flight has been filed with ATPCO


• Main issues
     – Ranges not up to date
     – Not all data being sent through the exchange
        • Direct sales that are wholly marketed on the validating carrier but actually
          operated by an interline partner
        • Some airlines not subscribing to all data through the ATPCO exchange



61
                  Private Data Masking

• ATPCO masks private data where
     – Recipient is not the validating carrier
     – Validating carrier has not elected to share the
       data element with the recipient




62
     Private Data Masking Template




63
                                Private Data Sharing

•    Net Remit Removal is designed to mask all fields below where
      – The recipient of the data is not the validating carrier of the ticket
      – The validating carrier has NOT allowed the data element to be shared with the
         recipient :
•    These fields can be shared with specified Interline partners

     AEBA Amount Entered by Agent            CORT Commission Rate

     EFCO Effective Commission Amount        SPAM Supplementary Amount

     APBC Amount Paid by Customer            COTP Commission Type 

     NTFA Net Fare Amount                    SPTP Supplementary Type

     AUTA Authorized Amount 
     AUTA Authorized Amount                  FPAM Form of Payment Amount 
                                             FPAM Form of Payment Amount

     REMT Remittance Amount                  SPRT Supplementary Rate

     COAM Commission Amount                  EFRT Effective Commission Rate

     SFAM Signed for Amount


64
         Quality of Content: Benefits to You

  Accurate, timely,
• Accurate timely and complete codeshare
     – Allows for comprehensive copying of each
       transaction to everyone who needs it
     – Allows for accurate interline settlement
• Sharing private data
     – Allow for accurate net data settlement where
       applicable



65
                            Key Information

     Private Data Masking and Codeshare can be
            addressed through templates at

        http://applications.atpco.net/extranet/html/set_formcenter.html



 In future, these will be included in the Sales
          Data Exchange Web Page

                       e mail
                       e-mail to isr@atpco.net

66
                    Step 3. Leverage
                  Value-Added Products

• The ATPCO Sales Data Exchange is the
  single source of data for the following
  products
     – First & Final™ Settlement
     – GFS Fast Track
• If you are currently a Sales Data
  Exchange customer, you could b gaining
  E h            t              ld be i i
  benefit from these industry solutions

67
             Life Cycle of the Fare with ATPCO


•    Collection of fare product data
•    Distribution of fare product data
•    Collection, processing, and
     distribution of ticketed “demand”
     data (RA)
•    Analysis of ticketed “demand” data
     (RM)




68
                               GFS Fast Track

• Why you need to know
     – You are interested in sales data
     – You now know how to maximize
         • Coverage
         • Content
     – Your revenue management colleagues have a benefit at their
       fingertips which can
         • Reduce the cost of analysis of fares to sales
           Boost revenue by right-sizing your f
         • B    t        b i ht i i                 in the  k t
                                              fares i th market
         • Track promotional initiatives
• You can use GFS Fast Track to
                 monitoring set
     – Create a “monitoring set” from your sales data
     – Match to your fares in the market if filed with ATPCO
     – Determine how well your fares are selling in the marketplace
• All for only USD 700 per month

69
                              GFS Fast Track

     GFS Fast Track matches sales to fare filings using ISR to support
                           t i targeting, monitoring, and achieving th
     revenue management in t           ti    it i       d hi i the
     intended results of their initiatives

•    Benefits
      – Allows you to monitor the effectiveness of your ATPCO fare
        filings in a single application
      – Provides key insight on the your fare filing:
            What      k t                lli the fare
          • Wh t markets (POS) are selling th f
          • What is the ticketed value (versus published fare)
          • Which fares generated new sales or caused reissues from a
            previous ticket

•    If you file your fares with ATPCO and receive sales data through
     ATPCO, GFS Fast Track provides a quick and easy solution for
     monitoring promotion and fare product results


70
           GFS Fast Track: What it Means

• Gives even more emphasis to
     – Sending 100% of your direct sales
     – Sending 100% of your BSP and ARC sales
     – Filing 100% of your fares with ATPCO


• Ask ATPCO about a free trial today!



71
           First & Final™: Why You Need to Know

• Why you need to know
     – You are interested in sales data
     – You now know how to maximize
         • Coverage
         • Content
     – Your revenue accounting colleagues have a benefit at their
       fingertips which can
         • Reduce the cost of expensive rejection and correspondence in interline
           Boost revenue by ensuring settlement i as i t d d when you fil d th
         • B    t         b       i     ttl     t is  intended h           filed the
           fare
         • Provide a consistent method of coupon pricing for online and interline
           sales

• You can use these prorate values in GFS Fast Track to
  monitor your prorate shares!


72
                       Product Components

• A single global standard
     – Sales data distribution made up of TCN, BSP-HOT, ARC-CAT,
       and the Industry Sales Record (ISR) consolidated sales data
       Sales Record selection f proration (b
     – S l R        d l ti for                  d     Include/Exclude
                                       ti (based on I l d /E l d
       criteria)
     – Neutral Fare Proration endorsed by IATA/ATA
     – Fare, Tax, ISC, and Handling Fee value verification and storage
     – Post-sales processing using ARC Compass™ data warehouse




73
                    The First & Final™ Interline Billing Service Flow

                                                     ATPCO
                                                    Interface

                                                                                                               Sales Record
                                                                                                                Selection
        Sales




                                                               Unplanned Lift
     TCN/BSP/ARC                                                                                                                        ATPCO 




                                                                                                    ult
                                                                                Unplanne Prorate Resu
                                                           s
                                     Planned Prorate Results
                                                                                                                                    Fares & Rules

                                                                                                                              NFP
 ARC COMPASS™                                                                                                                 Engine*
                                                                                       ed


                                                                                                           Fare/Tax/
                                                                                                            ISC/HF
                                                                                                          Verification
       Lift                       Carrying Airline’s                                                                                Issuing
                               Revenue Accounting DB                                                                                 Airline
       * NFP offered by ATPCO and Kale, powered by Kale’s APEX®


74
               Why choose First & Final™

          Final
• First & Final™ is
     – An industry-owned service
     – Industry neutral
     – The only dispute-free solution
• Benefits to both RM and RA
     – Cost reduction in manual processing
     – Accurate settlement of intended sector yield
       Adjustment of SPA t reflect intended fare
     – Adj t     t f SPAs to fl t i t d d f
       shares
     – Can be achieved immediately

75
            First & Final™: What it Means

• Gives even more emphasis to
     – Receiving 100% of available interline data
     – Proration of interline and online sales with
       ATPCO
     – Loading prorate values into GFS Fast Track to
       monitor how your fares were settled

  Contact i @ t     tf
• C t t aia@atpco.net for more
  information!

76
                 Key Components to Value

• Summary
     – Ensure coverage is maximized
        • Supplying your direct sales
        • Receiving ISR format
        • Supplying your BSP and ARC data
     – Ensure content is optimized
        • Codeshare
        • Private Data Masking
     – Leverage Value-Added products
        • GFS Fast Track
        • First & Final ™ Settlement

77
The ATPCO Sales Data Exchange
    System Specification and
    S t    S   ifi ti      d
     Implementation Guide
                  The Guide: Overview

• The guide is intended to give you
     – An overview of the sales data exchange
     – File layouts and data element specifications
     – Processing for special transactions
       • Voids
       • Conjunctions
     – Description of value-added processing



79
                          Sections 1-3

• Section 1: Introduction
     – Framework
          y
     – Key terms
• Section 2: Sales Data Exchange Overview
                    p
• Section 3: Data Representation
     – Data validation
     – Field and character formats
     – Date formats



80
                               Sections 4-6

• Section 4: File Structure
     – Records sent
     – Address labeling
     – File structure test files
• Section 5: ATPCO Processing
     – Processing cycle
     – ISR basics
     – Credit Card data security
• Section 6: Record Structure by Transaction
     –   Canceled tickets
     –   Refunds
     –   Conjunctions
     –   Student data processing

81
                          Sections 7-8

                      y
• Section 7: Record Layouts
     –   Data Elements
     –   Bytes
     –   M     i from BSP and ARC
         Mapping f           d
     –   Inbound and outbound file layouts
• Section 8: Record and Element Construction
     –   Conjunctions
     –   Voids
     –   Code sharing
     –   Industry Sales Record mapping and hierarchy
     –   Reporting ticketing fees

82
              Section 9: Value Added Processing

•    Covered today
      –   Codeshare
      –   Private Data Removal
      –   GFS Fast Track
      –   First & Final™ Settlement
•    Other Items
      –   Sales data file filtering
      –   File conversion and formats
      –   Sales data merging
      –   Integration of cancel and sale records
      –   ISR special processing
      –   Credit card BIN processing
      –   File copy
      –   Duplicate ticket removal
      –   Conjunction handling
      –   Backup recovery
      –   Data security including credit card masking




83
                     Section 10: Glossary

• For each data element, includes
     –   Reference to name in Section 7 (file layouts)
     –   Element name
     –   Attribute
     –   Which record it is included in
     –   Status (Mandatory or Optional)
     –   Example of data
     –   Cross edits
     –   Starting position in record
     –   Full description

84
                    Plans for the Future

• March 2010 version will include
     – Easy start guide to the Exchange
                                g
        • How to maximize coverage
        • Data sources
     – What each feature means to you (value
       statement)
     – In depth technical descriptions of processes
     – EMD SStructure
• Published on new Web page for Sales Data

85
Session W
S          U
    i Wrap-Up
              This Morning We Covered

• How the process works
• Optimizing the benefits of your data
       Maximize
     – M i i coverage
     – Quality of content
     – Leverage Value-added products
• Specifications Guide



87
                                   For You To Take Away

•    Ensure that
      – You are supplying your direct sales through ATPCO:
           •   To your interline partners
           •   To yourself
      – You are on the latest format (ISR)
                    pp y g       your BSP/ARC data
      – You are supplying all of y
      – All of your customer preferences are set to suit your business model
           •   BSP/ARC distribution
           •   Inclusion of Record 30/32
           •   Duplicate processing
      – All of your codeshare ranges are filed and up to date for your carrier as
           •   Marketing carrier
           •   Operating carrier
      – You are sharing private data where necessary
      – You have assessed the benefit to your organization of:
           •   Fi & Final™ S l
               First Fi l™ Settlement
           •   GFS Fast Track

•    Discuss the above with your revenue management counterparts to ensure
     you are making best use of the life cycle of the fare!


88
                Questions and Answers

• Think about
     – Your main uses of sales data
     – The gaps in the data that you can fill
     – How you can take a life cycle approach to
       sales data




89
                        This Afternoon We Will Cover

•    Summary of data receiver session
•    Meet your GDS contacts
•    The state of the Exchange
•    Presenting the Customer Survey
•    Discussion papers
      –   Integrating electronic tickets
      –   Structured Fare Calculation
      –   EMD reporting solution
      –   Aggregated Sales Data
      –   Centralized codeshare
      –   Fare verification
      –   Reporting of 99 Taxes
      –   S l D
          Sales Data currency di            i
                                 discrepancies
      –   Pricing Indicators in the sales data exchange
•    New Business Cases from customers
      –   Customer Data Supply
      –   Reporting
•    Plans for 2009/2010
      –   Quality Control and GDS statistics
      –   Moving forward with priorities
      –   GDS product planning
      –   Working Sessions




90
                      Summary

Please share your three
main learning points
from today…




91
     Any Other Business?




92
93
      S l Data E h
ATPCO Sales D t Exchange


       Annual Forum
        1330 – 1630
      12 October 2009
                     General Housekeeping

• General administration
• Breaks
• Introductions
     –   Name
     –       p y
         Company
     –   Business area
     –   Main objective for today




95
              This Morning We Covered

•    Overview of ATPCO
•    History of the exchange and value
•    P            lk th
     Process walk-throughh
•    How to optimize your data coverage
•    Guide walk-through
•               Value Added
     Focus on Value-Added services



96
     Summary of Morning Session




97
                                                          Agenda

•    Summary of data receiver session
•    Meet your GDS contacts
•    The state of the Exchange
•    Presenting the Customer Survey
•    Discussion papers
      –   Integrating electronic tickets
      –   Structured Fare Calculation
      –   EMD reporting solution
      –   Aggregated Sales Data
      –   Centralized codeshare
      –   Fare verification
      –   Reporting of 99 Taxes
      –   S l D
          Sales Data currency di            i
                                 discrepancies
      –   Pricing Indicators in the sales data exchange
•    New Business Cases from customers
      –   Customer Data Supply
      –   Reporting
•    Plans for 2009/2010
      –   Quality Control and GDS statistics
      –   Moving forward with priorities
      –   GDS product planning
      –   Working Sessions




98
         Meet Your Supplier Contacts

        p y
     Company Name   Name
     Amadeus        Ignacio Serra
     Sabre          Robbie Thomas
     STA Travel
     STA T    l     D id S      ll
                    David Scannell
     TOPAS          Kevin Lee
     Travelport     Alicia Larison
                    Chris Colaco
                    Richard  Roberts
                    Fergal Kelly
     Travelsky      Yu Chen
                    Zhen Yang



99
              Life Cycle of the Fare with ATPCO


•     Collection of fare product data
•     Distribution of fare product data
•     Collection, processing, and
      distribution of ticketed “demand”
      data (RA)
•     Analysis of ticketed “demand” data
      (RM)




100
                     Industry Solutions

• Building solutions using ATPCO as an
  industry provider
      – Delivers benefit to whole community
      – Provides and maintains one solution
      – Shares best practice through industry
        knowledge
• Eliminates duplicate builds


101
                  Sales Data Metrics

                            140
• Currently 124 sales             Sales Data Exchange Customers
                                  ISR Customers
  data customers            120
                                  BSP Data Suppliers


• Over 500 million sales    100


  data transactions         80


  processed in last 12      60

  months                    40

• 67 providers of various   20
  f         f l d
  formats of sales data
                             0
  into the exchange


102
                         Sources of Sales Data

• ATPCO Sales Data is collected from
      –   Airlines’ hosted or own direct sales systems
          Airlines
      –   Airlines or ARC/IATA sending settlement data for conversion
      –   Agency TCN data from ticketing systems
      –            d t d t data
          GNE and student d t sources

                                                         Carrier Direct Sales


                                                         Carrier BSP/ARC Sales


                                                         Agency & Host TCN


                                                         Other (Student, GNE)




103
                         Sales Data by Source

•     12 agency sales providers                 Sa es ata Sou ce
                                                Sales Data Source
      sending TCN
•     5 host providers sending direct
      sales for 52 airlines                     9%   67%
•     37 airlines sending direct sales     7%
                                                                    TCN
•     39 airlines sending BSP/ARC
                                                                    BSP
                                         17%
                                                                    ARC
                                                                    ET




104
Future Direction: S
F t    Di ti      Survey
                                     Customer Survey

•     Sales Data is high value and will be for the long term
•     M i value d i
      Main l drivers
       – Speed of data (management information)
       – Auditing
•     Cost is a concern and customers are actively looking to cut costs
•     R                 ti    th than                       t is
      Revenue accounting rather th revenue management i main d i   i driver now
•     Most planning to stick around for the long term
•     Interest in developments (addressed today)
       –                     ( )
           Electronic Ticket (ET) as a data source
       –   Structure Fare Calculation
       –   More ticket types (e.g., EMD)
       –   Better data for auditing
•     Long-term value described as “very high”
•     ET data seen as main source over next 5 years
•     Low interest in working on new strategy in 2009 due to resource issues
•     High preference for more content in the sales data



106
                      Moving Forward

• Results suggested that ATPCO
      – Focus on content, coverage and quality of the
        data
      – Focus on incorporating Electronic Ticket data
      – Formulate strategy for relationship with GDS
        suppliers
      – Maintain a healthy Sales Data Exchange focusing
        on high value add-ons
• Survey to be expanded to all customers by
  end of 2009

107
                        Sales Data Survey

                            ,
• Based on customer feedback, ATPCO will focus
  on
      – Improving content, coverage, and quality of the data
      –I          ti    l t i ticket d t f it hi h           t t
        Incorporating electronic ti k t data for its high content
        and speed to satisfy value drivers
                   g          y                      g
      – Maintaining a healthy Sales Data Exchange with high   g
        value add-ons
      – Exploring new industry add-ons for sales data to
        benefit existing customers
      – Increasing life cycle links adding greater value to both
        revenue accounting and revenue management


108
Sales Data Exchange W b P
S l D t E h         Web Page
                            Current State

                                   p
• Diverse information needs on the product
• Current Extranet holds
      –   Specifications Guide
      –   Template
      –   Codeshare Table
      –   Participants
• Customers and suppliers tend to be
      – Revenue accounting focused
      – Technical experts in file transfer
      – Not necessarily revenue management
• Therefore not necessarily accessing the Extranet

110
                                 Solution Concept

• ATPCO goals
      – Open communication on the exchange to meet community
        information needs
      – Add value to the product with more open access to reporting

• To achieve this, the Sales Data web environment will
      – Be open to all
      – Contain required information for stakeholders
          •   Contracts
          •   Specification Guide
          •   All templates including new starter checklist
          •   Product ll t l
              P d t collateral
          •   Links to other value added products
          •   Tracking of business developments
                       y
      – Have the ability to broadcast news briefs


111
      Look and Feel




112
                       Your Feedback

• Would you use the site?
• What are your main communication
  needs?
      – Provider perspective
      – Customer perspective
• Poll on concept of news brief
• Publication of other statistics
      – Data quality
      – Reporting of very high level volumes

113
Discussion P
Di     i Papers
                      Papers to Discuss

•     Integrating Electronic Tickets
•     Structured Fare Calculation
•     EMD reporting solution
•     Aggregated Sales Data
•     Automated Codeshare
•     Fare Verification
•     Reporting of 99 Taxes
•     Sales Data Currency Discrepancies
•     Pricing Indicators in the Sales Data Exchange
•     Customer Data Supply
•     Reporting
         p     g

115
                     Rules of Engagement

             p
• ATPCO will present
      –   Concept
      –   Perceived benefits
      –   C     t t t f                   ti
          Current state from ATPCO perspective
      –   Technical consideration

• What we need from you
      –   Active engagement and questioning
      –   Validate the current state
      –   Be vocal about your views on priority items
      –   Help us to determine next steps to move forward

116
      Product Design Process




117
                Products and Services Conference
•     Purpose
           p                    process for airlines and other
      – To provide a method and p
        related companies to address industry issues and new
        business requirements
•     Industry approval process
      – Five milestones
          1.   New business proposals submitted to ATPCO
          2.   Proposed draft solutions
          3.
          3    C     l t   l ti
               Complete solution
          4.   Delivery schedule alignment
          5.   Assessment of project success


Today we will generally be using Milestone 2



    118
                         Your Involvement

• At the close of each paper, we will ask you to
      – Highlight any questions or comments
      – Fill out
         • A milestone form for the item (included in your agenda
           copy)
         • One form per organization
                     p      g
         • Even if no clear view, with comments and questions
      – Sign off on the milestone form

• Results will be aggregated for priority

119
Item 1. Integrating Electronic Tickets
It   1 I t     ti El t i Ti k t
      Integrating Electronic Tickets




121
                    Options

1.
1 Issuing GDS sends EDIFACT
2. Issuing GDS converts to TCN 4.05
3 ETS H t or V lid ti C i sends
3.      Host Validating Carrier     d
   EDIFACT
4. Carrier system converts to TCN4.05




122
                      Key Questions

• Is the above model correct?
• Are there any other available sources of
  the data to create options not yet
  represented?
  Who is illi to         l the data
• Wh i willing t supply th d t
      – Airlines
      – System providers



123
                          Proposal

• ATPCO to convert the EDIFACT format into ISR
  flat file format. New records may result due to
  new data elements processed, which would be
                                      data.
  optional to the end receiver of the data

OR

• ATPCO receives greater content in existing TCN
                    g                          g
  data feeds. The Electronic Ticket Data elements
  would be built into the existing structure in order to
                                        supplied.
  add value to the current sales data supplied

124
Item 2. Structured Fare Calculation
It   2 St t d F         C l l ti
                                           Background

• Fare Calculation Area
      – Fare Calculation Area “free text”
      – Governing Standards offer options, are not clear, and not
        comprehensive
            p
          • Q surcharges
          • Stopover charges
          • PFC reporting
        The l l          the ticket h     th then total ticket f      l
      – Th only place on th ti k t where other th t t l ti k t fare value
        can be derived
          • Fare component value, surcharges, Priceable Unit value, stopover charges, etc.
      – Population varies by system
      – Population varies within a system (country exceptions, carrier
        exceptions, type of pricing entry)
            y                  g y         ( p
      – Many different ticketing systems (67 providers of sales data to
        ATPCO)

126
                  Fare Calculation Example

Net fares

      MSY AA X/MIA Q10.00AA MBJ M/BT SLNTX5 AA X/MIA Q10.00AA
      MSY M/BT QLNTX5 END

Problems

(1) No amounts to split over the fare calculation area
( )                 p                         g
(2) Fare amount presented on the record might be g         (published)
                                                     gross (p        )
    amount
(3) Amount cannot be split because fare basis on first net component
    is different to fare basis on second net component


127
                   Fare Calculation Example

Not all details present

      SJOEWRLGW1324567.Q15.00.END.ROE0.574407XT5.40YC5.40XA7

Problems

(1) This is also a BT fare but has no value presented in the fare field
(2) There are no carrier codes which does not allow to accurate pricing of
    the journey
(3) There are no indicated fare breaks at all between journey origin and
    destination
(4) No currency code is presented with the transaction


128
                   Fare Calculation Example

Agent keying error

      CHIAANUYC80.00QB14Q20NAAX/E/MIAQ10.00AAGYEM400.00L
      H07L7SAAX/E/MIAQ10.00AANYCM400.00LH071L7SAACHI80.00
      QB14Q20NNUC1000.00END

Problems

(1) NYC is mis-spelled and so cannot be read as a city code
(2) Lack of spacing makes parsing data difficult to achieve
(3) Mix of fare basis, city codes, transfer indicators, and airline codes
    makes parsing data difficult to achieve


129
                  Data Parsing Error Statistics

       six month
From a six-month sample in 2006
 Reason for Error Code                                Number    %


 City in Good For Passage not found in Fare Calc      61,698   0.8%


 Segment found in Fare Calc not in Good for Passage   29,643
                                                      29 643   0 4%
                                                               0.4%
 One fare component in Fare Calc cannot be split
 accurately                                           26,739   0.3%


 No fare components found in Fare Calc                21,129   0.3%


                               y pp
 IT/BT fare cannot be accurately apportioned            ,
                                                      15,944   0.2%



130
                                 Background

• Data Standards have been defined for TCN and ET
      – ISR/TCN Records 80, 81, 82
         • Fare Component
         • Segment Charges
         • Priceable Unit
      – Electronic Ticket
         • Fare Component Elements
         • Reissue/Exchange Elements
      – ARC/ BSP Reporting
         • No elements defined
• Structured Fare Calculation is more than just the fare
  calculation area


131
                                 Background

• No holistic review of the standards
      – Did we get them right?
      – Will they satisfy the business need?
• No one has implemented these standards and
  no one is receiving the data!
      – Business Case
         • Who benefits
         • Who Pays
        Chicken d
      – Chi k and egg
         • “I will not provide the data until I have a subscriber”
         • “I will not program to receive the data until there is provider”


132
                                  The Reality

              g processes cannot be accurately p
• The following p                            y performed
  without structured fare calculation
      – Proration and allocation of Q surcharges and Stopover Charges
                                 fares,                     (YQ/YR), taxes,
      – Automated reissue of fares fuel and insurance (YQ/YR) taxes
        and ticketing charges (OB)
      – Auditing fares, tax, all fees and charges
        Correct i
      – C                   f ti
               t issuance of optional f              ft th ti k ti h
                                       l fees (EMD) after the ticketing has
        occurred
• In general, any process taking place separately from the
  original pricing transaction requires matching fields
  which are not reported with the ticket today


133
                      Interest in SFC by Area



                     Other
                     19%                 Revenue
                                        Accounting
      Service Fees                         36%
          14%


                             Reissues
                               31%




134
                     Data Elements Required



                               Highest Other, 23%
      Fare C l l ti
      F    Calculation
      Ladder Elements,
            38%                                           Fare Owner, Tariff,
                                                              Rule, 84%




               Category
            Generating Fare,              Account Code,
                 46%                          53%




135
      Process Flow




136
                                Options

         g
1. Issuing GDS sends EDIFACT SFC
2. Issuing GDS converts SFC to TCN 4.05
                        g
3. ETS Host or Validating Carrier sends EDIFACT
   SFC
4. Carrier system converts SFC to TCN4.05
5. ATPCO creates SFC data from fares and rules
   matched to sales
                                (tariff, carrier, rule,
      – Priority elements first (tariff carrier rule account
        code)
      – Other elements as required


137
                     Items for Discussion

                              p
• Which of the five stated options is ppreferable
  and most practical for time to market
• Industry funding mechanism
  Record supplied on an optional b i
• R     d      li d            i   l basis
• Required data fields (feedback from SFC in
                 vs.
  2007): partial vs full solution?
      –   Tariff
      –   Carrier
      –   Rule
      –   Account Number/Corporate ID


138
                                    Proposal

•     ATPCO to convert the EDIFACT format Structured Fare Calculation
                                       format.
      data elements into ISR flat file format

OR

•     ATPCO to receive greater content in existing TCN data feeds. The
      Electronic Ticket Data elements would be built into the existing
      structure in order to add value to the current sales data supplied.

OR

•     ATPCO to create the Structured Fare Calculation content based on
      matching sales data to fares and rules content within the ATPCO
      database.



139
Item 3. EMD R
It   3           ti Solution
            Reporting S l ti
                          Items for Discussion

• Full walk-through on-site of the EMD technical specification

• How many systems and carriers have an interest in moving
  forward with the concept of EMD in the sales data exchange?

• The phases for discussion are as follows
      –   Acceptance of EMD records from suppliers
      –   M    i
          Mapping of EMD elements from BSP and ARC d t sources
                     f      l     t f             d      data
      –   Incorporation of EMD into First & Final™ Settlement
      –   Merging of associated EMD into the ticket record within ISR
          process




141
                    Proposal

• ATPCO have drafted three new records for
  review and acceptance to support both the
  provision of the EMD or Electronic MCOs
  in the TCN format, and also to map from
  BSP and ARC
• The group will be asked to review and
  approve the attached specifications in
  Attachment C

142
Item 4. Aggregate Sales Data
It   4 A       t S l D t
                    Proposal

• Establish an aggregated sales data
  product
                  give get
• Philosophy of “give to get”
• Incorporate all authorized GDS data
       li d i ith th           t
  supplied in either the current TCN or GDS
  ATCN specific formats



145
Item 5. Automated Codeshare
It   5 A t    t dC d h
                    Proposal

• Obtaining the codeshare information
  directly from the schedule data and
  automatically updating the sales
  information
• May be from Innovata or OAG
• Marketing carrier permission would need
  to b l b ll bt i d th than i
  t be globally obtained rather th given
  on a piecemeal basis

147
Item 6. Fare Verification
It   6 F     V ifi ti
                    Integration within First & Final™
                                                                                                                                       Fare
                                                                                                                                    Verification
                                                      ATPCO
                                                     Interface
                                                                                                                 Sales Record
                                                                                                                  Selection               ATPCO
    Sales                                                                                                                             Fares, Rules
                                                                                                                                      Fares Rules, &




                                                               Unplanned Lift
                                                                                Unplanned Prorate Result
                                                                                                                                       Service Fees
 TCN/BSP/ARC
                                     Planned Prorate Results
                                                                                                                                NFP
 ARC COMPASS™
                                                               U
                                                                                          P                                     Engine*


                                                                                                            Fare/Tax/
                                                                                                             ISC/HF
      Lift                       Carrying Airline’s                                                        Verification               Issuing
                              Revenue Accounting DB                                                                                    Airline
      * NFP offered by ATPCO and Kale, powered by Kale’s APEX®


149
               Fare Verification Process

                   ATPCO
                  Interface
                                     Outbound ISR
                                          File
                                  e ge e
                                 Merge New
    Sales                                           Customer
                                                    C t
                                  Records
 TCN/BSP/ARC                                         Airline

                 Sales Record
                  Selection




                     Fare        Create New
                  Verification    Records



150
                 Process Key Points

• Sales data extraction and verification




• Customer determines which to verify
  No    i d h        to     (i di t    in “filler”)
• N required changes t ISR (indicators i “fill ”)



151
                      Proposal

• Establish as an optional service the
  verification of the airline-selected sales
  transactions within the ISR prior to
  distribution to the airline customer




152
Item 7. Reporting of 99 T
It   7 R     ti    f    Taxes
      Resolution 722f and 722g




154
                              Current State

                    p
• Number of taxes reported: 3 to unlimited
• Reporting in TAXA
      –   No change
      –   Blank
      –   First three, no XT
      –   Only first, report as XT
• Reporting in FRCA
      –   No change
      –   Eliminate
      –   Pass through
      –   XT if EDIFACT partner does not support 99 taxes


155
                   Proposal

• To expand the number of Record 4s to
  accommodate 99 taxes
• To document an agreed upon process for
  the use of the “XT” tax code




156
Item 8. Sales Data Currency
       Discrepancies
                   Two Main Issues

• TCN says SEK0 – for FNUM/EQFN
• BSP says SEK2 – for TDAM/TMFA
• Decimal is normally same for all 4 elements

•     BSP Record 3 reports SEK 100.00
•     FNUM/EQFN derived as SEK2
•     BSP Record 4 reports SEK0
•                    pp
      TDAM/TMFA mapped as SEK0

158
                                     Proposal

•     Source providers of data to ensure that currency decimal reporting is
      consistent across TCN and BSP data sources and across the
      facsimile and financial elements within a transaction

OR

•     ATPCO to document solution based on using reference currency in
      Record 04 position 384 for TDAM and TMFA for BSP merged and
      BSP only

OR

•     ATPCO to cleanse the data within the ISR such that the currency
      decimal is consistent for all financial elements in the Record 04.



159
Item 9. Pricing Indicators in the
    Sales Data Exchange
         Resolution 722f Attachment A

• Fare Calculation Mode Indicator = FCRI
• Fare Calculation Pricing Indicator = FCPI




161
                     Proposal

• Update the ISR guide with the current
  autopricing indicators used by each of the
  systems




162
  Customer Item 1.
Customer Data Supply
                            Proposal

• ATPCO to provide for a timeline for
  customers to be required to send data
      – Direct sales from host or self
      – BSP/ARC sales
• Within
      – 6 months of receiving ISR output, customer
        must supply at least one of the above
      – 12 months of receiving ISR output, customer
        must supply all of the above

164
Customer It
C t           2 R     ti
         Item 2. Reporting
                              Proposal

                       p    g
• ATPCO to build a reporting structure for both
  carrier internal and macro level summary statistics
  which will incorporate (examples only)
      – Data foundation
        (i.e., was the data sources from TCN, BSP, or ARC)
      – Autopricing indicator on the ticket
      – Plating carrier
      – Data supplier
      – Net Remit transactions
      – Volume of duplicate tickets
        (i.e., tickets dropped in the process)
      – Country of sale


166
Moving Forward t 2010
M i F        d to
                   Moving Forward to 2010

• Focus on data quality
      – Sales data edits on supplied data
      – Reporting key statistics
         • Web page
         • Sales data quality reporting (customer item 2)
• Focus on data coverage and content
      – Proactively working with the customer on benefits
         • 100% of sales data reported through ATPCO
         • 100% of fare and rule data instructed through ATPCO
      – Reporting on coverage and content (progress)

168
                           ATPCO Next Steps

•     Presentation and agenda on Web site                16 OCT 2009
•     Produce meeting summary                            06 NOV 2009
       – Notes of discussion
       – Summary of priority results

•     Proposal for reporting data quality statistics     30 OCT 2009
•     W b site launch
      Web it l       h                                   Q4 2009
•     Communicate plan for 2010                          31 DEC 2009
•     Launch 2010 Specifications Guide                   Q1 2010
•     Supplier/ Customer meetings on agreed priorities   Q1/Q2 2010




169
                            This Afternoon We Covered

•     Summary of data receiver session
•     Meet your GDS contacts
•     The state of the Exchange
•     Presenting the Customer Survey
•     Discussion papers
       –   Integrating electronic tickets
       –   Structured Fare Calculation
       –   EMD reporting solution
       –   Aggregated Sales Data
       –   Centralized codeshare
       –   Fare verification
       –   Reporting of 99 Taxes
       –   S l D
           Sales Data currency di            i
                                  discrepancies
       –   Pricing Indicators in the sales data exchange
•     New Business Cases from customers
       –   Customer Data Supply
       –   Reporting
•     Plans for 2009/2010
       –   Quality Control and GDS statistics
       –   Moving forward with priorities
       –   GDS product planning
       –   Working Sessions




170
      Any Other Business?




171

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:139
posted:5/8/2011
language:English
pages:170