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 bags, and several elements are only relevant for airports with a full size baggage handling system.

Each row can be seen as most of the relevant information for one bag (tag) on one airport. For one bag journey multiple airports are involved and this might/will result in multiple rows for one bag on one journey. How many rows depend on the number of airports involved and the scope of the baggage tracking system.

NB! The rows are bag oriented AND airport oriented. Arrival and departure oriented information are relative to the airport one row applies to.