superset record types l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Superset Record Types PowerPoint Presentation
Download Presentation
Superset Record Types

Loading in 2 Seconds...

play fullscreen
1 / 38

Superset Record Types - PowerPoint PPT Presentation


  • 347 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Superset Record Types' - Michelle


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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.

Superset Record Types

Larry Kemp

Data Base Products, Inc.

db1a records
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
data in db1a records
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
db1a record categories
DB1A record categories

Itineraries can be categorized in several ways

  • one way, round trip or open jaw
  • connect or local
  • domestic, international, or mixed
leg types
Leg types

Itineraries are categorized as

  • One way ABQ - DFW - DCA
  • Round Trip ABQ - DFW - DCA - DFW - ABQ
  • Open Jaw ABQ - DFW - DCA - MSP
one way leg type
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

round trip records
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
round trip leg types
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

open jaw leg type
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

round trip leg type v
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

connect or local
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

coupon types
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

coupon types13
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

coupon types14
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

codesharing is considered local
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

coupon type h
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

coupon type i
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

coupon type j
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

record type
Record Type

The record type categorizes the COMPLETE ITINERARY as

  • D - Pure Domestic
  • J - Pure International
  • M - Part of Mixed Itineraries
pure domestic itineraries
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

pure domestic itineraries21
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

pure int l itineraries
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

pure int l itineraries23
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

mixed itineraries
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

mixed itineraries25
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

mixed itineraries26
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

gateway boundary crossing
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

boundary crossing a
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

boundary crossing c
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

boundary crossing l
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

boundary crossing m
Boundary Crossing - M

MEX UA LAX UA SFO

This journey would be included in the Mexican entity

boundary crossing t
Boundary Crossing - T

YYZ UA ORD UA HNL

This journey would be included in the Canadian entity

T is taken from the term Transborder

special boundary crossing codes
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

boundary crossing z
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

boundary crossing z35
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

boundary crossing x
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

boundary crossing x37
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

the end
The End

Well not really but now is a time for questions before we go on

Questions & Answers