The following table is a possible (database) row to simplify baggage data analytics. Some of the data will directly be from baggage events (ref. Baggage process and data elements - airport perspective), some will be derived from event information and some will be from other systems.
Analytics oriented reports will typically be based on a subset of the elements. Not all elements are relevant for all flights.
Each row can be seen as most of the relevant baggage information for one flight leg.
NB! The rows are flight leg oriented.
Row element | Element description | Comments |
---|---|---|
The first set of data identifies the flight leg, and can be used to calculate any delays. | ||
ArrivalAirportIATA | ||
AircraftRegistration | ||
aircraft type | ||
SOBT | ||
AOBT | ||
SIBT | ||
AIBT | ||