Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Link for internal consumers in production:
https://services.avinor.no/XmlFeedOperativeWithPax/v1.0?airport=BGO&TimeFrom=1&TimeTo=4&direction=A&cdm=Y&additional=Y&lastUpdate=2023-01-20T13:02:37.340Z&handlingdata=Y&gateClosedTime=Y&codeshare=Y&arrivalGate=Y

...

Service field mapping

Service term

ADD term

Comment


flight_idFlightId

date_of_operationFlightDepartureDate

dom_intFlightDIIndicator

schedule_timeSIBT for arrivals, SOBT for departures

arr_depN/A"A" - Arrival, "D" - Departure
airportArrivalAirportIATA or DepartureAirportIATA

via_airportFlightRouteIATADerives from flightId, multi flight, +++
check_inCheckInDisplayText

gateGate

gate_statusGateStatus

beltBaggageClaimUnit

belt_statusBeltLastBag or BeltFirstBagIf BeltLastBag is set, belt_status = C, else if BeltFirstBag is set, belt_status = O
belt_startBeltFirstBag

belt_stopBeltLastBag

standAircraftParkingPositionArrival, AircraftParkingPositionDepartureField type depends on flight direction
est_timeELDT or ETOT or EOBT

Arrival: ELDT. Departure: EOBT if set, else ETOT


act_timeALDT or ATOTArrival: ALDT. Departure: ATOT
onb_ofb_timeAIBT or AOBTArrival: AIBT. Departure: AOBT
next_infoNextInformationTimeThe dateTime of next information
linked_flightLinkedArrival.FlightId or LinkedDeparture.FlightIdif arrival LinkedDeparture.FlightId, else departure LinkedArrival.FlightId
last_delay_codeArrivalDelay or DepartureDelay

last_delay_code2ArrivalDelay or DepartureDelay

cancelled_flagFlightLegStatusChecks if flight status is "CANCELED" returns true/false
codeshare_indN/AThe AltiFlightLegQuery returns data for physical flights, possibly with information about code shares. In any case the FlightLeg is never a code share, value is always set to "N"
service_typeFlightServiceTypeIATAOne letter IATA service type code e.g. ‘J’ (Schedule passenger) and ‘C’ (Charter passenger). No restrictions on service type.
aircraft_regAircraftData.AircraftRegistrationRegistration number of the aircraft
ramp_fuelDepartureData.FuelRampRequestedField ramp fuel (IR1 message), must convert from _Kilo to fuelType.
remark_1RemarkData.RemarkTextIf arrival will display public, if departure will not filter by typePublic remark, shown on Public Surfaces, such as FIDS screens and web pages.
remark_2RemarkData.RemarkTextWill only show staff departure no matter directionStaff remark, only shown to handlers, airline and airport employees. Visible in mAOS and flightviewer.
cdm_tobtTOBT

cdm_tsatTSAT

cdm_eibtEIBT

airlineOperatingAirlineIATA

flight_numberFlightNumber (part of FlightId)Is derived from FlightId
statusNextInformationTime, ALDT, AIBT, ELDT, SIBT, AOBT, ATOT, EOBT, ETOT, SOBTIf status_code = ’’:       status_time = ’’
If status_code = ’N’:     status_time = ’NEXT_INFO’
If status_code = ’E’:     status_time = ’ELDT’ - for arrivals, ’EOBT’ or 'ETOT' - for departures
If status_code = ’D’: status_time = ’AOBT’ – for departures (ATOT if AOBT is not present)
If status_code = ’A’: status_time = ’ALDT’ – for arrivals (AIBT if ALDT is not present)
If status_code = ’C’:     status_time = ’’

delayedNOT in model

Arrival: Is derived from ProbLDT, ProbIBT, SIBT

Departure: Is derived from ProbOBT, SOBT.

delayed = Y if SIBT/SOBT - Prob time > 15 min

To be deployed:

Arrival
1. If ALDT is not null and ALDT - SIBT >= 16 min => delayed = Y
2. If ALDT is null and Airline_ELDT is not null and Airline_ELDT - SIBT >= 16 min => delayed = Y
3. If ALDT is null and Airline_ELDT is null and ELDT is not null and ELDT - SIBT >= 16 min => delayed = Y
Departure
1. If AOBT is not null and AOBT - SOBT >= 16 min => delayed = Y
2. If AOBT is null and Airline_EOBT is not null and Airline_EOBT - SOBT >= 16 min => delayed = Y
3. If AOBT is null and Airline_EOBT is null and EOBT is not null and EOBT - SOBT >= 16 min => delayed = Y


handlingAgentArrivalData.HandlerName or DepartureData.HandlerName

handlingAgentCodeArrivalData.HandlerCode or DepartureData.HandlerCode

codeshare_keyN/A

flight_leg_keyN/A

total_paxPassengerData.PaxSeatedOnBoard

total_plePaxEstimateDisembarking or PaxEstimateBoardingPaxEstimateDisembarking for arrival or PaxEstimateBoarding for departure
total_transferPaxTransferDisembarking or PaxTransferBoardingPaxTransferDisembarking for arrival or PaxTransferBoarding for departure
gateClosedTimeGateCloseExample value: 2023-03-14T10:35:12Z
codeshareAirlineDesignatorsNA

codeshareAirlineNamesCodeshareAirlineIATA

codeshareFlightNumbersCodeshareFlightNumber

codeshareOperationalSuffixsNA

paxBoardingpaxBoarding

paxDisembarkingpaxDisembarking

Time specifications:

All times are listed in UTC format and are in the format ISO 8601 (Wikipedia: ISO 8601-format) [YYYY]-[MM]-[DD]T[hh]:[mm]:[ss]Z. Please make sure to adjust for time zone and summer time as required.

...