1 / 38

Superset Record Types

To insert your company logo on this slide From the Insert Menu Select “Picture” Locate your logo file Click OK To resize the logo Click anywhere inside the logo. The boxes that appear outside the logo are known as “resize handles.” Use these to resize the object.

Michelle
Download Presentation

Superset Record Types

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. To insert your company logo on this slide • From the Insert Menu • Select “Picture” • Locate your logo file • Click OK • To resize the logo • Click anywhere inside the logo. The boxes that appear outside the logo are known as “resize handles.” • Use these to resize the object. • If you hold down the shift key before using the resize handles, you will maintain the proportions of the object you wish to resize. Superset Record Types Larry Kemp Data Base Products, Inc.

  2. DB1A records Large domestic carriers are required to report 10% of ticketed itineraries • if the first reporting carrier on itinerary • Up to 24 coupons long • Passengers summarized to • Fare paid • Enplanement airports • Marketing carriers • Fare Basis

  3. Data in DB1A records Every itinerary MUST have at least • Year and quarter travel began • Fare Paid • Carrier reporting data • Passengers • Coupons in itinerary - minimum 1 • Coupon 1 origin and destination airport • Coupon fare basis

  4. DB1A record categories Itineraries can be categorized in several ways • one way, round trip or open jaw • connect or local • domestic, international, or mixed

  5. Leg types Itineraries are categorized as • One way ABQ - DFW - DCA • Round Trip ABQ - DFW - DCA - DFW - ABQ • Open Jaw ABQ - DFW - DCA - MSP

  6. One way leg type One way records are given a leg type of A ABQ - DFW - DCA As can be seen by the example, one way directional journeys can include many coupons

  7. Round trip records To be round trip, the itinerary MUST end in the CITY of origin Both of the these are round trips • LGA - DFW - LAX - DFW - LGA • LGA - DFW - LAX - ORD - JFK

  8. Round trip leg types Round trip records have two leg types Outbound legs are leg type B LGA - DFW - LAX - DFW - LGA Inbound legs are leg type R LGA - DFW - LAX - DFW - LGA

  9. Open jaw leg type Open jaw itineraries include at least two trips and the itinerary’s final destination is NOT the origin Open Jaws are leg type V ABQ - DFW - DCA - MSP ABQ - DFW - DCA - MSP

  10. Round trip leg type V As noted before, to be round trip, the itinerary MUST end in the CITY of origin All round trips have B and R records Some round trips have V records which are intermediate trips SJC - MIA - BOS - SJC SJC-MIA is a B record; BOS-SJC is an R record; and the MIA-BOS is a V record

  11. Connect or Local? If the same carrier is the marketing carrier on all the coupons of a trip, the connect type is L ABQ AA DFW AA ATL AA DFW AA ABQ If more than one carrier is the marketing carrier on a trip, the connect type is C ABQ AA DFW AA ATL DL DFW DL ABQ

  12. Coupon types Unlike Connect types, Coupon types apply to a particular coupon and not to the entire trip A directional trip can have several coupon types

  13. Coupon types A is a U.S. reporting carrier flying between two U.S. points B is a U.S. reporting carrier flying between a U.S. and foreign point C is a U.S. reporting carrier flying between two foreign points D is a U.S. non-reporting carrier flying within North America or surface traffic

  14. Coupon types E is a foreign carrier flying between two U.S. points which is called cabotage F is a foreign carrier flying between a U.S. and foreign point G is a U.S. non-reporting, foreign, or unknown carrier flying between two foreign points

  15. Codesharing is considered local Because the DB1A marketing carrier is the reported carrier, we have enhanced the coupon type codes to indicate known code share markets This allows analysts to identify markets not operated by the marketing carrier

  16. Coupon type H LAX CO HNL CO GUM CO TPE CO SEL Type H is when the operating carrier flies a domestic coupon segment for a marketing carrier During our codeshare analysis, we found that Continental has a codeshare relationship with Continental Micronesia in this market

  17. Coupon type I LAX COHNL CO GUM CO TPE CO SEL Type I is when the operating carrier flies a coupon segment between a U.S. and foreign point for a marketing carrier Continental and Continental Micronesia also have a codeshare relationship in this market

  18. Coupon type J LAX CO HNL CO GUM CO TPE CO SEL Type J is when the operating carrier flies a coupon segment between two foreign points for a marketing carrier As you can see, it is possible for a given trip to have many coupon types

  19. Record Type The record type categorizes the COMPLETE ITINERARY as • D - Pure Domestic • J - Pure International • M - Part of Mixed Itineraries

  20. Pure Domestic Itineraries In the DB1A the following itinerary was reported ABQ AA ORD AA ALB AA ORD AA ABQ It would be broken into two Superset D record types ABQ AA ORD AA ALB & ALB AA ORD AA ABQ

  21. Pure Domestic Itineraries ABQ AA ORD AA ALB AA ORD AA ABQ Notice that all the coupons contain only U.S. Domestic airports U.S. Territories and the U.S. Caribbean airports are considered domestic

  22. Pure Int’l Itineraries In the DB1A the following itinerary was reported LHR AA ORD AA LHR It would be broken into two Superset J record types LHR AA ORD & ORD AA LHR

  23. Pure Int’l Itineraries LHR AA ORD AA LHR J records come from itineraries that contain a non-domestic Airport and DO NOT have a domestic to domestic coupon

  24. Mixed Itineraries In the DB1A the following itinerary was reported LHR AA ORD AA DSM AA ORD AA LHR It would be broken into two Superset M record types LHR AA ORD AA DSM & DSM AA ORD AA LHR

  25. Mixed Itineraries LHR AA ORD AA DSM AA ORD AA LHR M records come from itineraries that contain a non-domestic Airport and DO have a domestic to domestic coupon

  26. Mixed Itineraries LHR AA ORD AA DSM AA LHR If American had direct service DSM - LHR both resulting records would be M records LHR AA ORD AA DSM & DSM AA LHR Remember, record types refer to the entire itinerary

  27. Gateway Boundary Crossing As an aid to pull like Superset records, a Gateway Boundary Crossing field is created for each directional journey Each geographic entity has its own code Each entity is ranked separately so that analysts can quickly determine the largest markets in their area of interest Multiple boundary and no boundary records are not ranked

  28. Boundary Crossing - A LHR AA ORD AA DSM & DSM AA LHR In our previous example, both journeys would be included in the Atlantic entity A journey to or from the U.S. to Europe, Africa, the Middle East, and Greenland is incorporated into the Atlantic entity

  29. Boundary Crossing - C NAS US MIA US PIT This journey would be included in the Latin Caribbean entity Remember that Puerto Rico and the U.S. Virgin Islands are domestic

  30. Boundary Crossing - L SAO UA MIA UA IAD This journey would be included in the Latin entity Trips to Middle and South America with the exception of Mexico are incorporated into the Latin entity

  31. Boundary Crossing - M MEX UA LAX UA SFO This journey would be included in the Mexican entity

  32. Boundary Crossing - T YYZ UA ORD UA HNL This journey would be included in the Canadian entity T is taken from the term Transborder

  33. Special Boundary Crossing Codes In all the previous Gateway examples, a single, specific geographic entity defined the Gateway If passengers transits the U.S. between their origin and destination, they have multiple gateways and are assigned the boundary code of Z If passengers do not have a gateway, they are assigned a boundary code of X

  34. Boundary Crossing - Z YYZ UA ORD UA HNL UA HKG Notice that this directional journey crosses two gateways • Canadian • Pacific It would be assigned a Z boundary crossing value

  35. Boundary Crossing - Z YYZ UA ORD UA HNL UA HKG Now to throw a real monkey wrench into the works The outbound record - Leg Type B - from YYZ has a Gateway of YYZ - ORD The inbound record - Leg Type R - into HKG has a Gateway of HNL - HKG Capturing both is a programming challenge

  36. Boundary Crossing - X YYZ UA LAX UA MIA UA ORD UA YYZ Sometimes directional journeys do not cross a gateway. In this example, YYZ - LAX and MIA - ORD - YYZ directional journeys have a Canadian boundary crossing The LAX -MIA journey is given an X to differentiate it from pure domestic journeys

  37. Boundary Crossing - X SYD UA NRT UA LAX UA HNL UA SYD In this example, the SYD - NRT directional journey does not enter into the U.S. and has no gateway

  38. The End Well not really but now is a time for questions before we go on Questions & Answers

More Related