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 some will be derived from event information and some will be from other systems.
...
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.
NB! The rows are bag oriented AND airport oriented. Arrival and departure oriented information are relative to the airport one row applies to.
| Row element | Element description | Comments |
|---|
11 |
|
|
|
|---|
| BagEventAirportIATA | | Excerpt Include |
|---|
| ADD:BagEventAirportIATA |
|---|
| ADD:BagEventAirportIATA |
|---|
| nopanel | true |
|---|
|
| The first elements are core information that should make the row fairly unique, but it isn't enough to guarantee uniqueness. |
2 |
| BagFirstEventDate | | Excerpt Include |
|---|
| ADD:BagFirstEventDate |
|---|
| ADD:BagFirstEventDate |
|---|
| nopanel | true |
|---|
|
|
3| NB!! |
| BagTagNumber | | Excerpt Include |
|---|
| ADD:BagTagNumber |
|---|
| ADD:BagTagNumber |
|---|
| nopanel | true |
|---|
|
|
4
|
| BagTagLeadingDigit | | Excerpt Include |
|---|
| ADD:BagTagLeadingDigit |
|---|
| ADD:BagTagLeadingDigit |
|---|
| nopanel | true |
|---|
|
|
|
| BagTagIssuerCode | | Excerpt Include |
|---|
| ADD:BagTagIssuerCode |
|---|
| ADD:BagTagIssuerCode |
|---|
| nopanel | true |
|---|
|
|
5 | 6 |
|
| BagCategory | | Excerpt Include |
|---|
| ADD:BagCategory |
|---|
| ADD:BagCategory |
|---|
| nopanel | true |
|---|
|
|
7 | |
|
| BagPnrCode | | Excerpt Include |
|---|
| ADD:BagPnrCode |
|---|
| ADD:BagPnrCode |
|---|
| nopanel | true |
|---|
|
|
7 |
|
|
|
|
|---|
| BagPreviousAirportIATA | | Excerpt Include |
|---|
| ADD:BagPreviousAirportIATA |
|---|
| ADD:BagPreviousAirportIATA |
|---|
| nopanel | true |
|---|
|
| Information about the previous airport and arrival flight are not available for bags with BagCategory = "CheckIn". |
8Verify how this is mapped from events! |
| BagArrivalFlightId | | Excerpt Include |
|---|
| ADD:BagArrivalFlightId |
|---|
| ADD:BagArrivalFlightId |
|---|
| nopanel | true |
|---|
|
|
9 | 10 | |
|
| SIBT | | Excerpt Include |
|---|
| ADD:SIBT |
|---|
| ADD:SIBT |
|---|
| nopanel | true |
|---|
|
|
|
| AIBT | | Excerpt Include |
|---|
| ADD:AIBT |
|---|
| ADD:AIBT |
|---|
| nopanel | true |
|---|
|
|
11 |
|
|
|
|
|---|
| BagNextAirportIATA | | Excerpt Include |
|---|
| ADD:BagNextAirportIATA |
|---|
| ADD:BagNextAirportIATA |
|---|
| nopanel | true |
|---|
|
| Information about the next airport and departing flight are not available for bags with BagCategory = "Final". |
12 | 13 | 14BagSOBT | BagSOBTBagSOBT15 | BagAOBT| The SOBT for the flight the bag should depart on. |
| AOBT | |
BagAOBTBagAOBT16The AOBT for the flight the bag should depart on.
|
| BagFinalAirportIATA | | Excerpt Include |
|---|
| ADD:BagFinalAirportIATA |
|---|
| ADD:BagFinalAirportIATA |
|---|
| nopanel | true |
|---|
|
|
17 | 17 | BagHandlerCode | BagHandlerCode| BagHandlerCodeArrival | | ADD: |
|---|
|
|
BagHandlerCode| BagHandlerCodeArrival | | nopanel | true |
|---|
|
|
The handling company responsible for handling the bag on this airport. If multiple companies are involved, the code for the first handling company. | NB! What is the source for this
|
| BagHandlerCodeDeparture | | Excerpt Include |
|---|
| ADD:BagHandlerCodeDeparture |
|---|
| ADD:BagHandlerCodeDeparture |
|---|
| nopanel | true |
|---|
|
|
18 | 18 |
|
|
|
|
|---|
| BagTypeIndicator | | Excerpt Include |
|---|
| ADD:BagTypeIndicator |
|---|
| ADD:BagTypeIndicator |
|---|
| nopanel | true |
|---|
|
| The next elements give information about the type/size/weight/++ of the bag. |
19 | | BagSizeIndicator | | Excerpt Include |
|---|
| ADD:BagSizeIndicator |
|---|
| ADD:BagSizeIndicator |
|---|
| nopanel | true |
|---|
|
|
20 |
|
| BagWeight | | Excerpt Include |
|---|
| ADD:BagWeight |
|---|
| ADD:BagWeight |
|---|
| nopanel | true |
|---|
|
|
|
| BagIsPriority | | Excerpt Include |
|---|
| ADD:BagIsPriority |
|---|
| ADD:BagIsPriority |
|---|
| nopanel | true |
|---|
|
|
|
| BagIsCrew | | Excerpt Include |
|---|
| ADD:BagIsCrew |
|---|
| ADD:BagIsCrew |
|---|
| nopanel | true |
|---|
|
|
21 | |
|
| BagIsRush | | Excerpt Include |
|---|
| ADD:BagIsRush |
|---|
| ADD:BagIsRush |
|---|
| nopanel | true |
|---|
|
|
|
| BagNewTagNumber | | Excerpt Include |
|---|
| ADD:BagNewTagNumber |
|---|
| ADD:BagNewTagNumber |
|---|
| nopanel | true |
|---|
|
|
|
| BagPreviousTagNumber | | Excerpt Include |
|---|
| ADD:BagPreviousTagNumber |
|---|
| ADD:BagPreviousTagNumber |
|---|
| nopanel | true |
|---|
|
|
21 |
|
|
|
|
|---|
| BagTotalTimeInBhs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInBhs |
|---|
| ADD:BagTotalTimeInBhs |
|---|
| nopanel | true |
|---|
|
| 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 | | Excerpt Include |
|---|
| ADD:BagNetTimeInBhs |
|---|
| ADD:BagNetTimeInBhs |
|---|
| nopanel | true |
|---|
|
|
23 |
|
| BagTotalTimeInMcs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInMcs |
|---|
| ADD:BagTotalTimeInMcs |
|---|
| nopanel | true |
|---|
|
|
24 | 25 | 26 | 27 |
|
| BagTotalTimeInEbs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| nopanel | true |
|---|
|
|
28 | 29| NB! Describe how to calculate this. |
| BagBhsTransportTime | | Excerpt Include |
|---|
| ADD:BagBhsTransportTime |
|---|
| ADD:BagBhsTransportTime |
|---|
| nopanel | true |
|---|
|
|
3031 | 32 | 32 | | BagEventCount | | Excerpt Include |
|---|
| ADD:BagEventCount |
|---|
| ADD:BagEventCount |
|---|
| nopanel | true |
|---|
|
| The next elements indicate how many times something happened. |
33 |
| BagInfoMsgCount | | Excerpt Include |
|---|
| ADD:BagInfoMsgCount |
|---|
| ADD:BagInfoMsgCount |
|---|
| nopanel | true |
|---|
|
|
34 |
|
| BagToMcsCount | | Excerpt Include |
|---|
| ADD:BagToMcsCount |
|---|
| ADD:BagToMcsCount |
|---|
| nopanel | true |
|---|
|
|
3536 | 36 | | BTGRT | | Excerpt Include |
|---|
| ADD:BTGRT |
|---|
| ADD:BTGRT |
|---|
| nopanel | true |
|---|
|
| This and the following elements are timestamps and some afdditional information for significant events in a bags journey. |
37 |
|
| BFCAT | | Excerpt Include |
|---|
| ADD:BFCAT |
|---|
| ADD:BFCAT |
|---|
| nopanel | true |
|---|
|
|
38 | 39 |
|
| BACIT | | Excerpt Include |
|---|
| ADD:BACIT |
|---|
| ADD:BACIT |
|---|
| nopanel | true |
|---|
|
| If the bag is checked, rejected and checked again this should be the timestamp for the last checkin. |
40 |
| BagCheckinType | | Excerpt Include |
|---|
| ADD:BagCheckinType |
|---|
| ADD:BagCheckinType |
|---|
| nopanel | true |
|---|
|
| The checkin type that was actually used and corresponds to BACIT. |
4142 |
| BABBT | | Excerpt Include |
|---|
| ADD:BABBT |
|---|
| ADD:BABBT |
|---|
| nopanel | true |
|---|
|
|
43 |
|
| BTFST | | Excerpt Include |
|---|
| ADD:BTFST |
|---|
| ADD:BTFST |
|---|
| nopanel | true |
|---|
|
|
44 |
|
| BTAST | | Excerpt Include |
|---|
| ADD:BTAST |
|---|
| ADD:BTAST |
|---|
| nopanel | true |
|---|
|
|
45 |
|
| BTMST | | Excerpt Include |
|---|
| ADD:BTMST |
|---|
| ADD:BTMST |
|---|
| nopanel | true |
|---|
|
|
46 |
|
| BTL1T | | Excerpt Include |
|---|
| ADD:BTL1T |
|---|
| ADD:BTL1T |
|---|
| nopanel | true |
|---|
|
|
47 |
|
| BTL2T | | Excerpt Include |
|---|
| ADD:BTL2T |
|---|
| ADD:BTL2T |
|---|
| nopanel | true |
|---|
|
|
48 |
|
| BTL3T | | Excerpt Include |
|---|
| ADD:BTL3T |
|---|
| ADD:BTL3T |
|---|
| nopanel | true |
|---|
|
|
49 |
|
| BTL4T | | Excerpt Include |
|---|
| ADD:BTL4T |
|---|
| ADD:BTL4T |
|---|
| nopanel | true |
|---|
|
|
50 |
|
| BTL5T | | Excerpt Include |
|---|
| ADD:BTL5T |
|---|
| ADD:BTL5T |
|---|
| nopanel | true |
|---|
|
|
51 |
|
| BFLST | | Excerpt Include |
|---|
| ADD:BFLST |
|---|
| ADD:BFLST |
|---|
| nopanel | true |
|---|
|
|
52 |
|
| BFAST | | Excerpt Include |
|---|
| ADD:BFAST |
|---|
| ADD:BFAST |
|---|
| nopanel | true |
|---|
|
|
53 |
|
| BFMST | | Excerpt Include |
|---|
| ADD:BFMST |
|---|
| ADD:BFMST |
|---|
| nopanel | true |
|---|
|
|
54 |
|
| BFL1T | | Excerpt Include |
|---|
| ADD:BFL1T |
|---|
| ADD:BFL1T |
|---|
| nopanel | true |
|---|
|
|
55 |
|
| BFL2T | | Excerpt Include |
|---|
| ADD:BFL2T |
|---|
| ADD:BFL2T |
|---|
| nopanel | true |
|---|
|
|
56 |
|
| BFL3T | | Excerpt Include |
|---|
| ADD:BFL3T |
|---|
| ADD:BFL3T |
|---|
| nopanel | true |
|---|
|
|
57 |
|
| BFL4T | | Excerpt Include |
|---|
| ADD:BFL4T |
|---|
| ADD:BFL4T |
|---|
| nopanel | true |
|---|
|
|
58 |
|
| BFL5T | | Excerpt Include |
|---|
| ADD:BFL5T |
|---|
| ADD:BFL5T |
|---|
| nopanel | true |
|---|
|
|
59 |
|
| BTMCT | | Excerpt Include |
|---|
| ADD:BTMCT |
|---|
| ADD:BTMCT |
|---|
| nopanel | true |
|---|
|
|
60 |
|
| BFMCT | | Excerpt Include |
|---|
| ADD:BFMCT |
|---|
| ADD:BFMCT |
|---|
| nopanel | true |
|---|
|
|
61 |
|
| BTEBT | | Excerpt Include |
|---|
| ADD:BTebt |
|---|
| ADD:BTebt |
|---|
| nopanel | true |
|---|
|
|
62 |
|
| BFEBT | | Excerpt Include |
|---|
| ADD:BFEBT |
|---|
| ADD:BFEBT |
|---|
| nopanel | true |
|---|
|
|
63 | BTBBTEBTBBTEBTBBTE64 |
|
| BTBBT | | Excerpt Include |
|---|
| ADD:BTBBT |
|---|
| ADD:BTBBT |
|---|
| nopanel | true |
|---|
|
|
65 |
|
| BagPlannedBin | | Excerpt Include |
|---|
| ADD:BagPlannedBin |
|---|
| ADD:BagPlannedBin |
|---|
| nopanel | true |
|---|
|
|
|
| BagActualBin | | Excerpt Include |
|---|
| ADD:BagActualBin |
|---|
| ADD:BagActualBin |
|---|
| nopanel | true |
|---|
|
|
|
| BFBBT | | Excerpt Include |
|---|
| ADD:BFBBT |
|---|
| ADD:BFBBT |
|---|
| nopanel | true |
|---|
|
|
66 |
|
| BLOAT | | Excerpt Include |
|---|
| ADD:BLOAT |
|---|
| ADD:BLOAT |
|---|
| nopanel | true |
|---|
|
|
67 |
|
| BUNLT | | Excerpt Include |
|---|
| ADD:BUNLT |
|---|
| ADD:BUNLT |
|---|
| nopanel | true |
|---|
|
|
68 |
|
| BTOTT | | Excerpt Include |
|---|
| ADD:BTOTT |
|---|
| ADD:BTOTT |
|---|
| nopanel | true |
|---|
|
|
69 |
|
| BAOBT | | Excerpt Include |
|---|
| ADD:BAOBT |
|---|
| ADD:BAOBT |
|---|
| nopanel | true |
|---|
|
|
70 |
|
| BTPATE | | Excerpt Include |
|---|
| ADD:BTPATE |
|---|
| ADD:BTPATE |
|---|
| nopanel | true |
|---|
|
|
71 |
|
| BTPAT | | Excerpt Include |
|---|
| ADD:BTPAT |
|---|
| ADD:BTPAT |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| BagWasRejected | | Excerpt Include |
|---|
| ADD:BagWasRejected |
|---|
| ADD:BagWasRejected |
|---|
| nopanel | true |
|---|
|
| The following elements are boolean flags to make selections of interesting rows easier. |
| BagWasDeliveredToBhsInTime | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsInTime |
|---|
| ADD:BagWasDeliveredToBhsInTime |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasDeliveredToBhsLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsLate |
|---|
| ADD:BagWasDeliveredToBhsLate |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasDeliveredToBhsTooLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsTooLate |
|---|
| ADD:BagWasDeliveredToBhsTooLate |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasDeliveredFromBhsInTime | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsInTime |
|---|
| ADD:BagWasDeliveredFromBhsInTime |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasDeliveredFromBhsLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsLate |
|---|
| ADD:BagWasDeliveredFromBhsLate |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasDeliveredFromBhsTooLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsTooLate |
|---|
| ADD:BagWasDeliveredFromBhsTooLate |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasSentToMcs | | Excerpt Include |
|---|
| ADD:BagWasSentToMcs |
|---|
| ADD:BagWasSentToMcs |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasSentToProblemBin | | Excerpt Include |
|---|
| ADD:BagWasSentToProblemBin |
|---|
| ADD:BagWasSentToProblemBin |
|---|
| nopanel | true |
|---|
|
|
|
| BagBsmWasProblem | | Excerpt Include |
|---|
| ADD:BagBsmWasProblem |
|---|
| ADD:BagBsmWasProblem |
|---|
| nopanel | true |
|---|
|
|
|
| BagTagWasNotSeenInBhs | | Excerpt Include |
|---|
| ADD:BagTagWasNotSeenInBhs |
|---|
| ADD:BagTagWasNotSeenInBhs |
|---|
| nopanel | true |
|---|
|
|
|
| BagHasLoadedEvent | | Excerpt Include |
|---|
| ADD:BagHasLoadedEvent |
|---|
| ADD:BagHasLoadedEvent |
|---|
| nopanel | true |
|---|
|
|
|
| BagWasLost | | Excerpt Include |
|---|
| ADD:BagWasLost |
|---|
| ADD:BagWasLost |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| BagLostIrregularityCode | | Excerpt Include |
|---|
| ADD:BagLostIrregularityCode |
|---|
| ADD:BagLostIrregularityCode |
|---|
| nopanel | true |
|---|
|
| The following elements are relevant if the bag is registered as lost. |
| BagLostAirportIATA | | Excerpt Include |
|---|
| ADD:BagLostAirportIATA |
|---|
| ADD:BagLostAirportIATA |
|---|
| nopanel | true |
|---|
|
|
|
| BagLostDate | | Excerpt Include |
|---|
| ADD:BagLostDate |
|---|
| ADD:BagLostDate |
|---|
| nopanel | true |
|---|
|
|
|
| BagLostFlightId | | Excerpt Include |
|---|
| ADD:BagLostFlightId |
|---|
| ADD:BagLostFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| BagLostAdditionalData | | Excerpt Include |
|---|
| ADD:BagLostAdditionalData |
|---|
| ADD:BagLostAdditionalData |
|---|
| nopanel | true |
|---|
|
|
|
