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 |
---|
|
| NB!! | 3 |
BagTagNumber | Excerpt Include |
---|
| ADD:BagTagNumber |
---|
| ADD:BagTagNumber |
---|
nopanel | true |
---|
|
| 4 |
|
BagTagLeadingDigit | Excerpt Include |
---|
| ADD:BagTagLeadingDigit |
---|
| ADD:BagTagLeadingDigit |
---|
nopanel | true |
---|
|
|
|
5 | BagTagIssuerCode | Excerpt Include |
---|
| ADD:BagTagIssuerCode |
---|
| ADD:BagTagIssuerCode |
---|
nopanel | true |
---|
|
| 6 |
|
BagTagIssuerAirlineIATA | Excerpt Include |
---|
| ADD:BagTagIssuerAirlineIATA |
---|
| ADD:BagTagIssuerAirlineIATA |
---|
nopanel | true |
---|
|
| 7 |
|
BagCategory | Excerpt Include |
---|
| ADD:BagCategory |
---|
| ADD:BagCategory |
---|
nopanel | true |
---|
|
| 7 |
|
|
|
|
---|
8 | 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! | 9 |
BagArrivalFlightId | Excerpt Include |
---|
| ADD:BagArrivalFlightId |
---|
| ADD:BagArrivalFlightId |
---|
nopanel | true |
---|
|
| 10 |
|
BagArrivalOperatingAirlineIATA | Excerpt Include |
---|
| ADD:BagArrivalOperatingAirlineIATA |
---|
| ADD:BagArrivalOperatingAirlineIATA |
---|
nopanel | true |
---|
|
|
|
11 | SIBT | Excerpt Include |
---|
| ADD:SIBT |
---|
| ADD:SIBT |
---|
nopanel | true |
---|
|
|
|
12 | AIBT | Excerpt Include |
---|
| ADD:AIBT |
---|
| ADD:AIBT |
---|
nopanel | true |
---|
|
| 10 |
|
---|
|
|
|
---|
13 | 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". |
14 | BagDepartureFlightId | Excerpt Include |
---|
| ADD:BagDepartureFlightId |
---|
| ADD:BagDepartureFlightId |
---|
nopanel | true |
---|
|
| 15 |
|
BagDepartureOperatingAirlineIATA | Excerpt Include |
---|
| ADD:BagDepartureOperatingAirlineIATA |
---|
| ADD:BagDepartureOperatingAirlineIATA |
---|
nopanel | true |
---|
|
| 16 |
|
SOBT | Excerpt Include |
---|
| ADD:SOBT |
---|
| ADD:SOBT |
---|
nopanel | true |
---|
|
| The SOBT for the flight the bag should depart on. |
17 | AOBT | Excerpt Include |
---|
| ADD:AOBT |
---|
| ADD:AOBT |
---|
nopanel | true |
---|
|
| The AOBT for the flight the bag should depart on.
|
18 | BagFinalAirportIATA | Excerpt Include |
---|
| ADD:BagFinalAirportIATA |
---|
| ADD:BagFinalAirportIATA |
---|
nopanel | true |
---|
|
| NB! Describe mapping from events | 17 |
---|
|
|
|
---|
19 | BagHandlerCodeArrival | Excerpt Include |
---|
| ADD:BagHandlerCodeArrival |
---|
| ADD:BagHandlerCodeArrival |
---|
nopanel | true |
---|
|
| NB! What is the source for this
|
20 | BagHandlerCodeDeparture | Excerpt Include |
---|
| ADD:BagHandlerCodeDeparture |
---|
| ADD:BagHandlerCodeDeparture |
---|
nopanel | true |
---|
|
| 18 |
|
---|
|
|
|
---|
21 | BagTypeIndicator | Excerpt Include |
---|
| ADD:BagTypeIndicator |
---|
| ADD:BagTypeIndicator |
---|
nopanel | true |
---|
|
| The next elements give information about the type/size/weight/++ of the bag. | 22 |
BagSizeIndicator | Excerpt Include |
---|
| ADD:BagSizeIndicator |
---|
| ADD:BagSizeIndicator |
---|
nopanel | true |
---|
|
| 23 |
|
BagWeight | Excerpt Include |
---|
| ADD:BagWeight |
---|
| ADD:BagWeight |
---|
nopanel | true |
---|
|
| 24 |
|
BagIsPrio | Excerpt Include |
---|
| ADD:BagIsPrio |
---|
| ADD:BagIsPrio |
---|
nopanel | true |
---|
|
|
|
25 | BagIsCrew | Excerpt Include |
---|
| ADD:BagIsCrew |
---|
| ADD:BagIsCrew |
---|
nopanel | true |
---|
|
| 26 |
|
BagIsRush | Excerpt Include |
---|
| ADD:BagIsRush |
---|
| ADD:BagIsRush |
---|
nopanel | true |
---|
|
| 27 |
|
BagNewTagNumber | Excerpt Include |
---|
| ADD:BagNewTagNumber |
---|
| ADD:BagNewTagNumber |
---|
nopanel | true |
---|
|
| 28 |
|
BagPreviousTagNumber | Excerpt Include |
---|
| ADD:BagPreviousTagNumber |
---|
| ADD:BagPreviousTagNumber |
---|
nopanel | true |
---|
|
| 21 | 29 |
|
---|
|
|
|
---|
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). | 30 |
BagNetTimeInBhs | Excerpt Include |
---|
| ADD:BagNetTimeInBhs |
---|
| ADD:BagNetTimeInBhs |
---|
nopanel | true |
---|
|
|
|
31 | BagTotalTimeInMcs | Excerpt Include |
---|
| ADD:BagTotalTimeInMcs |
---|
| ADD:BagTotalTimeInMcs |
---|
nopanel | true |
---|
|
| 32 |
|
BagTotalTimeAtSecScreen | Excerpt Include |
---|
| ADD:BagTotalTimeAtSecScreen |
---|
| ADD:BagTotalTimeAtSecScreen |
---|
nopanel | true |
---|
|
| 33 |
|
BagTimeAtAutSecScreen | Excerpt Include |
---|
| ADD:BagTimeAtAutSecScreen |
---|
| ADD:BagTimeAtAutSecScreen |
---|
nopanel | true |
---|
|
| 34 |
|
BagTimeAtManSecScreen | Excerpt Include |
---|
| ADD:BagTimeAtManSecScreen |
---|
| ADD:BagTimeAtManSecScreen |
---|
nopanel | true |
---|
|
|
|
35 | BagTotalTimeInEbs | Excerpt Include |
---|
| ADD:BagTotalTimeInEbs |
---|
| ADD:BagTotalTimeInEbs |
---|
nopanel | true |
---|
|
|
|
36 | BagBhsDeliveryAttemptsTime | Excerpt Include |
---|
| ADD:BagBhsDeliveryAttemptsTime |
---|
| ADD:BagBhsDeliveryAttemptsTime |
---|
nopanel | true |
---|
|
| NB! Describe how to calculate this. | 37 |
BagBhsTransportTime | Excerpt Include |
---|
| ADD:BagBhsTransportTime |
---|
| ADD:BagBhsTransportTime |
---|
nopanel | true |
---|
|
|
|
38 | BagBhsTimeExceededBy | Excerpt Include |
---|
| ADD:BagBhsTimeExceededBy |
---|
| ADD:BagBhsTimeExceededBy |
---|
nopanel | true |
---|
|
| 39 |
|
BagBhsTimeExceededGroup | Excerpt Include |
---|
| ADD:BagBhsTimeExceededGroup |
---|
| ADD:BagBhsTimeExceededGroup |
---|
nopanel | true |
---|
|
| 32 | 40 |
|
---|
|
|
|
---|
BagEventCount | Excerpt Include |
---|
| ADD:BagEventCount |
---|
| ADD:BagEventCount |
---|
nopanel | true |
---|
|
| The next elements indicate how many times something happened. |
41 | BagInfoMsgCount | Excerpt Include |
---|
| ADD:BagInfoMsgCount |
---|
| ADD:BagInfoMsgCount |
---|
nopanel | true |
---|
|
|
|
42 | BagToMcsCount | Excerpt Include |
---|
| ADD:BagToMcsCount |
---|
| ADD:BagToMcsCount |
---|
nopanel | true |
---|
|
| 43 |
|
BagBhsBinDeliveryAttempts | Excerpt Include |
---|
| ADD:BagBhsBinDeliveryAttempts |
---|
| ADD:BagBhsBinDeliveryAttempts |
---|
nopanel | true |
---|
|
| 36 |
|
---|
|
|
|
---|
44 | 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. |
45 | BagTagPrintedLocation | Excerpt Include |
---|
| ADD:BagTagPrintedLocation |
---|
| ADD:BagTagPrintedLocation |
---|
nopanel | true |
---|
|
| 46 |
|
BFCAT | Excerpt Include |
---|
| ADD:BFCAT |
---|
| ADD:BFCAT |
---|
nopanel | true |
---|
|
| 47 |
|
BagFirstRejectReason | Excerpt Include |
---|
| ADD:BagFirstRejectReason |
---|
| ADD:BagFirstRejectReason |
---|
nopanel | true |
---|
|
| 48 |
|
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. | 49 |
BagCheckinType | Excerpt Include |
---|
| ADD:BagCheckinType |
---|
| ADD:BagCheckinType |
---|
nopanel | true |
---|
|
| The checkin type that was actually used and corresponds to BACIT. Mapping table from BagEventLocation. |
50 | BagCheckinLocation | Excerpt Include |
---|
| ADD:BagCheckinLocation |
---|
| ADD:BagCheckinLocation |
---|
nopanel | true |
---|
|
| The checkin location that was actually used and corresponds to BACIT. | 51 |
BABBT | Excerpt Include |
---|
| ADD:BABBT |
---|
| ADD:BABBT |
---|
nopanel | true |
---|
|
| 52 |
|
BTFST | Excerpt Include |
---|
| ADD:BTFST |
---|
| ADD:BTFST |
---|
nopanel | true |
---|
|
|
|
53 | BTAST | Excerpt Include |
---|
| ADD:BTAST |
---|
| ADD:BTAST |
---|
nopanel | true |
---|
|
| 54 |
|
BTMST | Excerpt Include |
---|
| ADD:BTMST |
---|
| ADD:BTMST |
---|
nopanel | true |
---|
|
| 55 |
|
BTL1T | Excerpt Include |
---|
| ADD:BTL1T |
---|
| ADD:BTL1T |
---|
nopanel | true |
---|
|
| 56 |
|
BTL2T | Excerpt Include |
---|
| ADD:BTL2T |
---|
| ADD:BTL2T |
---|
nopanel | true |
---|
|
|
|
57 | BTL3T | Excerpt Include |
---|
| ADD:BTL3T |
---|
| ADD:BTL3T |
---|
nopanel | true |
---|
|
| 58 |
|
BTL4T | Excerpt Include |
---|
| ADD:BTL4T |
---|
| ADD:BTL4T |
---|
nopanel | true |
---|
|
| 59 |
|
BTL5T | Excerpt Include |
---|
| ADD:BTL5T |
---|
| ADD:BTL5T |
---|
nopanel | true |
---|
|
|
|
60 | BFLST | Excerpt Include |
---|
| ADD:BFLST |
---|
| ADD:BFLST |
---|
nopanel | true |
---|
|
|
|
61 | BFAST | Excerpt Include |
---|
| ADD:BFAST |
---|
| ADD:BFAST |
---|
nopanel | true |
---|
|
|
|
62 | BFMST | Excerpt Include |
---|
| ADD:BFMST |
---|
| ADD:BFMST |
---|
nopanel | true |
---|
|
| 63 |
|
BFL1T | Excerpt Include |
---|
| ADD:BFL1T |
---|
| ADD:BFL1T |
---|
nopanel | true |
---|
|
|
|
64 | BFL2T | Excerpt Include |
---|
| ADD:BFL2T |
---|
| ADD:BFL2T |
---|
nopanel | true |
---|
|
| 65 |
|
BFL3T | Excerpt Include |
---|
| ADD:BFL3T |
---|
| ADD:BFL3T |
---|
nopanel | true |
---|
|
| 66 |
|
BFL4T | Excerpt Include |
---|
| ADD:BFL4T |
---|
| ADD:BFL4T |
---|
nopanel | true |
---|
|
|
|
67 | BFL5T | Excerpt Include |
---|
| ADD:BFL5T |
---|
| ADD:BFL5T |
---|
nopanel | true |
---|
|
|
|
68 | BTMCT | Excerpt Include |
---|
| ADD:BTMCT |
---|
| ADD:BTMCT |
---|
nopanel | true |
---|
|
|
|
69 | BFMCT | Excerpt Include |
---|
| ADD:BFMCT |
---|
| ADD:BFMCT |
---|
nopanel | true |
---|
|
| 70 |
|
BTEBT | Excerpt Include |
---|
| ADD:BTebt |
---|
| ADD:BTebt |
---|
nopanel | true |
---|
|
|
|
71 | BFEBT | Excerpt Include |
---|
| ADD:BFEBT |
---|
| ADD:BFEBT |
---|
nopanel | true |
---|
|
|
|
72 | BTBBTE | Excerpt Include |
---|
| ADD:BTBBTE |
---|
| ADD:BTBBTE |
---|
nopanel | true |
---|
|
| 73 |
|
BTBBT | Excerpt Include |
---|
| ADD:BTBBT |
---|
| ADD:BTBBT |
---|
nopanel | true |
---|
|
| 74 |
|
BagPlannedBin | Excerpt Include |
---|
| ADD:BagPlannedBin |
---|
| ADD:BagPlannedBin |
---|
nopanel | true |
---|
|
| 75 |
|
BagActualBin | Excerpt Include |
---|
| ADD:BagActualBin |
---|
| ADD:BagActualBin |
---|
nopanel | true |
---|
|
| 76 |
|
BFBBT | Excerpt Include |
---|
| ADD:BFBBT |
---|
| ADD:BFBBT |
---|
nopanel | true |
---|
|
|
|
77 | BLOAT | Excerpt Include |
---|
| ADD:BLOAT |
---|
| ADD:BLOAT |
---|
nopanel | true |
---|
|
| 78 |
|
BUNLT | Excerpt Include |
---|
| ADD:BUNLT |
---|
| ADD:BUNLT |
---|
nopanel | true |
---|
|
| 79 |
|
BTOTT | Excerpt Include |
---|
| ADD:BTOTT |
---|
| ADD:BTOTT |
---|
nopanel | true |
---|
|
| 80 |
|
BAOBT | Excerpt Include |
---|
| ADD:BAOBT |
---|
| ADD:BAOBT |
---|
nopanel | true |
---|
|
|
|
81 | BTPATE | Excerpt Include |
---|
| ADD:BTPATE |
---|
| ADD:BTPATE |
---|
nopanel | true |
---|
|
| 82 |
|
BTPAT | Excerpt Include |
---|
| ADD:BTPAT |
---|
| ADD:BTPAT |
---|
nopanel | true |
---|
|
| 75 |
|
|
|
|
---|
83 | BagWasRejected | Excerpt Include |
---|
| ADD:BagWasRejected |
---|
| ADD:BagWasRejected |
---|
nopanel | true |
---|
|
| The following elements are boolean flags to make selections of interesting rows easier. | 84 |
BagWasDeliveredToBhsInTime | Excerpt Include |
---|
| ADD:BagWasDeliveredToBhsInTime |
---|
| ADD:BagWasDeliveredToBhsInTime |
---|
nopanel | true |
---|
|
| 85 |
|
BagWasDeliveredToBhsLate | Excerpt Include |
---|
| ADD:BagWasDeliveredToBhsLate |
---|
| ADD:BagWasDeliveredToBhsLate |
---|
nopanel | true |
---|
|
| 86 |
|
BagWasDeliveredToBhsTooLate | Excerpt Include |
---|
| ADD:BagWasDeliveredToBhsTooLate |
---|
| ADD:BagWasDeliveredToBhsTooLate |
---|
nopanel | true |
---|
|
|
|
87 | BagWasDeliveredFromBhsInTime | Excerpt Include |
---|
| ADD:BagWasDeliveredFromBhsInTime |
---|
| ADD:BagWasDeliveredFromBhsInTime |
---|
nopanel | true |
---|
|
|
|
88 | BagWasDeliveredFromBhsLate | Excerpt Include |
---|
| ADD:BagWasDeliveredFromBhsLate |
---|
| ADD:BagWasDeliveredFromBhsLate |
---|
nopanel | true |
---|
|
| 89 |
|
BagWasDeliveredFromBhsTooLate | Excerpt Include |
---|
| ADD:BagWasDeliveredFromBhsTooLate |
---|
| ADD:BagWasDeliveredFromBhsTooLate |
---|
nopanel | true |
---|
|
|
|
90 | BagWasSentToMcs | Excerpt Include |
---|
| ADD:BagWasSentToMcs |
---|
| ADD:BagWasSentToMcs |
---|
nopanel | true |
---|
|
| 91 |
|
BagWasSentToProblemBin | Excerpt Include |
---|
| ADD:BagWasSentToProblemBin |
---|
| ADD:BagWasSentToProblemBin |
---|
nopanel | true |
---|
|
| 92 |
|
BagBsmWasProblem | Excerpt Include |
---|
| ADD:BagBsmWasProblem |
---|
| ADD:BagBsmWasProblem |
---|
nopanel | true |
---|
|
| 93 |
|
BagTagWasNotSeenInBhs | Excerpt Include |
---|
| ADD:BagTagWasNotSeenInBhs |
---|
| ADD:BagTagWasNotSeenInBhs |
---|
nopanel | true |
---|
|
|
|
94 | BagHasLoadedEvent | Excerpt Include |
---|
| ADD:BagHasLoadedEvent |
---|
| ADD:BagHasLoadedEvent |
---|
nopanel | true |
---|
|
|
|
95 | BagWasLost | Excerpt Include |
---|
| ADD:BagWasLost |
---|
| ADD:BagWasLost |
---|
nopanel | true |
---|
|
| 88 |
|
|
|
|
---|
96 | BagLostIrregularityCode | Excerpt Include |
---|
| ADD:BagLostIrregularityCode |
---|
| ADD:BagLostIrregularityCode |
---|
nopanel | true |
---|
|
| The following elements are relevant if the bag is registered as lost. |
97 | BagLostAirportIATA | Excerpt Include |
---|
| ADD:BagLostAirportIATA |
---|
| ADD:BagLostAirportIATA |
---|
nopanel | true |
---|
|
|
|
98 | BagLostDate | Excerpt Include |
---|
| ADD:BagLostDate |
---|
| ADD:BagLostDate |
---|
nopanel | true |
---|
|
| 99 |
|
BagLostFlightId | Excerpt Include |
---|
| ADD:BagLostFlightId |
---|
| ADD:BagLostFlightId |
---|
nopanel | true |
---|
|
| 100 |
|
BagLostAdditionalData | Excerpt Include |
---|
| ADD:BagLostAdditionalData |
---|
| ADD:BagLostAdditionalData |
---|
nopanel | true |
---|
|
|
|