Change history

Date	Author	Description
2023-02-9	Reto Häberli	Refactored tables and consolidated mostly redundant arrival/departure information. Arrival/Departure columns indicate now where a data element is relevant. This should help to keep it manageable while the content grows.
2023-02-07	Reto Häberli	Mapping to Heathrow AODB values concluded with Mick Auger

Open Actions

Mapping to ACRIS values / LHR integration model
Merging of inputs from Workpackages D*
--> Core Concepts need to be defined.

OPS Data

Origin: ZRH Business Continuity Exercise - mapped to Avinor data dictionary and Heathrow AODB / Semantic Model (Airport Message Model), extended during workshops.

Basic Flight data

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Heathrow (Semantic Model)	Source
	Airport Universally Unique Flight Identifier	x	x		AODBUniqueID
FLT	FlightId	x	x	OP_CODE (IATA or ICAO airline code) Leading 0's Flight number Suffix (Optional)	ASM AM: Flight identifier consisting of carrier, flight number and optional suffix. These components are typically concatenated into a single string when presented for display CarrierCode FlightNumber FlightSuffix	Airline Schedule, Defined for IATA FLTs Concatenation of: OperatingAirlineIATA FlightNumber OperationalSuffix constructed FlightId used for operational communication → Common algorithm possible?
	Flight Reference	x	x		FlightReference, concatenation of: FlightId and ArrivalOrDeparture ScheduledDate	Airline Schedule
ORG / DES / VI1	FlightRouteIATA FlightIsMultiLeg Flight Departure Airport DepartureAirportIATA DepartureAirportICAO Flight Leg Departure Airport	x	x	Up to 6 airport codes, although normally max of 2 are populated	PortsOfCall IATACountryCode IATALocationCode ICAOLocationCode PublicLocationName ShowToPublic List of stops on the flight itinerary presented in 'flying' order i.e. sequence in which aircraft visits them.	Airline Schedule, ATC, Slot coordination, others
NA	FlightServiceTypeIATA	x	x	FLYT_TYPE	IATAServiceType
STA	SIBT (scheduled in block time)	x		STO (same as SIBT)	ScheduledDateTime	Airline Schedule (Not ACDM exclusive)
STD	SOBT (scheduled off block time)		x	STO (same as SOBT)	ScheduledDateTime	Airline (IATA Type B), ATC (Not ACDM exclusive)
SCH	FlightDIIndicator DICE - Domestic, International indicator, International Domestic Flag, Schengen / Non-Schengen	x	x	DICE	InternationalOrDomestic	Derived by AODB from reference data
LKF	LinkedDepartureFlightId	x		See FlightId above	See FlightReference (technically solved with correct uuids, outside AODB Flight Reference is used)	Airline Schedule/Slot (IATA Type B), dervied from Reg.
LKF	LinkedArrivalFlightId		x	See FlightId above	See FlightReference (technically solved with correct uuids, outside AODB Flight Reference is used)	Airline Schedule/Slot (IATA Type B), dervied from Reg. Clarify if typically from schedule? Can sometimes be taken from schedule, but derived reg would override it
FCC	Flight change code (see subpage for discussion)	x	x			Invent or re-use ACRIS standard? ATC or IATA cancel/delete?
CAN	FlightLegStatus	x	x		FlightStatus DivertStatus (extra info on divert)	ATC, Airline (IATA Type B), derived from data (workaround)
RCG	RemarkData (Timestamp, Type, Text)	x	x	We have separate remarks for handler, cargo, free format, airport, apron		Airline Clarify and clean up
		x		ORIGIN_STO - Origin (airport) schedule date/time or operation, used to match IATA type B messages (MVT, LDM etc.)		Calculated from AODB reference data using typical flying times

ATC Flightplan

ZRH ref

Data element name

Arrival

Departure

Heathrow (AODB)

Heathrow (Semantic Model)

Source

CSG

Callsign

x

Callsign

Not associated with the aircraft should be in flight list

Airline seasonal schedule, Eurocontrol/ATC Flightplan

Becomes important when 1st ATC messages are received for matching.

What is the process behind callsign creation/association? Transponder Movement?

NA

CTOT

ATC Slot Required for flights crossing a regulated ATC zone. Calculated based on information from Eurocontrol.

