Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NB! The rows are bag oriented AND airport oriented. Arrival and departure oriented information are relative to the airport one row applies to.

Row elementElement descriptionComments



BagEventAirportIATA

Excerpt Include
ADD:BagEventAirportIATA
ADD:BagEventAirportIATA
nopaneltrue

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
nopaneltrue

NB!!
BagTagNumber

Excerpt Include
ADD:BagTagNumber
ADD:BagTagNumber
nopaneltrue


BagTagLeadingDigit

Excerpt Include
ADD:BagTagLeadingDigit
ADD:BagTagLeadingDigit
nopaneltrue


BagTagIssuerCode

Excerpt Include
ADD:BagTagIssuerCode
ADD:BagTagIssuerCode
nopaneltrue


BagTagIssuerAirlineIATA

Excerpt Include
ADD:BagTagIssuerAirlineIATA
ADD:BagTagIssuerAirlineIATA
nopaneltrue


BagCategory

Excerpt Include
ADD:BagCategory
ADD:BagCategory
nopaneltrue


BagPnrCode

Excerpt Include
ADD:BagPnrCode
ADD:BagPnrCode
nopaneltrue





BagPreviousAirportIATA

Excerpt Include
ADD:BagPreviousAirportIATA
ADD:BagPreviousAirportIATA
nopaneltrue

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
nopaneltrue


BagArrivalOperatingAirlineIATA

Excerpt Include
ADD:BagArrivalOperatingAirlineIATA
ADD:BagArrivalOperatingAirlineIATA
nopaneltrue


SIBT

Excerpt Include
ADD:SIBT
ADD:SIBT
nopaneltrue


AIBT

Excerpt Include
ADD:AIBT
ADD:AIBT
nopaneltrue





BagNextAirportIATA

Excerpt Include
ADD:BagNextAirportIATA
ADD:BagNextAirportIATA
nopaneltrue

Information about the next airport and departing flight are not available for bags with BagCategory = "Final".
BagDepartureFlightId

Excerpt Include
ADD:BagDepartureFlightId
ADD:BagDepartureFlightId
nopaneltrue


BagDepartureOperatingAirlineIATA

Excerpt Include
ADD:BagDepartureOperatingAirlineIATA
ADD:BagDepartureOperatingAirlineIATA
nopaneltrue


SOBT

Excerpt Include
ADD:SOBT
ADD:SOBT
nopaneltrue

The SOBT for the flight the bag should depart on.
AOBT

Excerpt Include
ADD:AOBT
ADD:AOBT
nopaneltrue

The AOBT for the flight the bag should depart on.
BagFinalAirportIATA

Excerpt Include
ADD:BagFinalAirportIATA
ADD:BagFinalAirportIATA
nopaneltrue

NB! Describe mapping from events



BagHandlerCodeArrival

Excerpt Include
ADD:BagHandlerCodeArrival
ADD:BagHandlerCodeArrival
nopaneltrue

NB! What is the source for this

BagHandlerCodeDeparture

Excerpt Include
ADD:BagHandlerCodeDeparture
ADD:BagHandlerCodeDeparture
nopaneltrue





BagTypeIndicator

Excerpt Include
ADD:BagTypeIndicator
ADD:BagTypeIndicator
nopaneltrue

The next elements give information about the type/size/weight/++ of the bag.
BagSizeIndicator

Excerpt Include
ADD:BagSizeIndicator
ADD:BagSizeIndicator
nopaneltrue


BagWeight

Excerpt Include
ADD:BagWeight
ADD:BagWeight
nopaneltrue

BagIsPrio

BagIsPriority

Excerpt Include
ADD:

BagIsPrio

BagIsPriority
ADD:

BagIsPrio

BagIsPriority
nopaneltrue


BagIsCrew

Excerpt Include
ADD:BagIsCrew
ADD:BagIsCrew
nopaneltrue


BagIsRush

Excerpt Include
ADD:BagIsRush
ADD:BagIsRush
nopaneltrue


BagNewTagNumber

Excerpt Include
ADD:BagNewTagNumber
ADD:BagNewTagNumber
nopaneltrue


BagPreviousTagNumber

Excerpt Include
ADD:BagPreviousTagNumber
ADD:BagPreviousTagNumber
nopaneltrue





BagTotalTimeInBhs

Excerpt Include
ADD:BagTotalTimeInBhs
ADD:BagTotalTimeInBhs
nopaneltrue

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
nopaneltrue


BagTotalTimeInMcs

Excerpt Include
ADD:BagTotalTimeInMcs
ADD:BagTotalTimeInMcs
nopaneltrue


