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 element | Element description | Comments | |
---|---|---|---|
1 | BagEventAirportIATA | ||
2 | BagTagNumber | ||
3 | BagTagIssuerCode | ||
4 | BagTagIssuerAirlineIATA | ||
5 | BagCategory | ||
6 | |||
7 | BagPreviousAirportIATA | ||
8 | BagArrivalFlightId | ||
9 | BagArrivalOperatingAirlineIATA | ||
10 | |||
11 | BagNextAirportIATA | ||
12 | BagDepartureFlightId | ||
13 | BagDepartureOperatingAirlineIATA | ||
14 | BagSOBT | ||
15 | BagAOBT | ||
16 | BagFinalAirportIATA | ||
17 | |||
18 | BagHandlerCode | ||
19 | |||
20 | BagTypeIndicator | ||
21 | BagSizeIndicator | ||
22 | BagWeight | ||
23 | |||
24 | BagTotalBhsDuration | BagTotalTimeInBhs | |
25 | BagNetBhsDuration | BagNetlTimeInBhs (BagTotalTimeInBhs-EBS) | |
26 | BagTotalTimeInMcs | ||
27 | BagTotalTimeAtSecScreen | ||
28 | BagTimeAtManSecScreen | ||
29 | BagTimeAtAutSecScreen | ||
30 | BagTotalTimeInEbs | ||
31 | |||
32 | BagEventCount | ||
33 | BagInfoMsgCount | ||
34 | BagToMcsCount | ||
35 | BagBhsBinDeliveryAttempts | ||
36 | |||
37 | BTGRT | ||
38 | BFCAT | ||
39 | BagFirstRejectReason | ||
40 | BACIT | ||
41 | BABBT | ||
42 | BTFST | ||
43 | BTAST | ||
44 | BTMST | ||
45 | BTL1T | ||
46 | BTL2T | ||
47 | BTL3T | ||
48 | BTL4T | ||
49 | BTL5T | ||
50 | BFLST | ||
51 | BFAST | ||
52 | BFMST | ||
53 | BFL1T | ||
54 | BFL2T | ||
55 | BFL3T | ||
56 | BFL4T | ||
57 | BFL5T | ||
58 | BTMCT | ||
59 | BFMCT | ||
60 | BTEBT | ||
61 | BFEBT | ||
62 | BTBBTE | ||
63 | BTBBT | ||
64 | BFBBT | ||
65 | BLOAT | ||
66 | BUNLT | ||
67 | BTOTT | ||
68 | BAOBT | ||
69 | BTPATE | ||
70 | BTPAT |