x

CTOT indicates flight is regulated, received from Eurocontrol via SAM,SRM messages

Eurocontrol NMOC

(Not ACDM exclusive)

ACDM

→ Source from Eurocontrol.

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Source
EA1	EIBT	x		EIBT is the ACDM time from the flight plan, different from ELDT (ETO Estimated Landing Date Time)	Airline (IATA Type B), ATC
ETD	EOBT		x	EOBT is the ACDM time from the flight plan, different from TOBT (ETO) (Target Offblock time )	Airline (IATA Type B), ATC (D-MAN) EOBT is in the Flight Plan received from the local ATC Mick Auger Airport calculated, AOP? Reto Häberli
ATA	AIBT	x		ATO	Airline (IATA Type B), ATC
	ELDT	x		ETO (ELDT Estimated Landing Date Time)	Airlines, IATA MVT, or other airline interfaces
	TOBT		x	ETO (TOBT Target Off block time )	Airlines, IATA MVT, or other airline interfaces
ATD	AOBT		x	ATO	Docking System, Airline, ATC

Aircraft (ACFT) instance and type data

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Source
REG	AircraftRegistration	x	x	Similar	ATC Flightplan, Airline (IATA Type B)
IATA_TYP	AircraftIATAType	x	x	Similar	ATC Flightplan, Airline (IATA Type B)
	AircraftICAOType	x	x	Similar	ATC Flightplan
	Max PAX per ACFT
	...
	Noise Class

	...

Passenger Data (PAX)

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Source
PAX	PaxDisembarking	x			Airline (IATA Type B) (numbers)
PXE	PaxEstimateBoarding (Total Pax estimate)	x	x	PAX_TOTAL (estimate)	Airline booking data / Type B Messages
	PaxAdultOnBoard PaxChildOnBoard ... Actual Pax on board	x	x	PAX_MALE PAX_FEMALE PAX_CHILDREN PAX_INFANTS
	Pax per route?
	PaxClass1OnBoard PaxClass2OnBoard PaxClass3OnBoard	x	x	SEAT_CLASS1 - First (on board) SEAT_CLASS2 - Business SEAT_CLASS3 - Economy SEAT_CLASS4 - Non ReveIATA Type B LDM, SLSnue	IATA Type B LDM, SLS
	PaxTransfer Adult, Child, etc.	x	x	PAX_TRANSFER TRANSFER_BAGS TRANSFER_BAGWGHT	Airline (IATA Type B: LDM, SLS, PTM)
	PaxTransit (Arrival / Departure) PaxTransitAdult PaxTransitChild PaxTransitInfant
	SpecialServiceRequestCode PAX w/ reduced mobility PAX w/ special needs				Airline (PRM Messages, PSM Messages)

Bag

ZRH ref

Data element name

Arrival

Departure

Heathrow (AODB)

Heathrow (Semantic Model)

Source

x

BAG_WGHT

BAGS_NUMBER

DEAD_LOAD

IATA Type B LDM, SLS

Freight data (cargo)

ZRH ref

Data element name

Arrival

Departure

Heathrow (AODB)

Heathrow (Semantic Model)

Source

x

FRT_WGHT

MAIL_WGHT

IATA Type B LDM, SLS

Ground Movements

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Heathrow (Semantic Model)	Source
	Tows, etc.

Fixed Resources (D6 - Fixed Resource Management (Core))

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Source
TAR	AircraftParkingPositionArrival AircraftParkingPositionDeparture	x	x	STND - current stand ARR_STND - STND when flight landed	RMS
TEF	arrivalTerminal Terminal (Passenger Terminal)	x		TERM	ACL flight schedule
NA	departureTerminal Terminal (Passenger Terminal)		x	TERM	ACL flight schedule
	arrivalGate Gate				Not relevant for LHR,ZRH, Avinor Maybe for connecting PAX info?
