Superset Record Types

1
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.
• If you hold down the shift key before using the
  resize handles, you will maintain the proportions
  of the object you wish to resize.

• 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 itinerarys 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 CO HNL 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 Intl 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 Intl 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