Logical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 172

Table 5.1 Attributes of the tables T T100I Segment All Carrier XXXX
Summaries
DepScheduled

Departures scheduled

DepPerformed Departures performed

Payload Available payload (pounds)

Seats Available seats

Passengers Non-stop segment passengers transported

Freight Non-stop segment freight transported (pounds)

Mail Non-stop segment mail transported (pounds)

Distance Distance between airports (miles)

RampTime Ramp to ramp time (minutes)

AirTime Airborne time (minutes)

Carrier
UniqueCarrier Unique carrier code. When the same code has been used
by multiple carriers, a numeric su x is used for earlier
users, for example, PA, PA(1), PA(2). Use this field for
analysis across a range of years
AirlineID An identification number assigned by US DOT to iden-
tify a unique airline (carrier). A unique airline (carrier)
is defined as one holding and reporting under the same
DOT certificate regardless of its code, name, or holding
company/corporation
UniqueCarrierName Unique carrier name. When the same name has been used
by multiple carriers, a numeric su x is used for earlier
users, for example, Air Caribbean, Air Caribbean (1)

UniqCarrierEntity Unique entity for a carrier's operation region

CarrierRegion Carrier's operation region. Carriers report data by oper-

ation region

Carrier Code assigned by IATA and commonly used to identify

a carrier. As the same code may have been assigned to
different carriers over time, the code is not always unique.
For analysis, use the unique carrier code

CarrierName Carrier name

CarrierGroup Carrier group code. Used in legacy analysis

CarrierGroupNew Carrier group new

Origin
OriginAirportID Origin airport, Airport ID. An identification number as-
signed by US DOT to identify a unique airport. Use this
field for airport analysis across a range of years because
an airport can change its airport code and airport codes
can be reused
OriginAirportSeqID Origin airport, Airport Sequence ID. An identification
number assigned by US DOT to identify a unique air-
port at a given point of time. Airport attributes, such as
airport name or coordinates, may change over time
OriginCityMarketID Origin airport, City Market ID. City Market ID is an
identification number assigned by US DOT to identify a
city market. Use this field to consolidate airports serving
the same city market

Origin Origin airport