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), som 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.


Row elementElement descriptionComments
1BagEventAirportIATA


2BagTagNumber


3BagTagIssuerCode


4BagTagIssuerAirlineIATA


5BagCategory


6


7BagPreviousAirportIATA


8BagArrivalFlightId


9BagArrivalOperatingAirlineIATA


10


11BagNextAirportIATA


12BagDepartureFlightId


13BagDepartureOperatingAirlineIATA


14BagSOBT


15BagAOBT


16BagFinalAirportIATA


17


18BagHandlerCode


19


20BagTypeIndicator


21BagSizeIndicator


22BagWeight


23


24BagTotalBhsDurationBagTotalTimeInBhs
25BagNetBhsDurationBagNetlTimeInBhs (BagTotalTimeInBhs-EBS)
26BagTotalTimeInMcs


27BagTotalTimeAtSecScreen

28BagTimeAtManSecScreen

29BagTimeAtAutSecScreen

30BagTotalTimeInEbs

31


32BagEventCount


33BagInfoMsgCount


34BagToMcsCount


35BagBhsBinDeliveryAttempts


36


37BTGRT


38BFCAT


39BagFirstRejectReason


40BACIT


41BABBT


42BTFST


43BTAST


44BTMST


45BTL1T


46BTL2T


47BTL3T


48BTL4T


49BTL5T


50BFLST


51BFAST


52BFMST


53BFL1T


54BFL2T


55BFL3T


56BFL4T


57BFL5T


58BTMCT


59BFMCT


60BTEBT


61BFEBT


62BTBBTE


63BTBBT


64BFBBT


65BLOAT


66BUNLT


67BTOTT


68BAOBT


69BTPATE


70BTPAT