Fuser Database Mapping Extensions

Overview

The tables below describing the mapping from the data sources to the Fuser Core Extension. This extension is needed due to the limitation of the FIXM schema. Not all data elements received from the ATD-2 source have an equivalent data element in the FIXM schema used in the Fuser. An extension to the FIXM schema used in the Fuser database is used to capture any data elements not mappable to FIXM. The first column in each table is the Fuser Core Extension attribute. The subsequent columns are the data elements as received from a Processor.

TFMS Flight Extension Mapping

Fuser Core Extension Element	TFMS Flight Transfer Element
arrivalRunwayAirlineTime	arrivalRunwayAirlineTime
arrivalRunwayOriginalControlledTime	arrivalRunwayOriginalControlledTime
arrivalStandAirlineTime	arrivalStandAirlineTime
canceled	canceled
cdmParticipant	cdmParticipant
controlElement	controlElement
controlIndicator	controlIndicator
departureRunwayAirlineTime	departureRunwayAirlineTime
departureRunwayOriginalControlledTime	departureRunwayOriginalControlledTime
departureStandAirlineTime	departureStandAirlineTime
diversion	False if diversionIndicator = "NO_DIVERSION", True if diversionIndicator is other non-null text value
diversionIndicator	diversionIndicator
diversionCancelFlightRef	diversionCancelFlightIndex
diversionCancelNewFlightRef	diversionCancelNewFlightIndex
flightCreationTime	flightCreationTime
flightRef	flightIndex
messageTrigger	messageTrigger
messageType	messageType
lastTfmPosition	same "position" attribute as core

TFMS Terminal Flight Extension Mapping

Fuser Core Extension Element	TFMS Terminal Flight Element
accDepRwyList	accDepRwyList
actualInBlockTime	actualInBlockTime
actualLandingTime	actualLandingTime
actualOffBlockTime	actualOffBlockTime
actualTakeOffTime	actualTakeOffTime
arrIntentToHoldInMove	arrIntentToHoldInMove
arrIntentToHoldNonMove	arrIntentToHoldNonMove
arrStandAssignment	arrStandAssignment
arrStandAvailable	arrStandAvailable
cancelled	flightCancel
cdmParticipant	cdmPart
depIntentToHoldInMove	depIntentToHoldInMove
depIntentToHoldNonMove	depIntentToHoldNonMove
depReadiness	depReadiness
depStandAssignment	depStandAssignment
earliestOffBlockTime	earliestOffBlockTime
flightRef	flightRef
initialOffBlockTime	initialOffBlockTime
intendedArrSpot	intendedArrSpot
intendedDeiceLocation	intendedDeiceLocation
intendedDepSpot	intendedDepSpot
intentReturnToGate	intentReturnToGate
intentToBeDeiced	intentToBeDeiced
majorCarrier	majorCarrier
messageType	msgType
projectedWheelsUpTime	projectedWheelsUpTime
source	source
sourceFacility	sourceFacility
targetMAEntryTime	targetMAEntryTime
targetOffBlockTime	targetOffBlockTime
targetTakeOffTime	targetTakeOffTime
tmatMarkedForSub	tmatMarkedForSub
tmatRelinquish	tmatRelinquish
unaccDepRwyList	unaccDepRwyList

TBFM Extension Mapping

Fuser Core Extension Element	TBFM SWIM Element	Applied Logic
arrivalMeterFix	tmaType.air.mrp.mfx	See isArrival/DepartureMrp logic
arrivalSchedulingFix	tmaType.air.mrp.sfx	See isArrival/DepartureMrp logic
arrivalRunway	tmaType.air.flt.trw if exists, tmaType.air.mrp.rwy	See isArrival/DepartureMrp logic
arrivalRunwaySta	tmaType.air.sta.rwy	See isArrival/DepartureMrp logic
arrivalMeterFixEta	tmaType.air.eta.mfx	See isArrival/DepartureMrp logic
arrivalSchedulingFixEta	tmaType.air.eta.sfx	See isArrival/DepartureMrp logic
arrivalSchedulingFixSta	tmaType.air.sta.sfx	See isArrival/DepartureMrp logic
arrivalStasFrozen	tmaType.air.sch.sfz	See isArrival/DepartureMrp logic
arrivalSchedulingSuspended	tmaType.air.sch.sus	See isArrival/DepartureMrp logic
arrivalRunwayAssignmentFrozen	tmaType.air.sch.rfz	See isArrival/DepartureMrp logic
departureMeterFix	tmaType.air.mrp.mfx	See isArrival/DepartureMrp logic
departureSchedulingFix	tmaType.air.mrp.sfx	See isArrival/DepartureMrp logic
departureMeterFixEta	tmaType.air.eta.mfx	See isArrival/DepartureMrp logic
departureSchedulingFixEta	tmaType.air.eta.sfx	See isArrival/DepartureMrp logic
departureSchedulingFixSta	tmaType.air.sta.sfx	See isArrival/DepartureMrp logic
departureStasFrozen	tmaType.air.sch.sfz	See isArrival/DepartureMrp logic
departureSchedulingSuspended	tmaType.air.sch.sus	See isArrival/DepartureMrp logic
lastTbfmPosition	<same as core position>
tmaId	tmaType.air.TmaId

isArrival/DepartureMrp Logic

isArrivalMrp
  true if tmaType.air.mrp.cat in ( ARRIVAL, SATELLITE_ARRIVAL, DEPARTURE_ARRIVAL, SATELLITE, EXTERNAL_TO_SATELLITE )
    OR (tmaType.air.mrp.cat = SATELLITE_TO_EXTERNAL AND tmaType.air.mrp.tra != "EDC")

isDepartureMrp
  true if tmaType.air.mrp.cat in ( DEPARTURE, SATELLITE_DEPARTURE, DEPARTURE_ARRIVAL, SATELLITE )
    OR (tmaType.air.mrp.cat = SATELLITE_TO_EXTERNAL AND tmaType.air.mrp.tra == "EDC")

STDDS SMES Extension Mapping

Fuser Core Extension Element	ASDE-X Element
asdexAirport.iata	airport
lastAsdexPosition.altitude	altitude
lastAsdexPosition.heading	heading
lastAsdexPosition.latitude	latitude
lastAsdexPosition.longitude	longitude
lastAsdexPosition.source	"ASDEX"
lastAsdexPosition.speed	speed
lastAsdexPosition.timestamp	time
trackId	trackNumber

+ Back to Top

	+ Freedom of Information Act + Budgets, Strategic Plans and Accountability Reports + The President's Management Agenda + NASA Privacy Statement, Disclaimer, and Accessibility Certification + Inspector General Hotline + Equal Employment Opportunity Data Posted Pursuant to the No Fear Act + Information-Dissemination Priorities and Inventories		Curator: Victoriana Delossantos NASA Official: Al Capps Last Updated: May 22, 2019