NASA - National Aeronautics and Space Administration
Follow this link to skip to the main content
+ Visit NASA.gov
+ Contact NASA
ABOUT NASA LATEST NEWS MULTIMEDIA MISSIONS MY NASA WORK FOR NASA
ATD-2 Concept graphic

NASA Airspace Technology Demonstration 2 (ATD-2) Industry Workshop


ATD-2 Industry Workshop Documentation Outline / High Level Software Description / Fuser Data Processing


Fuser Database Input Mapping Table


Overview

This page describes documents the mapping between the output of the Processors and the elements in the Core Fuser database. The Fuser creates a single file or "object" for each flight it is tracking using a a common schema. The Flight Object has a set of core attributes that are common to all flight stored in the Fuser database. Each flight object may also have a attributes contained in extensions that are specific to a data source. More information on the Fuser and how to processes data, can be found here. The tables below describing the mapping from the data sources to the single format used to store flight objects in the Fuser database. Tables describing the mappings which utilize extension attributes can be found here.


The tables below describing the mapping from the data sources to the Fuser Flight core attributes. 

For example, the Fuser Flight aircraft type attribute is a string that can be set based on the following fields in each data source:

  • TFM Flight Transfer message - the aircraftType attribute
  • TBFM flight update - the tmaType.air.flt.Typ attribute
  • SMES Messages - the aircraftType attribute.

Some of these updates can also have multiple sources of information.


Core Attributes


Core Fuser Database Element

TFMS Flight Transfer Element

TBFM SWIM Element

TFMS Terminal Flight Element

SMES (ASDE-X) Pre-Fuser Element

Notes

1 acid

acid

tmaType.air.flt.aid acid acid
2 aircraftAddress


modeSAddress
3 aircraftEngineClass physicalClass tmaType.air.flt.Eng


4 aircraftEquipmentQualifier acEqpSuffix tmaType.air.flt.Typ
equipment qualifier parsed from TMA element


5 aircraftRegistration

acftRegistrationNumber

6 aircraftType aircraftType tmaType.air.flt.Typ
aircraft type parsed from TMA element
aircraftType
7 altitudeAssigned altitudeAssigned tmaType.air.flt.Ara 
(if tmaType.air.flt.Fps != proposed)


8 altitudeFiled altitudeFiled



9 altitudeRequested altitudeRequested tmaType.air.flt.Ara 
(if tmaType.air.flt.Fps == proposed)


10 apreqRestrictionIds




11 arrivalAerodromeFaaLid



set by Fuser AerodromeUpdater
12 arrivalAerodromeIataName arrAirport  tmaType.air.flt.Apt Derived from arrArpt/arrArptIcao arrivalAirport set by Fuser AerodromeUpdater
13 arrivalAerodromeIcaoName



set by Fuser AerodromeUpdater
14 arrivalFixActual



set by ATD-2
15 arrivalFixActualTime



set by ATD-2
16 arrivalFixDecisionTree



set by ATD-2
17 arrivalFixEstimatedTime arrFixEstimatedTime



18 arrivalFixModel



set by ATD-2
19 arrivalFixPositionDerived



set by ATD-2
20 arrivalFixSource



set by ATD-2
21 arrivalFixSourceData arrFix


also set by ATD-2 based on route string
22 arrivalFixTargetedTime



set by ATD-2
23 arrivalFixUndelayedTime



set by ATD-2
24 arrivalGateConflict



set by ATD-2
25 arrivalMovementAreaActualTime



set by ATD-2
26 arrivalMovementAreaTargetedTime



set by ATD-2
27 arrivalMovementAreaUndelayedTime



set by ATD-2
28 arrivalRunwayActual



set by ATD-2
29 arrivalRunwayActualTime arrivalRunwayActualTime
actualLandingTime
also set by ATD-2
30 arrivalRunwayAssigned
tmaType.air.mrp.rwy
(see isArrivalMrp logic on tbfmExt page)


