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 | |
|---|---|---|---|
| 1 | |||
| 1 | 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. | |
| 2 | 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. | ||
| 3 | Departure airport IATA code (see AirportIATA for description of term). | ||
| 4 | ArrivalAirportIATA | Arrival airport IATA code (see AirportIATA for description of term). | |
| 5 | 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. | |
| 6 | SOBT | Scheduled Off-Block Time. The time that an aircraft is scheduled to depart from its parking position. Always UTC time. | |
| 7 | 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. | |
| 8 | SIBT | Scheduled In-Block Time. The time that an aircraft is scheduled to arrive at its first parking position. Always UTC time. | |
| 9 | 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. | |
| 7 | |||
| 10 | |||
| 11 | |||
| 12 | |||
| 10 | |||
| 13 |
· Planlagt antall bags på Fly
o Antall total bags (faktisk sjekket inn på flight men ikke nødvendigvis lastet)
§ Not loaded
§ Not delivered
o Progress of loading
§ Loaded
§ Not loaded
§ Avinor skannet (BHS, BAGS, DT,ABAS) Garantert levert til handler av Avinor…
o Progress of offloading
§ Delivered
§ Not delivered
o Antall faktisk lastet (normalt sum av terminating, transfer, transit og RUSH)
o Terminating bags
o Transfer bags
o Transit bags
o Antall PRIO bagger
o RUSH bags
o Weight of baggage/is weight of all bags