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.
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.
| Row element | Element description | Comments | |
|---|---|---|---|
| 1 | |||
| 1 | BagEventAirportIATA | The first elements are core information that should make the row fairly unique, but it isn't enough to guarantee uniqueness. | |
| 2 | BagFirstEventDate | ||
| 3 | BagTagNumber | ||
| 4 | BagTagIssuerCode | ||
| 5 | BagTagIssuerAirlineIATA | ||
| 6 | BagCategory | ||
| 7 | |||
| 7 | BagPreviousAirportIATA | Information about the previous airport and arrival flight are not available for bags with BagCategory = "CheckIn". | |
| 8 | BagArrivalFlightId | ||
| 9 | BagArrivalOperatingAirlineIATA | ||
| 10 | |||
| 11 | BagNextAirportIATA | Information about the next airport and departing flight are not available for bags with BagCategory = "Final". | |
| 12 | BagDepartureFlightId | ||
| 13 | BagDepartureOperatingAirlineIATA | ||
| 14 | BagSOBT | ||
| 15 | BagAOBT | ||
| 16 | BagFinalAirportIATA | ||
| 17 | |||
| 17 | BagHandlerCode | The handling company responsible for handling the bag on this airport. If multiple companies are involved, the code for the first handling company. | |
| 18 | |||
| 18 | BagTypeIndicator | The next elements give information about the type/size/weight/++ of the bag. | |
| 19 | BagSizeIndicator | ||
| 20 | BagWeight | ||
| 21 | |||
| 21 | BagTotalTimeInBhs | The next elements indicates how much time the bag used in different parts of the baggage handling system, if relevant (a BHS was used). | |
| 22 | BagNetTimeInBhs | ||
| 23 | BagTotalTimeInMcs | ||
| 24 | BagTotalTimeAtSecScreen | ||
| 25 | BagTimeAtAutSecScreen | ||
| 26 | BagTimeAtManSecScreen | ||
| 27 | BagTotalTimeInEbs | ||
| 28 | BagBhsDeliveryAttemptsTime | ||
| 29 | BagBhsTransportTime | ||
| 30 | BagBhsTimeExceededBy | ||
| 31 | BagBhsTimeExceededGroup | ||
| 32 | |||
| 32 | BagEventCount | The next elements indicate how many times something happened. | |
| 33 | BagInfoMsgCount | ||
| 34 | BagToMcsCount | ||
| 35 | BagBhsBinDeliveryAttempts | ||
| 36 | |||
| 36 | BTGRT | This and the following elements are timestamps and some afdditional information for significant events in a bags journey. | |
| 37 | BFCAT | ||
| 38 | BagFirstRejectReason | ||
| 39 | BACIT | If the bag is checked, rejected and checked again this should be the timestamp for the last checkin. | |
| 40 | BagCheckinType | The checkin type that was actually used and corresponds to BACIT. | |
| 41 | BagCheckinLocation | The checkin location that was actually used and corresponds to BACIT. | |
| 42 | BABBT | ||
| 43 | BTFST | ||
| 44 | BTAST | ||
| 45 | BTMST | ||
| 46 | BTL1T | ||
| 47 | BTL2T | ||
| 48 | BTL3T | ||
| 49 | BTL4T | ||
| 50 | BTL5T | ||
| 51 | BFLST | ||
| 52 | BFAST | ||
| 53 | BFMST | ||
| 54 | BFL1T | ||
| 55 | BFL2T | ||
| 56 | BFL3T | ||
| 57 | BFL4T | ||
| 58 | BFL5T | ||
| 59 | BTMCT | ||
| 60 | BFMCT | ||
| 61 | BTEBT | ||
| 62 | BFEBT | ||
| 63 | BTBBTE | ||
| 64 | BTBBT | ||
| 65 | BagPlannedBin | ||
| 66 | BagActualBin | ||
| 67 | BFBBT | ||
| 68 | BLOAT | ||
| 69 | BUNLT | ||
| 70 | BTOTT | ||
| 71 | BAOBT | ||
| 72 | BTPATE | ||
| 73 | BTPAT |