GAT	departureGate Gate departurePublicBoardingGate (better naming?)		x	GATE	RMS lookup for fixed gate/stand remote gate from RMS
CIR	CheckInZone CheckInDeskCode Main Check-in area + row CheckInDisplayText (currently used by Avinor)		x		Almost never flight related. Used for FIDS.
CW2	CheckInZone 2 2nd Check-in area + row (Check-in row must not necessarily be flight specific)		x		Almost never flight related. Used for FIDS.
CAR	BaggageClaimUnit	x	(x) If a dep flight has an issue sometimes pax and bags have to be offloaded and collected from bag reclaims	CAROUSEL - from baggage system	RMS, Bag Sorting System
	BaggageClaimUnit 2	x	(x)	CAROUSEL2 - from baggage system
	BaggageBin(s)		x
RWY	RunwayArrival	x		RUNWAY - NATS Event messages
RWY	RunwayDeparture		x	RUNWAY - NATS Event messages
GTX	Gate extra information (see page for discussion)	x		Not relevant (or not in scope) for arrivals	ZRH: Bus Stop Information (calculated based on AODB look up table) Some Gates defined as coaching gates, can be allocated via RMS

De-icing resources (D8 - De-Icing)

ZRH ref	Data element name	Departure	Heathrow (AODB)
DRM	DeIce On-Stand / Remote	x	DEICE_REMOTE_PAD
RDL	DeIcePlatform / DeIce Pad / Lane? DeIceParkingPosition (Not Stand in Avinor)	x
	Trucks

See ACDM section for timestamps.

Mobile Resources

Relevant in the flight context for turnaround or arrival and departure.

Not Mobile resources managed by ground handlers autonomously (Tow, fuel, baggage loading, food, etc.).

ZRH ref

Data element name

Arrival

Departure

Heathrow (AODB)

Heathrow (Semantic Model)

Source

Passenger Bus

Tow truck

Mobile RMS

(Ground Movements)

Marshaller vehicle?

Processor data

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Source
SCC	One Stop Security Code (y/n) EU-Secure vs ICAO-Secure. https://blog.aci.aero/one-stop-security-for-airports/	x		Not used at Heathrow	Not used at Gatwick or Heathrow Avinor has comparable situation
HDL	HandlerCode HandlerServiceType → Main Handler and Sub-handler per processes. Handing Agent Code	x	x	Up to 5 ramp, baggage, check-in etc.	Airline, Seasonal Flight Plan (representing the handling agent providing the service at the airport, Heathrow has up to 5, ramp, baggage, check-in etc.) ZRH: various fields for different aspects (de-icing, pax, bag, etc.)

Non-ACDM timemstamps and KPIs

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)
NA	BeltFirstBag First and last bag delivery times (key performance indicators for many airports) ZRH: Not in critical attributes list but important	x	As above	FIRST_BAG - Baggage handling system
NA	BeltLastBag	x	As above	LAST_BAG - Baggage handling system

Commercial and marketing data

ZRH ref

Data element name

Arrival

Departure

Heathrow (AODB)

Heathrow (Semantic Model)

Source

NA

CodeshareFlightId

x

1 or more Codeshare list

(separate table)

Airline SSIM

populated via lookup table

NA

CodeshareAirlineIATA

x

Airline SSIM

... Object / Topic

ZRH ref	Data element name	Arrival	Departure	Heathrow (AODB)	Heathrow (Semantic Model)	Source

References / Inputs

Avinor references used:

IATA glossary provided by Eden:

Questions / Remarks

Flights may use different baggage halls and have different passport control arrangements - might be UK specific?

Mick Auger could you please add required data elements for this on the table above?

Note on Codeshares, these are not provided by Airport Co-ordination as part of the schedule but added when the flights are generated via look up tables
Mick Auger I'm personally not familiar with how this works at ZRH at this time. Where do Airports get code share flight information if not from the airlines?

The code share info does come from airlines but not via Airport Co-ordination, at Heathrow and Gatwick they come in via unstructured emails (like callsigns) rather than a standard data feed of some sort.

Removed

ZRH ref

Arrival

Source

ZRH ref

Departure

Source

DOR

arrivalGate Gate

ZRH specific PAX process door control for mixed Schengen / Non-Schengen Dock. Related to gate resources not gate itself.

RMS Mick Auger how do we do this

Do you mean gate or stand?

For arrivals gate is not really relevant as passengers disembark

and use fixed signage to find passport control and baggage reclaims

If we mean stand then typically an RMS would update the arrival stand in the AODB