31 arrivalRunwayControlledTime arrivalRunwayControlledTime



32 arrivalRunwayDecisionTree



set by ATD-2
33 arrivalRunwayEstimatedTime arrivalRunwayEstimatedTime tmaType.air.eta.etaRwy
(see isArrivalMrp logic on tbfmExt page)


34 arrivalRunwayMeteredTime
tmaType.air.sta.staRwy
(see isArrivalMrp logic on tbfmExt page)


35 arrivalRunwayMeteredTime.isFrozen
tmaType.air.sch.sfz
(see isArrivalMrp logic on tbfmExt page)


36 arrivalRunwayOperationalNecessity



set by ATD-2
37 arrivalRunwayPositionDerived



set by ATD-2
38 arrivalRunwayScheduledTime arrivalRunwayScheduledTime



39 arrivalRunwayScratchpad



set by ATD-2
40 arrivalRunwaySource



set by ATD-2
41 arrivalRunwayTargetedTime



set by ATD-2
42 arrivalRunwayUndelayedTime



set by ATD-2
43 arrivalRunwayUser



set by ATD-2
44 arrivalSpotAirline

intendedArrSpot

45 arrivalSpotDecisionTree



set by ATD-2
46 arrivalSpotModel



set by ATD-2
47 arrivalSpotPositionDerived



set by ATD-2
48 arrivalSpotSource



set by ATD-2
49 arrivalSpotUser



set by ATD-2

50 arrivalStandActualTime arrivalStandActualTime
actualInBlockTime
also set by ATD-2
51 arrivalStandAirline

arrStandAssignment

52 arrivalStandAirlineTime arrivalStandAirlineTime



53 arrivalStandDecisionTree



set by ATD-2
54 arrivalStandEstimatedTime




55 arrivalStandScheduledTime




56 arrivalStandSource



set by ATD-2
57 arrivalStandTargetedTime



set by ATD-2
58 arrivalStandUndelayedTime



set by ATD-2
59 arrivalStandUser



set by ATD-2
60 beaconCode beaconCode tmaType.air.flt.Bcn.OctalString
beaconCode
61 cancelled canceled 
(when TfmMessageTriggerType = FD_FLIGHT_CANCEL_MSG)
flightCancel

62 cancelledTime timestamp
sourceTimeStamp

63 carrier

airline
aslo set by Fuser's FlightTypeAndCarrierUpdater
64 centerListValues listCenters 



65 computerId computerId



66 controllerClearance



set by ATD-2
67 controllerClearanceTime



set by ATD-2
68 creationTime



set by Fuser
69 delayChargeTo



set by ATD-2
70 delayImpactingConditionPrimary



set by ATD-2
71 delayImpactingConditionSecondary



set by ATD-2
72 delayRemarks



set by ATD-2
73 delayTmiType



set by ATD-2
74 departureAerodromeFaaLid



Fuser AerodromeUpdater
75 departureAerodromeIataName depAirport  tmaType.air.flt.Dap Derived from depArpt/depArptIcao departureAirport Fuser AerodromeUpdater
76 departureAerodromeIcaoName



Fuser AerodromeUpdater
77 departureFixActual



set by ATD-2
78 departureFixActualTime



set by ATD-2
79 departureFixDecisionTree



set by ATD-2
80 departureFixEstimatedTime depFixEstimatedTime



81 departureFixModel



set by ATD-2
82 departureFixPositionDerived



set by ATD-2
83 departureFixSource




84 departureFixSourceData depFix


also set by ATD-2 based on route string
85





86 departureFixTargetedTime



set by ATD-2
87 departureFixUndelayedTime



set by ATD-2
88 departureFixUser



set by ATD-2
89 departureGateConflict



set by ATD-2
90 departureMovementAreaActualTime



set by ATD-2
91 departureMovementAreaSurfaceMeteredTimeFrozen



