The following table is a possible (database) row to simplify baggage data analytics. Some of the data will directly be from baggage events (ref. Baggage process and data elements - airport perspective), some will be derived from event information and some will be from other systems.
Analytics oriented reports will typically be based on a subset of the elements. Not all elements are relevant for all flights.
Each row can be seen as most of the relevant baggage information for one flight leg.
NB! The rows are flight leg oriented.
| Row element | Element description | Comments |
|---|---|---|
IATA based identifier for this flight, usually issued long before the flight actually takes place. FlightId is normally the concatenation of OperatingAirlineIATA, FlightNumber and OperationalSuffix. FlightId typically identifies a flight to the majority of systems, but it is not unique across time. It's unique only in conjunction with FlightDepartureDate. Exception: Some airlines use their ICAO code (OperatingAirlineICAO) instead of OperatingAirlineIATA. This might be because they aren't an IATA member or because they just prefer the ICAO code. Regardless, this means that it is allowed to use OperatingAirlineICAO as part of FlightId. FlightId is then defined as the concatenation of AirlineIATAorICAO, FlightNumber and OperationalSuffix. | The first set of data identifies the flight leg, and can be used to calculate any delays. | |
The scheduled date (based on UTC) of departure of flight. For flights with multiple legs this is the departure of the first leg. This date must not change once set as it is used to make the FlightIds unique. | ||
Departure airport IATA code (see AirportIATA for description of term). | ||
| ArrivalAirportIATA | Arrival airport IATA code (see AirportIATA for description of term). | |
| AircraftRegistration | An aircraft registration is a unique alphanumeric string that identifies an aircraft. In accordance with the Convention on International Civil Aviation all aircraft must be registered with a national aviation authority and they must carry proof of this registration in the form of a legal document called a Certificate of Registration at all times when in operation. | |
| aircraft type | ||
| SOBT | Scheduled Off-Block Time. The time that an aircraft is scheduled to depart from its parking position. Always UTC time. | |
| AOBT | Actual Off-Block Time. Time the aircraft pushes back / vacates the parking position. (Equivalent to Airline / Handlers ATD – Actual Time of Departure & ACARS=OUT). Always UTC time. | |
| SIBT | Scheduled In-Block Time. The time that an aircraft is scheduled to arrive at its first parking position. Always UTC time. | |
| AIBT | Actual In-Block Time. The time that an aircraft arrives in-blocks. (Equivalent to Airline/Handler ATA –Actual Time of Arrival, ACARS = IN). Always UTC time. | |
- PAX-informasjon?
- Lasting av innsjekket
- actual Antall skrevet BSM info
- actual antall sjekket inn, scanning
- actual antall lastet scanning
- actual antall PRIO (av de vanlige) BSM info
- avlede antall som mangler
- avlede ubrukte, skrevet -sjekket inn
- actual RUSH (hverken sjekket inn etter transfer) BSM info
- Antall faktisk lastet (sum av normal + rush + transfer)
- Lasting av Transfer
- totalt antall tansfer fra andre flighter BSM info
- antall PRIO (av de vanlige) BSM info
- transfer via BHS scanning
- transfer tail to tail scanning
- Progress of offloading
- totalt antall som skal lastes av
- totalt final
- total transfer
- totalt PRIO av de som skal lastes av
- totalt antall RUSH av de som skal lastes av
- actual delivered to final
- actual delivered to BHS transfer
- actual delivered to tail to tail