| Row element | Element description | Comments |
|---|
|
|
|
|---|
| 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. |
| BagFirstEventDate | | Excerpt Include |
|---|
| ADD:BagFirstEventDate |
|---|
| ADD:BagFirstEventDate |
|---|
| nopanel | true |
|---|
|
| NB!! |
| BagTagNumber | | Excerpt Include |
|---|
| ADD:BagTagNumber |
|---|
| ADD:BagTagNumber |
|---|
| nopanel | true |
|---|
|
|
|
| BagTagLeadingDigit | | Excerpt Include |
|---|
| ADD:BagTagLeadingDigit |
|---|
| ADD:BagTagLeadingDigit |
|---|
| nopanel | true |
|---|
|
|
|
| BagTagIssuerCode | | Excerpt Include |
|---|
| ADD:BagTagIssuerCode |
|---|
| ADD:BagTagIssuerCode |
|---|
| nopanel | true |
|---|
|
|
|
| BagTagIssuerAirlineIATA | | Excerpt Include |
|---|
| ADD:BagTagIssuerAirlineIATA |
|---|
| ADD:BagTagIssuerAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| BagCategory | | Excerpt Include |
|---|
| ADD:BagCategory |
|---|
| ADD:BagCategory |
|---|
| nopanel | true |
|---|
|
|
|
| BagPnrCode | | Excerpt Include |
|---|
| ADD:BagPnrCode |
|---|
| ADD:BagPnrCode |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| 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". Verify how this is mapped from events! |
| BagArrivalFlightId | | Excerpt Include |
|---|
| ADD:BagArrivalFlightId |
|---|
| ADD:BagArrivalFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| BagArrivalOperatingAirlineIATA | | Excerpt Include |
|---|
| ADD:BagArrivalOperatingAirlineIATA |
|---|
| ADD:BagArrivalOperatingAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| SIBT | | Excerpt Include |
|---|
| ADD:SIBT |
|---|
| ADD:SIBT |
|---|
| nopanel | true |
|---|
|
|
|
| AIBT | | Excerpt Include |
|---|
| ADD:AIBT |
|---|
| ADD:AIBT |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| 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". |
| BagDepartureFlightId | | Excerpt Include |
|---|
| ADD:BagDepartureFlightId |
|---|
| ADD:BagDepartureFlightId |
|---|
| nopanel | true |
|---|
|
|
|
| BagDepartureOperatingAirlineIATA | | Excerpt Include |
|---|
| ADD:BagDepartureOperatingAirlineIATA |
|---|
| ADD:BagDepartureOperatingAirlineIATA |
|---|
| nopanel | true |
|---|
|
|
|
| SOBT | | Excerpt Include |
|---|
| ADD:SOBT |
|---|
| ADD:SOBT |
|---|
| nopanel | true |
|---|
|
| The SOBT for the flight the bag should depart on. |
| AOBT | | Excerpt Include |
|---|
| ADD:AOBT |
|---|
| ADD:AOBT |
|---|
| nopanel | true |
|---|
|
| The AOBT for the flight the bag should depart on.
|
| BagFinalAirportIATA | | Excerpt Include |
|---|
| ADD:BagFinalAirportIATA |
|---|
| ADD:BagFinalAirportIATA |
|---|
| nopanel | true |
|---|
|
| NB! Describe mapping from events |
|
|
|
|---|
BagHandlerCodeArrival | | Excerpt Include |
|---|
| ADD:BagHandlerCodeArrival |
|---|
| ADD:BagHandlerCodeArrival |
|---|
| nopanel | true |
|---|
|
| NB! What is the source for this
|
| BagHandlerCodeDeparture | | Excerpt Include |
|---|
| ADD:BagHandlerCodeDeparture |
|---|
| ADD:BagHandlerCodeDeparture |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| BagTypeIndicator | | Excerpt Include |
|---|
| ADD:BagTypeIndicator |
|---|
| ADD:BagTypeIndicator |
|---|
| nopanel | true |
|---|
|
| The next elements give information about the type/size/weight/++ of the bag. |
| BagSizeIndicator | | Excerpt Include |
|---|
| ADD:BagSizeIndicator |
|---|
| ADD:BagSizeIndicator |
|---|
| nopanel | true |
|---|
|
|
|
| BagWeight | | Excerpt Include |
|---|
| ADD:BagWeight |
|---|
| ADD:BagWeight |
|---|
| nopanel | true |
|---|
|
|
|
| BagIsPrio | | Excerpt Include |
|---|
| ADD:BagIsPrio |
|---|
| ADD:BagIsPrio |
|---|
| nopanel | true |
|---|
|
|
|
| BagIsCrew | | Excerpt Include |
|---|
| ADD:BagIsCrew |
|---|
| ADD:BagIsCrew |
|---|
| nopanel | true |
|---|
|
|
|
| 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 |
|---|
|
|
|
|
|
|
|---|
| 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). |
| BagNetTimeInBhs | | Excerpt Include |
|---|
| ADD:BagNetTimeInBhs |
|---|
| ADD:BagNetTimeInBhs |
|---|
| nopanel | true |
|---|
|
|
|
| BagTotalTimeInMcs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInMcs |
|---|
| ADD:BagTotalTimeInMcs |
|---|
| nopanel | true |
|---|
|
|
|
| BagTotalTimeAtSecScreen | | Excerpt Include |
|---|
| ADD:BagTotalTimeAtSecScreen |
|---|
| ADD:BagTotalTimeAtSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| BagTimeAtAutSecScreen | | Excerpt Include |
|---|
| ADD:BagTimeAtAutSecScreen |
|---|
| ADD:BagTimeAtAutSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| BagTimeAtManSecScreen | | Excerpt Include |
|---|
| ADD:BagTimeAtManSecScreen |
|---|
| ADD:BagTimeAtManSecScreen |
|---|
| nopanel | true |
|---|
|
|
|
| BagTotalTimeInEbs | | Excerpt Include |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| ADD:BagTotalTimeInEbs |
|---|
| nopanel | true |
|---|
|
|
|
| BagBhsDeliveryAttemptsTime | | Excerpt Include |
|---|
| ADD:BagBhsDeliveryAttemptsTime |
|---|
| ADD:BagBhsDeliveryAttemptsTime |
|---|
| nopanel | true |
|---|
|
| NB! Describe how to calculate this. |
| BagBhsTransportTime | | Excerpt Include |
|---|
| ADD:BagBhsTransportTime |
|---|
| ADD:BagBhsTransportTime |
|---|
| nopanel | true |
|---|
|
|
|
| BagBhsTimeExceededBy | | Excerpt Include |
|---|
| ADD:BagBhsTimeExceededBy |
|---|
| ADD:BagBhsTimeExceededBy |
|---|
| nopanel | true |
|---|
|
|
|
| BagBhsTimeExceededGroup | | Excerpt Include |
|---|
| ADD:BagBhsTimeExceededGroup |
|---|
| ADD:BagBhsTimeExceededGroup |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| BagEventCount | | Excerpt Include |
|---|
| ADD:BagEventCount |
|---|
| ADD:BagEventCount |
|---|
| nopanel | true |
|---|
|
| The next elements indicate how many times something happened. |
| BagInfoMsgCount | | Excerpt Include |
|---|
| ADD:BagInfoMsgCount |
|---|
| ADD:BagInfoMsgCount |
|---|
| nopanel | true |
|---|
|
|
|
| BagToMcsCount | | Excerpt Include |
|---|
| ADD:BagToMcsCount |
|---|
| ADD:BagToMcsCount |
|---|
| nopanel | true |
|---|
|
|
|
| BagBhsBinDeliveryAttempts | | Excerpt Include |
|---|
| ADD:BagBhsBinDeliveryAttempts |
|---|
| ADD:BagBhsBinDeliveryAttempts |
|---|
| nopanel | true |
|---|
|
|
|
|
|
|
|---|
| 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. |
| BagTagPrintedLocation | | Excerpt Include |
|---|
| ADD:BagTagPrintedLocation |
|---|
| ADD:BagTagPrintedLocation |
|---|
| nopanel | true |
|---|
|
|
|
| BFCAT | | Excerpt Include |
|---|
| ADD:BFCAT |
|---|
| ADD:BFCAT |
|---|
| nopanel | true |
|---|
|
|
|
| BagFirstRejectReason | | Excerpt Include |
|---|
| ADD:BagFirstRejectReason |
|---|
| ADD:BagFirstRejectReason |
|---|
| nopanel | true |
|---|
|
|
|
| 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. |
| BagCheckinType | | Excerpt Include |
|---|
| ADD:BagCheckinType |
|---|
| ADD:BagCheckinType |
|---|
| nopanel | true |
|---|
|
| The checkin type that was actually used and corresponds to BACIT. Mapping table from BagEventLocation. |
| BagCheckinLocation | | Excerpt Include |
|---|
| ADD:BagCheckinLocation |
|---|
| ADD:BagCheckinLocation |
|---|
| nopanel | true |
|---|
|
| The checkin location that was actually used and corresponds to BACIT. |
| BABBT | | Excerpt Include |
|---|
| ADD:BABBT |
|---|
| ADD:BABBT |
|---|
| nopanel | true |
|---|
|
|
|
| BTFST | | Excerpt Include |
|---|
| ADD:BTFST |
|---|
| ADD:BTFST |
|---|
| nopanel | true |
|---|
|
|
|
| BTAST | | Excerpt Include |
|---|
| ADD:BTAST |
|---|
| ADD:BTAST |
|---|
| nopanel | true |
|---|
|
|
|
| BTMST | | Excerpt Include |
|---|
| ADD:BTMST |
|---|
| ADD:BTMST |
|---|
| nopanel | true |
|---|
|
|
|
| BTL1T | | Excerpt Include |
|---|
| ADD:BTL1T |
|---|
| ADD:BTL1T |
|---|
| nopanel | true |
|---|
|
|
|
| BTL2T | | Excerpt Include |
|---|
| ADD:BTL2T |
|---|
| ADD:BTL2T |
|---|
| nopanel | true |
|---|
|
|
|
| BTL3T | | Excerpt Include |
|---|
| ADD:BTL3T |
|---|
| ADD:BTL3T |
|---|
| nopanel | true |
|---|
|
|
|
| BTL4T | | Excerpt Include |
|---|
| ADD:BTL4T |
|---|
| ADD:BTL4T |
|---|
| nopanel | true |
|---|
|
|
|
| BTL5T | | Excerpt Include |
|---|
| ADD:BTL5T |
|---|
| ADD:BTL5T |
|---|
| nopanel | true |
|---|
|
|
|
| BFLST | | Excerpt Include |
|---|
| ADD:BFLST |
|---|
| ADD:BFLST |
|---|
| nopanel | true |
|---|
|
|
|
| BFAST | | Excerpt Include |
|---|
| ADD:BFAST |
|---|
| ADD:BFAST |
|---|
| nopanel | true |
|---|
|
|
|
| BFMST | | Excerpt Include |
|---|
| ADD:BFMST |
|---|
| ADD:BFMST |
|---|
| nopanel | true |
|---|
|
|
|
| BFL1T | | Excerpt Include |
|---|
| ADD:BFL1T |
|---|
| ADD:BFL1T |
|---|
| nopanel | true |
|---|
|
|
|
| BFL2T | | Excerpt Include |
|---|
| ADD:BFL2T |
|---|
| ADD:BFL2T |
|---|
| nopanel | true |
|---|
|
|
|
| BFL3T | | Excerpt Include |
|---|
| ADD:BFL3T |
|---|
| ADD:BFL3T |
|---|
| nopanel | true |
|---|
|
|
|
| BFL4T | | Excerpt Include |
|---|
| ADD:BFL4T |
|---|
| ADD:BFL4T |
|---|
| nopanel | true |
|---|
|
|
|
| BFL5T | | Excerpt Include |
|---|
| ADD:BFL5T |
|---|
| ADD:BFL5T |
|---|
| nopanel | true |
|---|
|
|
|
| BTMCT | | Excerpt Include |
|---|
| ADD:BTMCT |
|---|
| ADD:BTMCT |
|---|
| nopanel | true |
|---|
|
|
|
| BFMCT | | Excerpt Include |
|---|
| ADD:BFMCT |
|---|
| ADD:BFMCT |
|---|
| nopanel | true |
|---|
|
|
|
| BTEBT | | Excerpt Include |
|---|
| ADD:BTebt |
|---|
| ADD:BTebt |
|---|
| nopanel | true |
|---|
|
|
|
| BFEBT | | Excerpt Include |
|---|
| ADD:BFEBT |
|---|
| ADD:BFEBT |
|---|
| nopanel | true |
|---|
|
|
|
| BTBBTE | | Excerpt Include |
|---|
| ADD:BTBBTE |
|---|
| ADD:BTBBTE |
|---|
| nopanel | true |
|---|
|
|
|
| BTBBT | | Excerpt Include |
|---|
| ADD:BTBBT |
|---|
| ADD:BTBBT |
|---|
| nopanel | true |
|---|
|
|
|
| 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 |
|---|
|
|
|
| BLOAT | | Excerpt Include |
|---|
| ADD:BLOAT |
|---|
| ADD:BLOAT |
|---|
| nopanel | true |
|---|
|
|
|
| BUNLT | | Excerpt Include |
|---|
| ADD:BUNLT |
|---|
| ADD:BUNLT |
|---|
| nopanel | true |
|---|
|
|
|
| BTOTT | | Excerpt Include |
|---|
| ADD:BTOTT |
|---|
| ADD:BTOTT |
|---|
| nopanel | true |
|---|
|
|
|
| BAOBT | | Excerpt Include |
|---|
| ADD:BAOBT |
|---|
| ADD:BAOBT |
|---|
| nopanel | true |
|---|
|
|
|
| BTPATE | | Excerpt Include |
|---|
| ADD:BTPATE |
|---|
| ADD:BTPATE |
|---|
| nopanel | true |
|---|
|
|
|
| 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 |
|---|
|
|
|
