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 | The AirportIATA code associated with the BagEventLocation where a BagEventCode occurred. | |
2 | BagTagNumber | The 10 digit bag tag (licence plate) number as defined by IATA. The BagTagNumber is a concatenation of BagTagLeadingDigit, BagTagIssuerCode and BagTagSerialNumber. | |
3 | BagTagIssuerCode | The 3-digit IATA allocated code identifying the airline that has issued the bag tag. See BagTagNumber for information about the other parts, and AirlineIATAThreeNumeric for more information about the 3-digit IATA code. | |
4 | BagTagIssuerAirlineIATA | The AirlineIATA code corresponding to the BagTagIssuerCode. | |
5 | BagCategory | The category ("CheckIn", "Transfer", "Final") this bag belongs to. | |
6 | |||
7 | BagPreviousAirportIATA | The AirportIATA code for the airport the bag came from. Not relevant for bags that start their journey on "this" airport. | |
8 | BagArrivalFlightId | The FlightId for the flight the bag arrived on. | |
9 | BagArrivalOperatingAirlineIATA | The OperatingAirlineIATA of the BagArrivalFlightId the bag arrived on. | |
10 | |||
11 | BagNextAirportIATA | The AirportIATA code for the next airport the bag should be sent to. | |
12 | BagDepartureFlightId | The FlightId for the flight the bag is supposed to depart on. | |
13 | BagDepartureOperatingAirlineIATA | The OperatingAirlineIATA of the BagDepartureFlightId the bag departs on. | |
14 | BagSOBT | The SOBT for the flight the bag departed/is supposed to depart on. The flight is defined by BagDepartureFlightId. Always UTC. | |
15 | BagAOBT | The AOBT for the flight the bag departed on. The flight is defined by BagDepartureFlightId. Always UTC. | |
16 | BagFinalAirportIATA | The AirportIATA code for the final airport the bag should be sent to. | |
17 | |||
18 | BagHandlerCode | The HandlerCode for the Handler that is responsible for handling the baggage. | |
19 | |||
20 | BagTypeIndicator | Indication if baggage contains special goods. | |
21 | BagSizeIndicator | Indication if baggage is unconventional size or weight. | |
22 | BagWeight | The weight (in kilos) of one bag. | |
23 | |||
24 | BagTotalBhsDuration | BagTotalTimeInBhs | |
25 | BagNetBhsDuration | BagNetlTimeInBhs (BagTotalTimeInBhs-EBS) | |
26 | BagTotalTimeInMcs | The "Bag Total Time In MCS" is the duration the bag has spent in a manual coding station (MCS) in total. Multiple visits to MCS by a bag is possible and must be added to provide a correct BagTotalTimeInMcs. If the bag is only once in MCS then BagTotalTimeInMcs = BFMCT - BTMCT | |
27 | BagTotalTimeAtSecScreen | ||
28 | BagTimeAtManSecScreen | ||
29 | BagTimeAtAutSecScreen | ||
30 | BagTotalTimeInEbs | ||
31 | |||
32 | BagEventCount | The BagEventCount is normally for one bag on one airport, but can be for one bag on all airports, for one flight or for any given period. | |
33 | BagInfoMsgCount | ||
34 | BagToMcsCount | The BagToMcsCount is the number of times a bag has been to a manual coding station on one airport. | |
35 | BagBhsBinDeliveryAttempts | The number of times the baggage handling system has tried to deliver a given bag to a bin. Should normally be '1', but can be much more in bin full conditions or with other BHS related problems. | |
36 | |||
37 | BTGRT | The "Bag Tag Generated Time" is the DateTimeUTC when the bag tag was generated (printed). This will typically result in the generation of a bag source message (BSM). BTGRT corresponds to the BagEventCode "BagTagGenerated". Always UTC. | |
38 | BFCAT | The "Bag First Check in Attempt Time" is the DateTimeUTC when the bag first was attempted checked in. For most bags this will be the same as BACIT as they do not experience a BagRejected event. This corresponds to the first "BagChecked" or "BagCheckInAttempt" BagEventCode. Always UTC. | |
39 | BagFirstRejectReason | The reason for the first rejection of a check in attempt for the bag. This would typically be at a self service baggage drop (SBD). The reason would typically come from the BagEventDescription of the first BagRejected event. | |
40 | BACIT | The "Bag Actual Checked In Time" is the DateTimeUTC when the bag was checked and delivered to the baggage handling system. This corresponds to the BagEventCode "BagChecked". This should occur when it is impossible for the passenger to decide not to check the baggage after all. It is however possible for the bag to be rejected for technical reasons (too long). Always UTC. | |
41 | BABBT | The "Bag Accepted By BHS Time" is the DateTimeUTC when the bag was checked and delivered to the baggage handling system (BHS). This corresponds to the BagEventCode "BagAcceptedByBhs". The bag is now under the control of the BHS and can't be accessed by the passenger. Always UTC. | |
42 | BTFST | The "Bag To First Security screening Time" is the DateTimeUTC when the first security screening of the bag started. This corresponds to the first BagEventCode "BagToSecScreen". Multiple security screenings of a bag is possible, but will not change BTFST. Always UTC. | |
43 | BTAST | The "Bag To Automatic Security screening Time" is the DateTimeUTC when the (first) automatic security screening of the bag started. This corresponds to the (first) BagEventCode "BagToSecScreen" for an automatic security screening. Multiple security screenings of a bag is possible, but will not change BTAST. Always UTC. | |
44 | BTMST | The "Bag To Manual Security screening Time" is the DateTimeUTC when the (first) manual security scan of the bag started. This corresponds to the (first) BagEventCode "BagToSecScreen" for a manual security screening. Multiple security screenings of a bag is possible, but will not change BTMST. Always UTC. | |
45 | BTL1T | The "Bag To L1 security screening Time" is the DateTimeUTC when the Level 1 security scan of the bag started. This corresponds to the BagEventCode "BagToSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 1 security screening. Always UTC. | |
46 | BTL2T | The "Bag To L2 security screening Time" is the DateTimeUTC when the Level 2 security scan of the bag started. This corresponds to the BagEventCode "BagToSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 2 security screening. Always UTC. | |
47 | BTL3T | The "Bag To L3 security screening Time" is the DateTimeUTC when the Level 3 security scan of the bag started. This corresponds to the BagEventCode "BagToSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 3 security screening. Always UTC. | |
48 | BTL4T | The "Bag To L4 security screening Time" is the DateTimeUTC when the Level 4 security scan of the bag started. This corresponds to the BagEventCode "BagToSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 4 security screening. Always UTC. | |
49 | BTL5T | The "Bag To L5 security screening Time" is the DateTimeUTC when the Level 5 security scan of the bag started. This corresponds to the BagEventCode "BagToSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 5 security screening. Always UTC. | |
50 | BFLST | The "Bag From Last Security screening Time" is the DateTimeUTC when the security screening of the bag is finished. This corresponds to the last BagEventCode "BagFromSecScreen". Multiple security scans of a bag is possible, all should update BFLST. Always UTC. | |
51 | BFAST | The "Bag From Automatic Security screening Time" is the DateTimeUTC when the (last) automatic security screening of the bag finished. This corresponds to the (last) BagEventCode "BagFromSecScreen" for automatic security screening. Multiple security screenings of a bag is possible, all should update BFAST. Always UTC. | |
52 | BFMST | The "Bag From Manual Security screening Time" is the DateTimeUTC when the (last) manual security screening of the bag finished. This corresponds to the (last) BagEventCode "BagFromSecScreen" for a manual security screening. Multiple manual security screenings of a bag is possible, all should update BFMST. Always UTC. | |
53 | BFL1T | The "Bag From L1 security screening Time" is the DateTimeUTC when the Level 1 security scan of the bag finished. This corresponds to the BagEventCode "BagFromSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 1 security screening. Always UTC. | |
54 | BFL2T | The "Bag From L2 security screening Time" is the DateTimeUTC when the Level 2 security scan of the bag finished. This corresponds to the BagEventCode "BagFromSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 2 security screening. Always UTC. | |
55 | BFL3T | The "Bag From L3 security screening Time" is the DateTimeUTC when the Level 3 security scan of the bag finished. This corresponds to the BagEventCode "BagFromSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 3 security screening. Always UTC. | |
56 | BFL4T | The "Bag From L4 security screening Time" is the DateTimeUTC when the Level 4 security scan of the bag finished. This corresponds to the BagEventCode "BagFromSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 4 security screening. Always UTC. | |
57 | BFL5T | The "Bag From L5 security screening Time" is the DateTimeUTC when the Level 5 security scan of the bag finished. This corresponds to the BagEventCode "BagFromSecScreen", with some additional information (typically BagEventLocation) identifying it as a Level 5 security screening. Always UTC. | |
58 | BTMCT | The "Bag To Manual Coding station Time" is the DateTimeUTC when the bag first enters a manual coding station (MCS). This corresponds to the BagEventCode "BagToMCS". Multiple visits to MCS by a bag is possible, but will not change BTMCT. Always UTC. | |
59 | BFMCT | The "Bag From Manual Coding station Time" is the DateTimeUTC when the bag enters a manual coding station (MCS) for the last time. This corresponds to the last BagEventCode "BagFromMCS". Multiple visits to MCS by a bag is possible. Each visit will update the BFMCT. Always UTC. | |
60 | BTEBT | The "Bag To Early Bag storage Time" is the DateTimeUTC when the bag first enters an early bag store (EBS). This corresponds to the first BagEventCode "BagToEBS". Multiple visits to EBS by a bag is unlikely, and will not change BTEBT. Always UTC. | |
61 | BFEBT | The "Bag From Early Bag Store Time" is the DateTimeUTC when the bag left the early bag store (EBS) for the last time. This corresponds to the (last) BagEventCode "BagFromEBS". Multiple visits to EBS is unlikely, but when leaving all should update BFEBT. Always UTC. | |
62 | BTBBTE | ||
63 | BTBBT | The "Bag To BHS BinTime" is the DateTimeUTC when the baggage handling system actually delivered the bag for further handling. This will typically be, for baggage handling systems with sorting, when the bag is placed in a bin. This corresponds to the BagEventCode "BagToBhsBin". Always UTC. An estimate of this timestamp is defined by BEBFT. | |
64 | BFBBT | The "Bag From BHS BinTime" is the DateTimeUTC when the bag is removed from the BHS bin (or any other place a BHS might have delivered the bag). This will typically be when a handler places the bag in a cart or a container. This corresponds to the BagEventCode "BagFromBhsBin". Always UTC. | |
65 | BLOAT | The "Bag Loaded Time" is the DateTimeUTC for the last BagLoaded event. The timestamp can indicate when the bag was loaded into a container, or when it was loaded onto an aircraft. This corresponds to the last BagEventCode "BagLoaded". Always UTC. | |
66 | BUNLT | The "Bag Unloaded From Aircraft Time" is the DateTimeUTC when the bag was unloaded from the aircraft. This corresponds to the BagEventCode "BagUnloaded". Always UTC. | |
67 | BTOTT | The "Bag To Transfer Time" is the DateTimeUTC when the bag is delivered to transfer processing. This corresponds to the BagEventCode "BagToTransfer". Always UTC. | |
68 | BAOBT | The Bag Actual On Belt Time is the DateTimeUTC when the bag actually is placed on the baggage belt/carousel and soon will be ready for pick up by the passenger. This corresponds to the BagEventCode "BagOnBelt". Always UTC. | |
69 | BTPATE | The "Bag To Passenger Time Estimate" is the DateTimeUTC when the bag is estimated to be made directly available to the passenger. This is an estimate of when the BagEventCode "BagToPassenger" will occur. This is an estimate of the timestamp BTPAT. Always UTC. | |
70 | BTPAT | The "Bag To Passenger Time" is the DateTimeUTC when the bag is made directly available to the passenger. This corresponds to the BagEventCode "BagToPassenger". Always UTC. An estimate of this timestamp is defined by BTPATE. |