| Row element | Element description | Comments |
|---|
| 1 |
|
|
|
|---|
| 1 | 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 | BagTagNumber | | Excerpt Include |
|---|
| ADD:BagTagNumber |
|---|
| ADD:BagTagNumber |
|---|
| nopanel | true |
|---|
|
|
|
| 4 | BagTagIssuerCode | | Excerpt Include |
|---|
| ADD:BagTagIssuerCode |
|---|
| ADD:BagTagIssuerCode |
|---|
| nopanel | true |
|---|
|
|
|
| 5 | BagTagIssuerAirlineIATA | | Excerpt Include |
|---|
| ADD:BagTagIssuerAirlineIATA |
|---|
| ADD:BagTagIssuerAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| 6 | BagCategory | | Excerpt Include |
|---|
| ADD:BagCategory |
|---|
| ADD:BagCategory |
|---|
| nopanel | true |
|---|
|
|
|
| 7 |
|
|
|
|---|
| 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". |
| 8 | BagArrivalFlightId | | Excerpt Include |
|---|
| ADD:BagArrivalFlightId |
|---|
| ADD:BagArrivalFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| 9 | BagArrivalOperatingAirlineIATA | | Excerpt Include |
|---|
| ADD:BagArrivalOperatingAirlineIATA |
|---|
| ADD:BagArrivalOperatingAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| 10 |
|
|
|
| 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 | BagDepartureFlightId | | Excerpt Include |
|---|
| ADD:BagDepartureFlightId |
|---|
| ADD:BagDepartureFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| 13 | BagDepartureOperatingAirlineIATA | | Excerpt Include |
|---|
| ADD:BagDepartureOperatingAirlineIATA |
|---|
| ADD:BagDepartureOperatingAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| 14 | BagSOBT | | Excerpt Include |
|---|
| ADD:BagSOBT |
|---|
| ADD:BagSOBT |
|---|
| nopanel | true |
|---|
|
|
|
| 15 | BagAOBT | | Excerpt Include |
|---|
| ADD:BagAOBT |
|---|
| ADD:BagAOBT |
|---|
| nopanel | true |
|---|
|
|
|
| 16 | BagFinalAirportIATA | | Excerpt Include |
|---|
| ADD:BagFinalAirportIATA |
|---|
| ADD:BagFinalAirportIATA |
|---|
| nopanel | true |
|---|
|
|
|
| 17 |
|
|
|
|---|
| 17 | BagHandlerCode | | Excerpt Include |
|---|
| ADD:BagHandlerCode |
|---|
| ADD:BagHandlerCode |
|---|
| 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. |
| 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 |
|---|
|
|
|
| 21 |
|
|
|
|---|
| 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 | BagTotalTimeAtSecScreen | | Excerpt Include |
|---|
| ADD:BagTotalTimeAtSecScreen |
|---|
| ADD:BagTotalTimeAtSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| 25 | BagTimeAtAutSecScreen | | Excerpt Include |
|---|
| ADD:BagTimeAtAutSecScreen |
|---|
| ADD:BagTimeAtAutSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| 26 | BagTimeAtManSecScreen | | Excerpt Include |
|---|
| ADD:BagTimeAtManSecScreen |
|---|
| ADD:BagTimeAtManSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| 27 | BagTotalTimeInEbs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| nopanel | true |
|---|
|
|
|
| 28 | BagBhsDeliveryAttemptsTime | | Excerpt Include |
|---|
| ADD:BagBhsDeliveryAttemptsTime |
|---|
| ADD:BagBhsDeliveryAttemptsTime |
|---|
| nopanel | true |
|---|
|
|
|
| 29 | BagBhsTransportTime | | Excerpt Include |
|---|
| ADD:BagBhsTransportTime |
|---|
| ADD:BagBhsTransportTime |
|---|
| nopanel | true |
|---|
|
|
|
| 30 | BagBhsTimeExceededBy | | Excerpt Include |
|---|
| ADD:BagBhsTimeExceededBy |
|---|
| ADD:BagBhsTimeExceededBy |
|---|
| nopanel | true |
|---|
|
|
|
| 31 | BagBhsTimeExceededGroup | | Excerpt Include |
|---|
| ADD:BagBhsTimeExceededGroup |
|---|
| ADD:BagBhsTimeExceededGroup |
|---|
| nopanel | true |
|---|
|
|
|
| 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 |
|---|
|
|
|
| 35 | BagBhsBinDeliveryAttempts | | Excerpt Include |
|---|
| ADD:BagBhsBinDeliveryAttempts |
|---|
| ADD:BagBhsBinDeliveryAttempts |
|---|
| nopanel | true |
|---|
|
|
|
| 36 |
|
|
|
|---|
| 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 | BagTagPrintedLocation | | Excerpt Include |
|---|
| ADD:BagTagPrintedLocation |
|---|
| ADD:BagTagPrintedLocation |
|---|
| nopanel | true |
|---|
|
|
|
| 38 | BFCAT | | Excerpt Include |
|---|
| ADD:BFCAT |
|---|
| ADD:BFCAT |
|---|
| nopanel | true |
|---|
|
|
|
| 39 | BagFirstRejectReason | | Excerpt Include |
|---|
| ADD:BagFirstRejectReason |
|---|
| ADD:BagFirstRejectReason |
|---|
| nopanel | true |
|---|
|
|
|
| 40 | 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. |
| 41 | BagCheckinType | | Excerpt Include |
|---|
| ADD:BagCheckinType |
|---|
| ADD:BagCheckinType |
|---|
| nopanel | true |
|---|
|
| The checkin type that was actually used and corresponds to BACIT. |
| 42 | BagCheckinLocation | | Excerpt Include |
|---|
| ADD:BagCheckinLocation |
|---|
| ADD:BagCheckinLocation |
|---|
| nopanel | true |
|---|
|
| The checkin location that was actually used and corresponds to BACIT. |
| 43 | BABBT | | Excerpt Include |
|---|
| ADD:BABBT |
|---|
| ADD:BABBT |
|---|
| nopanel | true |
|---|
|
|
|
| 44 | BTFST | | Excerpt Include |
|---|
| ADD:BTFST |
|---|
| ADD:BTFST |
|---|
| nopanel | true |
|---|
|
|
|
| 45 | BTAST | | Excerpt Include |
|---|
| ADD:BTAST |
|---|
| ADD:BTAST |
|---|
| nopanel | true |
|---|
|
|
|
| 46 | BTMST | | Excerpt Include |
|---|
| ADD:BTMST |
|---|
| ADD:BTMST |
|---|
| nopanel | true |
|---|
|
|
|
| 47 | BTL1T | | Excerpt Include |
|---|
| ADD:BTL1T |
|---|
| ADD:BTL1T |
|---|
| nopanel | true |
|---|
|
|
|
| 48 | BTL2T | | Excerpt Include |
|---|
| ADD:BTL2T |
|---|
| ADD:BTL2T |
|---|
| nopanel | true |
|---|
|
|
|
| 49 | BTL3T | | Excerpt Include |
|---|
| ADD:BTL3T |
|---|
| ADD:BTL3T |
|---|
| nopanel | true |
|---|
|
|
|
| 50 | BTL4T | | Excerpt Include |
|---|
| ADD:BTL4T |
|---|
| ADD:BTL4T |
|---|
| nopanel | true |
|---|
|
|
|
| 51 | BTL5T | | Excerpt Include |
|---|
| ADD:BTL5T |
|---|
| ADD:BTL5T |
|---|
| nopanel | true |
|---|
|
|
|
| 52 | BFLST | | Excerpt Include |
|---|
| ADD:BFLST |
|---|
| ADD:BFLST |
|---|
| nopanel | true |
|---|
|
|
|
| 53 | BFAST | | Excerpt Include |
|---|
| ADD:BFAST |
|---|
| ADD:BFAST |
|---|
| nopanel | true |
|---|
|
|
|
| 54 | BFMST | | Excerpt Include |
|---|
| ADD:BFMST |
|---|
| ADD:BFMST |
|---|
| nopanel | true |
|---|
|
|
|
| 55 | BFL1T | | Excerpt Include |
|---|
| ADD:BFL1T |
|---|
| ADD:BFL1T |
|---|
| nopanel | true |
|---|
|
|
|
| 56 | BFL2T | | Excerpt Include |
|---|
| ADD:BFL2T |
|---|
| ADD:BFL2T |
|---|
| nopanel | true |
|---|
|
|
|
| 57 | BFL3T | | Excerpt Include |
|---|
| ADD:BFL3T |
|---|
| ADD:BFL3T |
|---|
| nopanel | true |
|---|
|
|
|
| 58 | BFL4T | | Excerpt Include |
|---|
| ADD:BFL4T |
|---|
| ADD:BFL4T |
|---|
| nopanel | true |
|---|
|
|
|
| 59 | BFL5T | | Excerpt Include |
|---|
| ADD:BFL5T |
|---|
| ADD:BFL5T |
|---|
| nopanel | true |
|---|
|
|
|
| 60 | BTMCT | | Excerpt Include |
|---|
| ADD:BTMCT |
|---|
| ADD:BTMCT |
|---|
| nopanel | true |
|---|
|
|
|
| 61 | BFMCT | | Excerpt Include |
|---|
| ADD:BFMCT |
|---|
| ADD:BFMCT |
|---|
| nopanel | true |
|---|
|
|
|
| 62 | BTEBT | | Excerpt Include |
|---|
| ADD:BTebt |
|---|
| ADD:BTebt |
|---|
| nopanel | true |
|---|
|
|
|
| 63 | BFEBT | | Excerpt Include |
|---|
| ADD:BFEBT |
|---|
| ADD:BFEBT |
|---|
| nopanel | true |
|---|
|
|
|
| 64 | BTBBTE | | Excerpt Include |
|---|
| ADD:BTBBTE |
|---|
| ADD:BTBBTE |
|---|
| nopanel | true |
|---|
|
|
|
| 65 | BTBBT | | Excerpt Include |
|---|
| ADD:BTBBT |
|---|
| ADD:BTBBT |
|---|
| nopanel | true |
|---|
|
|
|
| 66 | BagPlannedBin | | Excerpt Include |
|---|
| ADD:BagPlannedBin |
|---|
| ADD:BagPlannedBin |
|---|
| nopanel | true |
|---|
|
|
|
| 67 | BagActualBin | | Excerpt Include |
|---|
| ADD:BagActualBin |
|---|
| ADD:BagActualBin |
|---|
| nopanel | true |
|---|
|
|
|
| 68 | BFBBT | | Excerpt Include |
|---|
| ADD:BFBBT |
|---|
| ADD:BFBBT |
|---|
| nopanel | true |
|---|
|
|
|
| 69 | BLOAT | | Excerpt Include |
|---|
| ADD:BLOAT |
|---|
| ADD:BLOAT |
|---|
| nopanel | true |
|---|
|
|
|
| 70 | BUNLT | | Excerpt Include |
|---|
| ADD:BUNLT |
|---|
| ADD:BUNLT |
|---|
| nopanel | true |
|---|
|
|
|
| 71 | BTOTT | | Excerpt Include |
|---|
| ADD:BTOTT |
|---|
| ADD:BTOTT |
|---|
| nopanel | true |
|---|
|
|
|
| 72 | BAOBT | | Excerpt Include |
|---|
| ADD:BAOBT |
|---|
| ADD:BAOBT |
|---|
| nopanel | true |
|---|
|
|
|
| 73 | BTPATE | | Excerpt Include |
|---|
| ADD:BTPATE |
|---|
| ADD:BTPATE |
|---|
| nopanel | true |
|---|
|
|
|
| 74 | BTPAT | | Excerpt Include |
|---|
| ADD:BTPAT |
|---|
| ADD:BTPAT |
|---|
| nopanel | true |
|---|
|
|
|
| 75 |
|
|
|
|---|
| 75 | BagWasRejected | | Excerpt Include |
|---|
| ADD:BagWasRejected |
|---|
| ADD:BagWasRejected |
|---|
| nopanel | true |
|---|
|
| The following elements are boolean flags to make selections of interesting rows easier. |
| 76 | BagWasDeliveredToBhsInTime | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsInTime |
|---|
| ADD:BagWasDeliveredToBhsInTime |
|---|
| nopanel | true |
|---|
|
|
|
| 77 | BagWasDeliveredToBhsLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsLate |
|---|
| ADD:BagWasDeliveredToBhsLate |
|---|
| nopanel | true |
|---|
|
|
|
| 78 | BagWasDeliveredToBhsTooLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredToBhsTooLate |
|---|
| ADD:BagWasDeliveredToBhsTooLate |
|---|
| nopanel | true |
|---|
|
|
|
| 79 | BagWasDeliveredFromBhsInTime | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsInTime |
|---|
| ADD:BagWasDeliveredFromBhsInTime |
|---|
| nopanel | true |
|---|
|
|
|
| 80 | BagWasDeliveredFromBhsLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsLate |
|---|
| ADD:BagWasDeliveredFromBhsLate |
|---|
| nopanel | true |
|---|
|
|
|
| 81 | BagWasDeliveredFromBhsTooLate | | Excerpt Include |
|---|
| ADD:BagWasDeliveredFromBhsTooLate |
|---|
| ADD:BagWasDeliveredFromBhsTooLate |
|---|
| nopanel | true |
|---|
|
|
|
| 82 | BagWasSentToMcs | | Excerpt Include |
|---|
| ADD:BagWasSentToMcs |
|---|
| ADD:BagWasSentToMcs |
|---|
| nopanel | true |
|---|
|
|
|
| 83 | BagWasSentToProblemBin | | Excerpt Include |
|---|
| ADD:BagWasSentToProblemBin |
|---|
| ADD:BagWasSentToProblemBin |
|---|
| nopanel | true |
|---|
|
|
|
| 84 | BagBsmWasProblem | | Excerpt Include |
|---|
| ADD:BagBsmWasProblem |
|---|
| ADD:BagBsmWasProblem |
|---|
| nopanel | true |
|---|
|
|
|
| 85 | BagTagWasNotSeenInBhs | | Excerpt Include |
|---|
| ADD:BagTagWasNotSeenInBhs |
|---|
| ADD:BagTagWasNotSeenInBhs |
|---|
| nopanel | true |
|---|
|
|
|
| 86 | BagHasLoadedEvent | | Excerpt Include |
|---|
| ADD:BagHasLoadedEvent |
|---|
| ADD:BagHasLoadedEvent |
|---|
| nopanel | true |
|---|
|
|
|
| 87 | BagWasLost | | Excerpt Include |
|---|
| ADD:BagWasLost |
|---|
| ADD:BagWasLost |
|---|
| nopanel | true |
|---|
|
|
|
| 88 |
|
|
|
|---|
| 88 | BagLostIrregularityCode | | Excerpt Include |
|---|
| ADD:BagLostIrregularityCode |
|---|
| ADD:BagLostIrregularityCode |
|---|
| nopanel | true |
|---|
|
| The following elements are relevant if the bag is registered as lost. |
| 89 | BagLostAirportIATA | | Excerpt Include |
|---|
| ADD:BagLostAirportIATA |
|---|
| ADD:BagLostAirportIATA |
|---|
| nopanel | true |
|---|
|
|
|
| 90 | BagLostDate | | Excerpt Include |
|---|
| ADD:BagLostDate |
|---|
| ADD:BagLostDate |
|---|
| nopanel | true |
|---|
|
|
|
| 91 | BagLostFlightId | | Excerpt Include |
|---|
| ADD:BagLostFlightId |
|---|
| ADD:BagLostFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| 92 | BagLostAdditionalData | | Excerpt Include |
|---|
| ADD:BagLostAdditionalData |
|---|
| ADD:BagLostAdditionalData |
|---|
| nopanel | true |
|---|
|
|
|
