Superset record types
Download
1 / 38

Superset Record Types - PowerPoint PPT Presentation


  • 334 Views
  • Updated 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 l.jpg

  • 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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Record Type

The record type categorizes the COMPLETE ITINERARY as

  • D - Pure Domestic

  • J - Pure International

  • M - Part of Mixed Itineraries


Pure domestic itineraries l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Boundary Crossing - M

MEX UA LAX UA SFO

This journey would be included in the Mexican entity


Boundary crossing t l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
The End

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

Questions & Answers


ad