BagTotalTimeAtSecScreen

Excerpt Include
ADD:BagTotalTimeAtSecScreen
ADD:BagTotalTimeAtSecScreen
nopaneltrue


BagTimeAtAutSecScreen

Excerpt Include
ADD:BagTimeAtAutSecScreen
ADD:BagTimeAtAutSecScreen
nopaneltrue


BagTimeAtManSecScreen

Excerpt Include
ADD:BagTimeAtManSecScreen
ADD:BagTimeAtManSecScreen
nopaneltrue


BagTotalTimeInEbs

Excerpt Include
ADD:BagTotalTimeInEbs
ADD:BagTotalTimeInEbs
nopaneltrue


BagBhsDeliveryAttemptsTime

Excerpt Include
ADD:BagBhsDeliveryAttemptsTime
ADD:BagBhsDeliveryAttemptsTime
nopaneltrue

NB! Describe how to calculate this.
BagBhsTransportTime

Excerpt Include
ADD:BagBhsTransportTime
ADD:BagBhsTransportTime
nopaneltrue


BagBhsTimeExceededBy

Excerpt Include
ADD:BagBhsTimeExceededBy
ADD:BagBhsTimeExceededBy
nopaneltrue


BagBhsTimeExceededGroup

Excerpt Include
ADD:BagBhsTimeExceededGroup
ADD:BagBhsTimeExceededGroup
nopaneltrue





BagEventCount

Excerpt Include
ADD:BagEventCount
ADD:BagEventCount
nopaneltrue

The next elements indicate how many times something happened.
BagInfoMsgCount

Excerpt Include
ADD:BagInfoMsgCount
ADD:BagInfoMsgCount
nopaneltrue


BagToMcsCount

Excerpt Include
ADD:BagToMcsCount
ADD:BagToMcsCount
nopaneltrue


BagBhsBinDeliveryAttempts

Excerpt Include
ADD:BagBhsBinDeliveryAttempts
ADD:BagBhsBinDeliveryAttempts
nopaneltrue





BTGRT

Excerpt Include
ADD:BTGRT
ADD:BTGRT
nopaneltrue

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
nopaneltrue


BFCAT

Excerpt Include
ADD:BFCAT
ADD:BFCAT
nopaneltrue


BagFirstRejectReason

Excerpt Include
ADD:BagFirstRejectReason
ADD:BagFirstRejectReason
nopaneltrue


BACIT

Excerpt Include
ADD:BACIT
ADD:BACIT
nopaneltrue

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
nopaneltrue

The checkin type that was actually used and corresponds to BACIT.

Mapping table from BagEventLocation.

BagCheckinLocation

Excerpt Include
ADD:BagCheckinLocation
ADD:BagCheckinLocation
nopaneltrue

The checkin location that was actually used and corresponds to BACIT.
BABBT

Excerpt Include
ADD:BABBT
ADD:BABBT
nopaneltrue


BTFST

Excerpt Include
ADD:BTFST
ADD:BTFST
nopaneltrue


BTAST

Excerpt Include
ADD:BTAST
ADD:BTAST
nopaneltrue


BTMST

Excerpt Include
ADD:BTMST
ADD:BTMST
nopaneltrue


BTL1T

Excerpt Include
ADD:BTL1T
ADD:BTL1T
nopaneltrue


BTL2T

Excerpt Include
ADD:BTL2T
ADD:BTL2T
nopaneltrue


BTL3T

Excerpt Include
ADD:BTL3T
ADD:BTL3T
nopaneltrue


BTL4T

Excerpt Include
ADD:BTL4T
ADD:BTL4T
nopaneltrue


BTL5T

Excerpt Include
ADD:BTL5T
ADD:BTL5T
nopaneltrue


BFLST

Excerpt Include
ADD:BFLST
ADD:BFLST
nopaneltrue


BFAST

Excerpt Include
ADD:BFAST
ADD:BFAST
nopaneltrue


BFMST

Excerpt Include
ADD:BFMST
ADD:BFMST
nopaneltrue


BFL1T

Excerpt Include
ADD:BFL1T
ADD:BFL1T
nopaneltrue


BFL2T

Excerpt Include
ADD:BFL2T
ADD:BFL2T
nopaneltrue


BFL3T

Excerpt Include
ADD:BFL3T
ADD:BFL3T
nopaneltrue


BFL4T

Excerpt Include
ADD:BFL4T
ADD:BFL4T
nopaneltrue


BFL5T

Excerpt Include
ADD:BFL5T
ADD:BFL5T
nopaneltrue


BTMCT

