...
All further discussion here is based on data elements defined by the Airport Data Dictionary, Mapping from IATA data formats are documented here: Mapping of IATA (telex) baggage data formats to ADD
IATA Process step | Event (BagEventCode) | Named timestamp | Named timestamp description / Comment | To: Baggage data analytics row - bag oriented | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | BagTagGenerated | BTGRT |
| Yes | |||||||||||
2 | 1 | BagCheckInAttempt BagChecked | BFCAT |
| ||||||||||||
3 | 1 | BagChecked | BACIT |
| ||||||||||||
4 | 1 | BagRejected |
| |||||||||||||
5 | 1 | BagRejected | BLRET |
| BagRejected
| |||||||||||
56 | 1 | BagAcceptedByBhs | BABBT |
| ||||||||||||
67 | 2 | BagToSecScreen | BTFST |
| ||||||||||||
78 | 2 | BagToSecScreen | BTAST |
| ||||||||||||
89 | 2 | BagToSecScreen | BTMST |
| ||||||||||||
910 | 2 | BagToSecScreen | BTL1T |
| ||||||||||||
1011 | 2 | BagToSecScreen | BTL2T |
| ||||||||||||
1112 | 2 | BagToSecScreen | BTL3T |
| ||||||||||||
1213 | 2 | BagToSecScreen | BTL4T |
| ||||||||||||
1314 | 2 | BagToSecScreen | BTL5T |
| ||||||||||||
1415 | 2 | BagFromSecScreen | BFLST |
| ||||||||||||
1516 | 2 | BagFromSecScreen | BFAST |
| ||||||||||||
1617 | 2 | BagFromSecScreen | BFMST |
| ||||||||||||
1718 | 2 | BagFromSecScreen | BFL1T |
| ||||||||||||
1819 | 2 | BagFromSecScreen | BFL2T |
| ||||||||||||
1920 | 2 | BagFromSecScreen | BFL3T |
| ||||||||||||
2021 | 2 | BagFromSecScreen | BFL4T |
| ||||||||||||
2122 | BagFromSecScreen | BFL5T |
| |||||||||||||
2223 | 2 | BagSecScreenRejected |
| |||||||||||||
2324 | 2/3 | BagToMCS | BTMCT |
| ||||||||||||
2425 | 2/3 | BagFromMCS | BFMCT |
| ||||||||||||
2526 | 4 | BagToEBS | BTEBT |
| ||||||||||||
2627 | 4 | BagFromEBS | BFEBT |
| ||||||||||||
2728 | 5 | BagToBhsBin | BTBBT |
| ||||||||||||
2829 | 5 | BagToBhsBinProblem |
| |||||||||||||
2930 | 5/6 | BagFromBhsBin | BFBBT |
| ||||||||||||
3031 | 7 | BagLoaded | BLOAT |
| ||||||||||||
3132 | 8 | BagUnloaded | BUNLT |
| ||||||||||||
3233 | 10 | BagToTransfer | BTOTT |
| ||||||||||||
3334 | 11 | BagOnBelt | BAOBT |
| ||||||||||||
3435 | 12 | BagToPassenger | BTPAT |
| ||||||||||||
3536 | ||||||||||||||||
3637 | 1-13 | BagInfoReceived |
| |||||||||||||
3738 | 1-13 | BagTagScanned |
| |||||||||||||
3839 | 1-13 | BagBhsEvent |
|
...
Based on the events and timestamps above the following durations have been defined.
Duration | Description | To: Baggage data analytics row - bag oriented | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
| Yes | |||||||||
BagNetTimeInBhs |
| Yes | ||||||||
BagTotalTimeInMcs |
| Yes | ||||||||
BagTotalTimeAtSecScreen |
| Yes | ||||||||
BagTimeAtAutSecScreen |
| Yes | ||||||||
BagTimeAtManSecScreen |
| Yes | ||||||||
BagTotalTimeInEbs |
| Yes | ||||||||
BagBhsDeliveryAttemptsTime |
| Yes | ||||||||
BagBhsTransportTime |
| Yes | ||||||||
BagBhsTimeExceededBy |
| Yes | ||||||||
BagBhsTimeExceededGroup |
| Yes |
Counts
The following baggage related counts have been defined:
Count | Description | To: Baggage data analytics row - bag oriented | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
BagEventCount |
| Yes, per bag per airport | ||||||||
BagInfoMsgCount |
| Yes, per bag per airport | ||||||||
BagTagsGenerated |
| No | ||||||||
BagsCheckedIn |
| No, pr. flight | ||||||||
BagToMcsCount |
| Yes | ||||||||
BagsDeliveredToBhsFlightBin |
| No, pr. |
...
flight | ||||||||||
BagsDeliveredToBhsProblemBin |
| No, pr. flight | ||||||||
BagBhsBinDeliveryAttempts |
| Yes | ||||||||
BaggageCountLoaded |
| No, pr. flight | ||||||||
BaggageCountUnloaded |
| No, pr. flight |
Bag status indicators
The following boolean indicators have been defined:
Indicator | Description | To: Baggage data analytics row - bag oriented | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
BagWasRejected |
| Yes | ||||||||
BagWasDeliveredToBhsInTime |
| Yes | ||||||||
BagWasDeliveredToBhsLate |
| Yes | ||||||||
BagWasDeliveredToBhsTooLate |
| Yes | ||||||||
BagWasDeliveredFromBhsInTime |
| Yes | ||||||||
BagWasDeliveredFromBhsLate |
| Yes | ||||||||
BagWasDeliveredFromBhsTooLate |
| Yes | ||||||||
BagWasSentToMcs |
| Yes | ||||||||
BagWasSentToProblemBin |
| Yes | ||||||||
BagBsmWasProblem |
| Yes | ||||||||
BagTagWasNotSeenInBhs |
| Yes | ||||||||
BagHasLoadedEvent |
| Yes | ||||||||
BagWasLost |
|
|
| Yes |