set by ATD-2
92 departureMovementAreaSurfaceMeteredTimeValue



set by ATD-2
93 departureMovementAreaTargetedTime



set by ATD-2
94 departureMovementAreaUndelayedTime



set by ATD-2
95 departureQueueEntryActualTime



set by ATD-2
96 departureRunwayActual



set by ATD-2
97 departureRunwayActualTime departureRunwayActualTime tmaType.air.flt.aot actualTakeOffTime
also set by ATD-2
98 departureRunwayAssigned
tmaType.air.flt.drw


99 departureRunwayControlledTime departureRunwayControlledTime tmaType.air.flt.etm


100 departureRunwayDecisionTree



set by ATD-2
101 departureRunwayEstimatedTime departureRunwayEstimatedTime tmaType.air.flt.Etd


102 departureRunwayMeteredTimeIsFrozen
tmaType.air.sch.sfz
(see isDepartureMrp logic on tbfmExt page)


103 departureRunwayMeteredTimeValue departureRunwayMeteredTime tmaType.air.flt.std


104 departureRunwayModel



set by ATD-2
105 departureRunwayOperationalNecessity



set by ATD-2
106 departureRunwayPositionDerived



set by ATD-2
107 departureRunwayScheduledTime departureRunwayScheduledTime



108 departureRunwaySource



set by ATD-2
109 departureRunwayTargetedTime



set by ATD-2
110 departureRunwayUndelayedTime



set by ATD-2
111 departureRunwayUser



set by ATD-2
112 departureSpotAirline

intendedDepSpot

113 departureSpotDecisionTree



set by ATD-2
114 departureSpotModel



set by ATD-2
115 departureSpotPositionDerived



set by ATD-2
116 departureSpotSource



set by ATD-2
117 departureSpotUser



set by ATD-2
118 departureStandActualTime departureStandActualTime
actualOffBlockTime
also set by ATD-2
119 departureStandAirline

depStandAssignment

120 departureStandAirlineTime depratureStandAirlineTime



121 departureStandDecisionTree



set by ATD-2
122 departureStandEarliestTime

earliestOffBlockTime

123 departureStandEstimatedTime




124 departureStandInitialTime departureStandInitialTime



125 departureStandIntendedTime



set by ATD-2
126 departureStandProposedTime departureStandProposedTime



127 departureStandReadyTime



set by ATD-2
128 departureStandScheduledTime




129 departureStandSource



set by ATD-2
130 departureStandSurfaceMeteredTimeFrozen



set by ATD-2
131 departureStandSurfaceMeteredTimeValue



set by ATD-2
132 departureStandTargetedTime



set by ATD-2
133 departureStandUndelayedTime



set by ATD-2
134 departureStandUser



set by ATD-2
135 eramGufi eramGufi



136 estimatedDepartureClearanceTime departureRunwayControlledTime tmaType.air.flt.etm


137 filedFlight True if messageType == FLIGHT_PLAN_INFORMATION or FLIGHT_PLAN_AMENDMENT_INFORMATION was received true if fltA10 is set


138 fixClosureIds



set by ATD-2
139 fixList listFixes



140 flightType

if sensitivityReason = FM : MILITARY

if messageType = FLIGHT_SCHEDULE_ACTIVATE received : SCHEDULED_AIR_TRANSPORT



Fuser types:

  • SCHEDULED_AIR_TRANSPORT
  • GENERAL_AVIATION
  • NON_SCHEDULED_AIR_TRANSPORT
  • MILITARY
  • OTHER

FlightTypeAndCarrierUpdater


141 groundStopRestrictionIds



set by ATD-2
142 gufi gufi gufiTmaType.gufi gufi gufi set in the incoming messages by the GUFI service
143 international



Fuser InternationalUpdater
144 lastUpdateSource TFM TMA TFM_TFDM ASDEX
145 longOnBoard



set by ATD-2
146 majorCarrier

