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.
Row element | Element description | Comments | |
---|---|---|---|
1 | BagEventAirportIATA | The AirportIATA code associated with the BagEventLocation where a BagEventCode occurred. | The first elements are core information that should make the row fairly unique, but it isn't enough to guarantee uniqueness. |
2 | BagFirstEventDate | ?? The date of the first bag event for this bag tag on the BagEventAirportIATA | |
3 | BagTagNumber | The 10 digit bag tag (licence plate) number as defined by IATA. The BagTagNumber is a concatenation of BagTagLeadingDigit, BagTagIssuerCode and BagTagSerialNumber. | |
4 | 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. | |
5 | BagTagIssuerAirlineIATA | The AirlineIATA code corresponding to the BagTagIssuerCode. | |
6 | BagCategory | The category ("CheckIn", "Transfer", "Final") this bag belongs to. | |
7 | |||
8 | BagPreviousAirportIATA | The AirportIATA code for the airport the bag came from. Not relevant for bags that start their journey on "this" airport. | Information about the previous airport and arrival flight are not available for bags with BagCategory = "CheckIn". |
9 | BagArrivalFlightId | The FlightId for the flight the bag arrived on. | |
10 | BagArrivalOperatingAirlineIATA | The OperatingAirlineIATA of the BagArrivalFlightId the bag arrived on. | |
11 | |||
12 | BagNextAirportIATA | The AirportIATA code for the next airport the bag should be sent to. | Information about the next airport and departing flight are not available for bags with BagCategory = "Final". |
13 | BagDepartureFlightId | The FlightId for the flight the bag is supposed to depart on. | |
14 | BagDepartureOperatingAirlineIATA | The OperatingAirlineIATA of the BagDepartureFlightId the bag departs on. | |
15 | BagSOBT | The SOBT for the flight the bag departed/is supposed to depart on. The flight is defined by BagDepartureFlightId. Always UTC. | |
16 | BagAOBT | The AOBT for the flight the bag departed on. The flight is defined by BagDepartureFlightId. Always UTC. | |
17 | BagFinalAirportIATA | The AirportIATA code for the final airport the bag should be sent to. | |
18 | |||
19 | BagHandlerCode | The HandlerCode for the Handler that is responsible for handling the baggage. | The handling company responsible for handling the bag on this airport. If multiple companies are involved, the code for the first handling company. |
20 | |||
21 | BagTypeIndicator | Indication if baggage contains special goods. | The next elements give information about the type/size/weight/++ of the bag. |
22 | BagSizeIndicator | Indication if baggage is unconventional size or weight. | |
23 | BagWeight | The weight (in kilos) of one bag. | |
24 | |||
25 | BagTotalTimeInBhs | The "Bag Total Time In BHS" is the duration the bag has spent in the baggage handling system. BagTotalTimeInBhs = BTBBT - BACIT | The next elements indicates how much time the bag used in different parts of the baggage handling system, if relevant (a BHS was used). |
26 | BagNetTimeInBhs | The "Bag Net Time In BHS" is the duration the bag has spent in the baggage handling system, excluding time spent in early bag storage. BagNetTimeInBhs = BagTotalTimeInBhs - BagTotalTimeInEbs | |
27 | 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 | |
28 | BagTotalTimeAtSecScreen | The "Bag Total Time At Security Screening" is the total duration the bag has spent at security screening. BagTotalTimeAtSecScreen = BFLST - BTFST | |
29 | BagTimeAtAutSecScreen | The "Bag Time At Automatic Security Screening" is the duration the bag has spent at automatic security screening. BagTimeAtAutSecScreen = BFAST - BTAST | |
30 | BagTimeAtManSecScreen | The "Bag Time At Manual Security Screening" is the duration the bag has spent at manual security screening. BagTimeAtManSecScreen = BFMST - BTMST | |
31 | BagTotalTimeInEbs | The "Bag Total Time In EBS" is the duration the bag has spent in an EBS in total. Multiple visits to EBS by a bag is rare, but possible and must be added to provide a correct BagTotalTimeInEbs. If the bag is only once in EBS then BagTotalTimeInEbs = BFEBT - BTEBT | |
32 | |||
33 | 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. | The next elements indicate how many times something happened. |
34 | BagInfoMsgCount | ||
35 | BagToMcsCount | The BagToMcsCount is the number of times a bag has been to a manual coding station on one airport. | |
36 | 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. | |
37 | |||
38 | 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. | This and the following elements are timestamps and some afdditional information for significant events in a bags journey. |
39 | 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. | |
40 | 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. | |
41 | 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. | If the bag is checked, rejected and checked again this should be the timestamp for the last checkin. |
42 | BagCheckinType | Indicates how the bag was checked in. This can typically be derived from BagEventLocation. | The checkin type that was actually used and corresponds to BACIT. |
43 | BagCheckinLocation | The location where a bag was checked in. This will typically be the BagEventLocation of the BagChecked event. The BagCheckinLocation must correspond to the BagCheckinType. For instance, if the BagCheckinType = "SBD" then the location should be one of the self service baggage drop locations. | The checkin location that was actually used and corresponds to BACIT. |
44 | 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. | |
45 | 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. | |
46 | 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. | |
47 | 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. | |
48 | 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. | |
49 | 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. | |
50 | 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. | |
51 | 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. | |
52 | 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. | |
53 | 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. | |
54 | 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. | |
55 | 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. | |
56 | 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. | |
57 | 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. | |
58 | 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. | |
59 | 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. | |
60 | 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. | |
61 | 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. | |
62 | 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. | |
63 | 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. | |
64 | 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. | |
65 | BTBBTE | ||
66 | 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. | |
67 | 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. | |
68 | 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. | |
69 | 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. | |
70 | 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. | |
71 | 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. | |
72 | 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. | |
73 | 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. |