Excerpt Include
ADD:BTMCT
ADD:BTMCT
nopaneltrue


BFMCT

Excerpt Include
ADD:BFMCT
ADD:BFMCT
nopaneltrue


BTEBT

Excerpt Include
ADD:BTebt
ADD:BTebt
nopaneltrue


BFEBT

Excerpt Include
ADD:BFEBT
ADD:BFEBT
nopaneltrue

BTBBTE

BEBFT

Excerpt Include
ADD:

BTBBTE

BEBFT
ADD:

BTBBTE

BEBFT
nopaneltrue


BTBBT

Excerpt Include
ADD:BTBBT
ADD:BTBBT
nopaneltrue


BagPlannedBin

Excerpt Include
ADD:BagPlannedBin
ADD:BagPlannedBin
nopaneltrue


BagActualBin

Excerpt Include
ADD:BagActualBin
ADD:BagActualBin
nopaneltrue


BFBBT

Excerpt Include
ADD:BFBBT
ADD:BFBBT
nopaneltrue


BLOAT

Excerpt Include
ADD:BLOAT
ADD:BLOAT
nopaneltrue


BUNLT

Excerpt Include
ADD:BUNLT
ADD:BUNLT
nopaneltrue


BTOTT

Excerpt Include
ADD:BTOTT
ADD:BTOTT
nopaneltrue


BAOBT

Excerpt Include
ADD:BAOBT
ADD:BAOBT
nopaneltrue


BTPATE

Excerpt Include
ADD:BTPATE
ADD:BTPATE
nopaneltrue


BTPAT

Excerpt Include
ADD:BTPAT
ADD:BTPAT
nopaneltrue





BagWasRejected

Excerpt Include
ADD:BagWasRejected
ADD:BagWasRejected
nopaneltrue

The following elements are boolean flags to make selections of interesting rows easier.
BagWasDeliveredToBhsInTime

Excerpt Include
ADD:BagWasDeliveredToBhsInTime
ADD:BagWasDeliveredToBhsInTime
nopaneltrue


BagWasDeliveredToBhsLate

Excerpt Include
ADD:BagWasDeliveredToBhsLate
ADD:BagWasDeliveredToBhsLate
nopaneltrue


BagWasDeliveredToBhsTooLate

Excerpt Include
ADD:BagWasDeliveredToBhsTooLate
ADD:BagWasDeliveredToBhsTooLate
nopaneltrue


BagWasDeliveredFromBhsInTime

Excerpt Include
ADD:BagWasDeliveredFromBhsInTime
ADD:BagWasDeliveredFromBhsInTime
nopaneltrue


BagWasDeliveredFromBhsLate

Excerpt Include
ADD:BagWasDeliveredFromBhsLate
ADD:BagWasDeliveredFromBhsLate
nopaneltrue


BagWasDeliveredFromBhsTooLate

Excerpt Include
ADD:BagWasDeliveredFromBhsTooLate
ADD:BagWasDeliveredFromBhsTooLate
nopaneltrue


BagWasSentToMcs

Excerpt Include
ADD:BagWasSentToMcs
ADD:BagWasSentToMcs
nopaneltrue


BagWasSentToProblemBin

Excerpt Include
ADD:BagWasSentToProblemBin
ADD:BagWasSentToProblemBin
nopaneltrue


BagBsmWasProblem

Excerpt Include
ADD:BagBsmWasProblem
ADD:BagBsmWasProblem
nopaneltrue


BagTagWasNotSeenInBhs

Excerpt Include
ADD:BagTagWasNotSeenInBhs
ADD:BagTagWasNotSeenInBhs
nopaneltrue


BagHasLoadedEvent

Excerpt Include
ADD:BagHasLoadedEvent
ADD:BagHasLoadedEvent
nopaneltrue


BagWasLost

Excerpt Include
ADD:BagWasLost
ADD:BagWasLost
nopaneltrue





BagLostIrregularityCode

Excerpt Include
ADD:BagLostIrregularityCode
ADD:BagLostIrregularityCode
nopaneltrue

The following elements are relevant if the bag is registered as lost.
BagLostAirportIATA

Excerpt Include
ADD:BagLostAirportIATA
ADD:BagLostAirportIATA
nopaneltrue


BagLostDate

Excerpt Include
ADD:BagLostDate
ADD:BagLostDate
nopaneltrue


BagLostFlightId

Excerpt Include
ADD:BagLostFlightId
ADD:BagLostFlightId
nopaneltrue


BagLostAdditionalData

Excerpt Include
ADD:BagLostAdditionalData
ADD:BagLostAdditionalData
nopaneltrue