If sourceFacility is 3 characters, then majorCarrier = sourceFacility


147 manuallyFrozen



set by ATD-2
148 mitRestrictionIds



set by ATD-2
149 multipleFlightPlansIndicator



set Fuser PreDepartureFlightPlanUpdater
150 positionAltitude altitude tmaType.air.trk.Alt
altitude
151 positionHeading
tmaType.air.trk.Hdg
heading
152 positionLatitude currPos.latDeg tmaType.air.trk.lat.TrkLatDMS.TrkLatDecimalDegrees
latitude
153 positionLongitude currPos.lonDeg tmaType.air.trk.lon.TrkLonDMS.TrkLonDecimalDegrees
longitude
154 positionSource "TFM" "TMA"
"ASDEX"
155 positionSpeed speed tmaType.air.trk.Gsp
speed
156 positionTimestamp timestamp tmaType.air.trk.Ttm
time
157 preDepartureFlightPlans



set Fuser PreDepartureFlightPlanUpdater
158 previousControllerClearance



set by ATD-2
159 priorityStatus



set by ATD-2
160 pushbackClearanceUndone



set by ATD-2
161 recordIdentifier



set by Fuser when writing to DB
162 recordTimestamp



set by Fuser when writing to DB
163 releaseAcknowledgeRequired



set by ATD-2
164 releaseForced



set by ATD-2
165 releaseMode



set by ATD-2
166 releasePrescheduled



Generated by logic in the Apreq Management System to detect if flights are eligible for prescheduling
167 releaseRequestAllowed



set by ATD-2
168 releaseRequestedRollTime



set by ATD-2
169 releaseRequestType



Generated by user action on the STBO client
170 releaseScheduledRollEarliestTime



set by ATD-2
171 releaseScheduledRollLatestTime



set by ATD-2
172 releaseScheduledRollTime



set by ATD-2
173 releaseScheduledWheelsOffTime



set by ATD-2
174 releaseState



set by ATD-2
175 releaseSwapGufi



Generated by user action on the STBO client
176 releaseUpdateSource



set by ATD-2
177 routeText routeString tmaType.air.flt.A10


178 scheduledFlight

True if messageType == FLIGHT_SCHEDULE_ACTIVATE was received





179 sectorList listSectors



180 sensitiveData

True if sensitivity=D or A

Falise if sensitivity = R and sensitivityReason = FM or FS

True if securityLevel = NAS Only

False if securityLevel = All or *

True if sensitivity = D or A

Falise if sensitivity = R and sensitivityReason = FM or FS

True if sentTo = all

False if sendTo = authorized


181 sequenceId



Generated and added to database by Fuser
182 sourceFacility computerFacility



183 speedFiled speedFiled tmaType.air.flt.Spd
(converted from mach to knots when necessary)


184 superStreamArtcc




185 superStreamClassName




186 superStreamPoint




187 superStreamTracon




188 surfaceAirportName


airport
189 surfaceFlightState



set by ATD-2
190 systemId
gufiTmaType.envelopeSource sourceFacility

191 timestamp timestamp gufiTmaType.envelopeDate sourceTimestamp time
192 timestampFuserProcessed



Generated and added to database by Fuser
193 timestampFuserReceived



Generated and added to database by Fuser
194 timestampSource timestamp envelopeDate sourceTimestamp time
195 timestampSourceReceived timestampSourceReceived timestampSourceReceive timestampSourceReceived timestampSourceReceive Generated and added to database by Data Parsers
196 timestampSourceProcessed timestampSourceProcessed timestampSourceProcess timestampSourceProcessed timestampSourceProcess Generated and added to database by Data Parsers
197 wakeTurbulenceCategory



Set by Fuser based on aircraft type
FirstGov - Your First Click to the US Government
+ 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
NASA - National Aeronautics and Space Administration
Curator: Victoriana Delossantos
NASA Official: Al Capps
Last Updated: May 22, 2019