VATSWIM API Field Mapping
FIXM + TFMS Alignment with vATCSCC Extensions
Version: 1.1
Date: 2026-01-16
Purpose: Comprehensive field mapping using FIXM as primary standard, TFMS for abbreviations, with vATCSCC extensions for VATSIM-specific fields.
Naming Conventions
| Layer |
Convention |
Example |
| FIXM (Full) |
camelCase, hierarchical |
actualOffBlockTime |
| TFMS (Abbrev) |
UPPERCASE, 2-6 chars |
AOBT |
| vATCSCC Extension |
camelCase with vATCSCC: prefix |
vATCSCC:pilotCid |
| JSON API |
snake_case |
actual_off_block_time |
| Database |
snake_case |
actual_off_block_time |
1. Flight Identification
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Unique Flight ID |
gufi |
GUFI |
gufi |
gufi |
gufi |
✅ OK |
| Internal Flight Key |
— |
— |
flight_key |
flight_key |
flight_key |
✅ OK |
| Callsign |
aircraftIdentification |
ACID |
aircraft_identification |
callsign |
aircraft_identification |
🔄 Rename |
| VATSIM Pilot CID |
vATCSCC:pilotCid ⭐ |
CID |
pilot_cid |
cid |
pilot_cid |
🔄 Rename |
| VATSIM Pilot Name |
vATCSCC:pilotName ⭐ |
— |
pilot_name |
— |
pilot_name |
➕ Add |
| VATSIM Pilot Rating |
vATCSCC:pilotRating ⭐ |
— |
pilot_rating |
— |
pilot_rating |
➕ Add |
| Flight Number |
flightNumber |
FLT_NUM |
flight_number |
— |
flight_number |
➕ Add |
| Airline (ICAO) |
operatorIcaoDesignator |
AIRLINE |
operator_icao |
airline_icao |
operator_icao |
🔄 Rename |
| Airline (IATA) |
operatorIataDesignator |
— |
operator_iata |
— |
operator_iata |
➕ Add |
| Airline Name |
operatorName |
— |
operator_name |
airline_name |
operator_name |
🔄 Rename |
| Registration |
registration |
REG |
registration |
— |
registration |
➕ Add |
| SSR Code (Squawk) |
assignedCode |
BCN |
assigned_code |
transponder |
assigned_code |
🔄 Rename |
2. Aircraft Information
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Aircraft Type (ICAO) |
aircraftType |
TYPE |
aircraft_type |
aircraft_type |
aircraft_type |
✅ OK |
| Aircraft Type (FAA) |
otherAircraftType |
APTS |
other_aircraft_type |
aircraft_faa |
other_aircraft_type |
🔄 Rename |
| Wake Category (ICAO) |
wakeTurbulence |
WAKE |
wake_turbulence |
wake_category |
wake_turbulence |
🔄 Rename |
| Weight Class (FAA) |
nas:weightClass |
WGTCLASS |
weight_class |
weight_class |
weight_class |
✅ OK |
| Engine Type |
engineType |
— |
engine_type |
engine_type |
engine_type |
✅ OK |
| Engine Count |
engineCount |
— |
engine_count |
— |
engine_count |
➕ Add |
| Aircraft Category |
aircraftCategory |
AC_CAT |
aircraft_category |
ac_cat |
aircraft_category |
🔄 Rename |
| Equipment Qualifier |
equipmentQualifier |
EQUIP |
equipment_qualifier |
— |
equipment_qualifier |
➕ Add |
| User Category |
nas:userCategory |
USER_CAT |
user_category |
user_category |
user_category |
✅ OK |
| CDM Participant |
nas:cdmParticipant |
CDM |
cdm_participant |
cdm_participant |
cdm_participant |
✅ OK |
3. Airports & Locations
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Departure Airport |
departureAerodrome |
DEPT |
departure_aerodrome |
dept_icao |
departure_aerodrome |
🔄 Rename |
| Arrival Airport |
arrivalAerodrome |
DEST |
arrival_aerodrome |
dest_icao |
arrival_aerodrome |
🔄 Rename |
| Alternate Airport |
alternateAerodrome |
ALT1 |
alternate_aerodrome |
— |
alternate_aerodrome |
➕ Add |
| Diversion Airport |
diversionAerodrome |
DIV |
diversion_aerodrome |
— |
diversion_aerodrome |
➕ Add |
| Departure Gate |
departureGate |
— |
departure_gate |
— |
departure_gate |
➕ Add |
| Arrival Gate |
arrivalGate |
— |
arrival_gate |
— |
arrival_gate |
➕ Add |
| Departure Runway |
departureRunway |
DRWY |
departure_runway |
— |
departure_runway |
➕ Add |
| Arrival Runway |
arrivalRunway |
ARWY |
arrival_runway |
— |
arrival_runway |
➕ Add |
| Departure ARTCC |
departureAirspace |
DEPT_CTR |
departure_airspace |
fp_dept_artcc |
departure_airspace |
🔄 Rename |
| Arrival ARTCC |
arrivalAirspace |
DEST_CTR |
arrival_airspace |
fp_dest_artcc |
arrival_airspace |
🔄 Rename |
| Departure TRACON |
vATCSCC:departureTracon ⭐ |
DEPT_APP |
departure_tracon |
fp_dept_tracon |
departure_tracon |
🔄 Rename |
| Arrival TRACON |
vATCSCC:arrivalTracon ⭐ |
DEST_APP |
arrival_tracon |
fp_dest_tracon |
arrival_tracon |
🔄 Rename |
4. Route & Trajectory
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Filed Route |
routeText |
ROUTE |
route_text |
route |
route_text |
🔄 Rename |
| Current Route |
currentRouteText |
CURR_RTE |
current_route_text |
— |
current_route_text |
➕ Add |
| Parsed Route |
vATCSCC:parsedRoute ⭐ |
— |
parsed_route |
route_parsed |
parsed_route |
🔄 Rename |
| Route Quality |
vATCSCC:routeQuality ⭐ |
— |
route_quality |
route_quality |
route_quality |
✅ OK |
| SID |
standardInstrumentDeparture |
SID |
sid |
— |
sid |
➕ Add |
| STAR |
standardInstrumentArrival |
STAR |
star |
— |
star |
➕ Add |
| Approach |
approachProcedure |
IAP |
approach_procedure |
— |
approach_procedure |
➕ Add |
| Departure Fix |
departurePoint |
DFIX |
departure_point |
— |
departure_point |
➕ Add |
| Arrival Fix |
arrivalPoint |
AFIX |
arrival_point |
— |
arrival_point |
➕ Add |
| Cruise Altitude |
cruisingLevel |
ALT |
cruising_level |
cruise_altitude |
cruising_level |
🔄 Rename |
| Cruise Speed |
cruisingSpeed |
SPD |
cruising_speed |
cruise_speed |
cruising_speed |
🔄 Rename |
| Flight Rules |
flightRulesCategory |
FLT_RULES |
flight_rules_category |
flight_rules |
flight_rules_category |
🔄 Rename |
| Total Distance |
totalFlightDistance |
DIST |
total_flight_distance |
route_total_nm |
total_flight_distance |
🔄 Rename |
| GCD Distance |
greatCircleDistance |
GCD |
great_circle_distance |
gcd_nm |
great_circle_distance |
🔄 Rename |
| Remarks |
remarks |
RMK |
remarks |
remarks |
remarks |
✅ OK |
5. Position & Track Data
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Latitude |
position/latitude |
LAT |
latitude |
lat |
latitude |
🔄 Rename |
| Longitude |
position/longitude |
LON |
longitude |
lon |
longitude |
🔄 Rename |
| Altitude (ft) |
altitude |
ALT |
altitude |
altitude |
altitude |
✅ OK |
| Flight Level |
flightLevel |
FL |
flight_level |
— |
flight_level |
➕ Add |
| Track (°) |
track |
HDG |
track |
heading |
track |
🔄 Rename |
| Ground Speed (kts) |
groundSpeed |
GS |
ground_speed |
groundspeed |
ground_speed |
🔄 Rename |
| True Airspeed |
trueAirspeed |
TAS |
true_airspeed |
— |
true_airspeed |
➕ Add |
| Mach Number |
machNumber |
MACH |
mach_number |
— |
mach_number |
➕ Add |
| Vertical Rate |
verticalRate |
VR |
vertical_rate |
— |
vertical_rate |
➕ Add |
| Position Time |
positionTime |
POSTIME |
position_time |
last_seen_utc |
position_time |
🔄 Rename |
| Distance to Dest |
distanceToDestination |
DTG |
distance_to_destination |
dist_to_dest_nm |
distance_to_destination |
🔄 Rename |
| Distance Flown |
distanceFlown |
— |
distance_flown |
dist_flown_nm |
distance_flown |
🔄 Rename |
| Percent Complete |
vATCSCC:percentComplete ⭐ |
PCT |
percent_complete |
pct_complete |
percent_complete |
🔄 Rename |
| Current ARTCC |
currentAirspace |
CUR_ARTCC |
current_airspace |
— |
current_airspace |
➕ Add |
| Current Sector |
currentSector |
SECTOR |
current_sector |
— |
current_sector |
➕ Add |
| Current Airport Zone |
vATCSCC:currentAirportZone ⭐ |
ZONE |
current_airport_zone |
current_zone |
current_airport_zone |
🔄 Rename |
| Zone Airport |
vATCSCC:currentZoneAirport ⭐ |
— |
current_zone_airport |
current_zone_airport |
current_zone_airport |
✅ OK |
6. Flight Times - OOOI
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| OUT (Block Out) |
actualOffBlockTime |
AOBT |
actual_off_block_time |
out_utc |
actual_off_block_time |
🔄 Rename |
| OFF (Wheels Up) |
actualTimeOfDeparture |
ATOT |
actual_time_of_departure |
off_utc |
actual_time_of_departure |
🔄 Rename |
| ON (Wheels Down) |
actualLandingTime |
ALDT |
actual_landing_time |
on_utc |
actual_landing_time |
🔄 Rename |
| IN (Block In) |
actualInBlockTime |
AIBT |
actual_in_block_time |
in_utc |
actual_in_block_time |
🔄 Rename |
7. Flight Times - Estimated
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Est Off-Block |
estimatedOffBlockTime |
EOBT |
estimated_off_block_time |
etd_utc |
estimated_off_block_time |
🔄 Rename |
| Est Departure |
estimatedTimeOfDeparture |
ETD |
estimated_time_of_departure |
— |
estimated_time_of_departure |
➕ Add |
| Est Arrival |
estimatedTimeOfArrival |
ETA |
estimated_time_of_arrival |
eta_utc |
estimated_time_of_arrival |
🔄 Rename |
| Est In-Block |
estimatedInBlockTime |
EIBT |
estimated_in_block_time |
— |
estimated_in_block_time |
➕ Add |
| ETA Qualifier |
etaQualifier |
ETA_PREFIX |
eta_qualifier |
— |
eta_qualifier |
➕ Add |
| ETD Qualifier |
etdQualifier |
ETD_PREFIX |
etd_qualifier |
— |
etd_qualifier |
➕ Add |
8. Flight Times - Controlled (TMI)
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| EDCT |
expectedDepartureClearanceTime |
EDCT |
edct |
— |
edct |
➕ Add |
| Original EDCT |
originalEdct |
OEDCT |
original_edct |
— |
original_edct |
➕ Add |
| Controlled Departure |
controlledTimeOfDeparture |
CTD |
controlled_time_of_departure |
— |
controlled_time_of_departure |
➕ Add |
| Original CTD |
originalCtd |
OCTD |
original_ctd |
— |
original_ctd |
➕ Add |
| Controlled Arrival |
controlledTimeOfArrival |
CTA |
controlled_time_of_arrival |
— |
controlled_time_of_arrival |
➕ Add |
| Slot Time |
slotTime |
SLOT |
slot_time |
— |
slot_time |
➕ Add |
9. Flight Times - A-CDM Milestones
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| TOBT |
targetOffBlockTime |
TOBT |
target_off_block_time |
— |
target_off_block_time |
➕ Add |
| TSAT |
targetStartupApprovalTime |
TSAT |
target_startup_approval_time |
— |
target_startup_approval_time |
➕ Add |
| TTOT |
targetTakeoffTime |
TTOT |
target_takeoff_time |
— |
target_takeoff_time |
➕ Add |
| TLDT |
targetLandingTime |
TLDT |
target_landing_time |
— |
target_landing_time |
➕ Add |
10. Flight Times - Zone Detection (vATCSCC Extension)
| Concept |
FIXM-like Field |
JSON API |
Current DB |
New DB |
Migration |
| Parking Left |
vATCSCC:parkingLeftTime ⭐ |
parking_left_time |
parking_left_utc |
parking_left_time |
🔄 Rename |
| Taxiway Entered |
vATCSCC:taxiwayEnteredTime ⭐ |
taxiway_entered_time |
taxiway_entered_utc |
taxiway_entered_time |
🔄 Rename |
| Hold Entered |
vATCSCC:holdEnteredTime ⭐ |
hold_entered_time |
hold_entered_utc |
hold_entered_time |
🔄 Rename |
| Runway Entered |
vATCSCC:runwayEnteredTime ⭐ |
runway_entered_time |
runway_entered_utc |
runway_entered_time |
🔄 Rename |
| Rotation |
vATCSCC:rotationTime ⭐ |
rotation_time |
rotation_utc |
rotation_time |
🔄 Rename |
| Approach Start |
vATCSCC:approachStartTime ⭐ |
approach_start_time |
approach_start_utc |
approach_start_time |
🔄 Rename |
| Threshold |
vATCSCC:thresholdTime ⭐ |
threshold_time |
threshold_utc |
threshold_time |
🔄 Rename |
| Touchdown |
vATCSCC:touchdownTime ⭐ |
touchdown_time |
touchdown_utc |
touchdown_time |
🔄 Rename |
| Rollout End |
vATCSCC:rolloutEndTime ⭐ |
rollout_end_time |
rollout_end_utc |
rollout_end_time |
🔄 Rename |
| Parking Entered |
vATCSCC:parkingEnteredTime ⭐ |
parking_entered_time |
parking_entered_utc |
parking_entered_time |
🔄 Rename |
11. Flight Status & Phase
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Flight Status |
flightStatus |
STATUS |
flight_status |
phase |
flight_status |
🔄 Rename |
| Is Active |
vATCSCC:isActive ⭐ |
ACTIVE |
is_active |
is_active |
is_active |
✅ OK |
| Last Source |
vATCSCC:lastSource ⭐ |
SRC |
last_source |
last_source |
last_source |
✅ OK |
12. TMI / ATFM Control Data
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Control Type |
controlType |
CTL_TYPE |
control_type |
— |
control_type |
➕ Add |
| Control Element |
controlElement |
CTL_ELEM |
control_element |
— |
control_element |
➕ Add |
| Program Name |
programName |
CTL_PRGM |
program_name |
— |
program_name |
➕ Add |
| Delay Value |
delayValue |
DLA_ASGN |
delay_value |
— |
delay_value |
➕ Add |
| Delay Status |
delayStatus |
DLY_STATUS |
delay_status |
— |
delay_status |
➕ Add |
| Ground Stop Held |
groundStopHeld |
GS_HELD |
ground_stop_held |
— |
ground_stop_held |
➕ Add |
| Exempt Indicator |
exemptIndicator |
EXEMPT |
exempt_indicator |
— |
exempt_indicator |
➕ Add |
| Exempt Reason |
exemptReason |
EXEMPT_RSN |
exempt_reason |
— |
exempt_reason |
➕ Add |
12.1 External Flow Management (ECFMP, NavCanada, VATPAC)
Provider-agnostic integration for external flow management systems. FIXM-aligned field mapping for global interoperability.
Flow Providers
| Concept |
FIXM Field |
JSON API |
DB Column |
Description |
| Provider Code |
providerCode |
provider.code |
provider_code |
ECFMP, NAVCAN, VATPAC |
| Provider Name |
providerName |
provider.name |
provider_name |
Display name |
| API Base URL |
— |
api.base_url |
api_base_url |
Provider API endpoint |
| Region Codes |
flightInformationRegion |
coverage.regions |
region_codes_json |
EUR, NAM, NAT, PAC |
| FIR Codes |
flightInformationRegion |
coverage.firs |
fir_codes_json |
EGTT, CZQX, etc. |
Flow Events (FIXM: /flight/specialHandling)
| Concept |
FIXM Field |
JSON API |
DB Column |
Description |
| Event Code |
specialHandlingCode |
code |
event_code |
CTP2026, FNO2026 |
| Event Name |
specialHandlingDescription |
name |
event_name |
Cross the Pond 2026 |
| Event Type |
specialHandlingType |
type |
event_type |
SPECIAL, EXERCISE, VIP |
| Start Time |
timeRange/start |
timeRange.start |
start_utc |
Event start |
| End Time |
timeRange/end |
timeRange.end |
end_utc |
Event end |
| GS Exempt |
exemptIndicator |
exemptions.groundStop |
gs_exempt |
Event flights exempt from GS |
| GDP Priority |
priorityIndicator |
exemptions.gdpPriority |
gdp_priority |
Event flights get priority |
| Participant Count |
— |
participantCount |
participant_count |
Number of registered pilots |
Flow Event Participants (FIXM: /flight/flightIdentification)
| Concept |
FIXM Field |
JSON API |
DB Column |
Description |
| Pilot CID |
vATCSCC:pilotCid |
cid |
pilot_cid |
VATSIM CID |
| Callsign |
aircraftIdentification |
callsign |
callsign |
Pre-registered callsign |
| Departure |
departureAerodrome |
departure |
dep_aerodrome |
Origin ICAO |
| Arrival |
arrivalAerodrome |
arrival |
arr_aerodrome |
Destination ICAO |
| Flight Matched |
— |
flightMatched |
flight_uid |
Matched to active flight |
Flow Measures (FIXM: /atfm/flowElement)
| Concept |
FIXM Field |
TFMS |
JSON API |
DB Column |
Description |
| Measure Ident |
flowMeasureIdentifier |
FM_ID |
ident |
ident |
EGTT22A |
| Measure Type |
flowMeasureType |
FM_TYPE |
type |
measure_type |
See table below |
| Measure Value |
flowMeasureValue |
FM_VAL |
value |
measure_value |
Numeric value |
| Measure Unit |
flowMeasureUnit |
— |
unit |
measure_unit |
NM, MIN, SEC, PER_HOUR |
| Reason |
atfmReason |
FM_RSN |
reason |
reason |
CTP Event Traffic |
| Control Element |
controlElement |
CTL_ELEM |
controlElement |
ctl_element |
Airport/FIR/Fix |
| Element Type |
elementType |
ELM_TYPE |
elementType |
element_type |
APT, FIR, FCA, FIX |
| Mandatory Route |
routeConstraint |
MAND_RTE |
mandatoryRoute |
mandatory_route_json |
Required route fixes |
Measure Types (TFMS-aligned)
| Type |
FIXM Equivalent |
Description |
Unit |
MIT |
milesInTrail |
Miles-In-Trail |
NM |
MINIT |
minutesInTrail |
Minutes-In-Trail |
MIN |
MDI |
minimumDepartureInterval |
Minimum Departure Interval |
SEC |
RATE |
departureRate |
Departure Rate Cap |
PER_HOUR |
GS |
groundStop |
Ground Stop |
— |
GDP |
groundDelayProgram |
Ground Delay Program |
MIN |
AFP |
airspaceFlowProgram |
Airspace Flow Program |
MIN |
REROUTE |
routeConstraint |
Mandatory Reroute |
— |
Flow Measure Filters (FIXM: /atfm/flowElement/filter)
| Concept |
FIXM Field |
JSON API |
DB (filters_json) |
Description |
| Departure Airports |
departureAerodrome |
filters.departureAerodrome |
adep |
Origin filter |
| Arrival Airports |
arrivalAerodrome |
filters.arrivalAerodrome |
ades |
Destination filter |
| Departure FIRs |
departureFir |
filters.departureFir |
adep_fir |
Origin FIR filter |
| Arrival FIRs |
arrivalFir |
filters.arrivalFir |
ades_fir |
Destination FIR filter |
| Waypoints |
routePoint |
filters.waypoints |
waypoints |
Route point filter |
| Airways |
airway |
filters.airways |
airways |
Airway filter |
| Flight Level |
flightLevel |
filters.flightLevel |
levels |
Min/max altitude |
| Aircraft Type |
aircraftType |
filters.aircraftType |
aircraft_type |
Type filter |
| Event Membership |
— |
filters.memberEvent |
member_event |
Event ID filter |
Flight-Level Flow Data (adl_flight_tmi extension)
| Concept |
FIXM Field |
JSON API |
DB Column |
Description |
| Flow Event ID |
— |
ecfmp.event.id |
flow_event_id |
FK to tmi_flow_events |
| Flow Event Code |
specialHandlingCode |
ecfmp.event.code |
flow_event_code |
CTP2026 |
| Flow Priority |
priorityIndicator |
ecfmp.priority |
flow_priority |
EVENT, STANDARD |
| GS Exempt Flag |
exemptIndicator |
ecfmp.gsExempt |
flow_gs_exempt |
Event flight exempt |
| Flow Measure ID |
— |
ecfmp.activeMeasure.id |
flow_measure_id |
FK to tmi_flow_measures |
| Flow Measure Ident |
flowMeasureIdentifier |
ecfmp.activeMeasure.ident |
flow_measure_ident |
EGTT22A |
13. Metering & Sequencing (TBFM)
Core TBFM Fields (FIXM 4.3)
| Concept |
FIXM Field |
TFMS |
JSON API |
Current DB |
New DB |
Migration |
| Meter Fix |
meteringPoint |
MF |
metering_point |
— |
metering_point |
➕ Add |
| Meter Time |
meteringTime |
MF_TIME |
metering_time |
— |
metering_time |
➕ Add |
| STA (Runway) |
scheduledTimeOfArrival |
STA |
scheduled_time_of_arrival |
— |
scheduled_time_of_arrival |
➕ Add |
| STD (Runway) |
scheduledTimeOfDeparture |
STD |
scheduled_time_of_departure |
— |
scheduled_time_of_departure |
➕ Add |
| Sequence Number |
sequenceNumber |
SEQ |
sequence_number |
— |
sequence_number |
➕ Add |
| Delay Value |
delayValue |
DLA_ASGN |
metering_delay |
— |
metering_delay |
➕ Add |
| Frozen Indicator |
frozenIndicator |
FROZEN |
metering_frozen |
— |
metering_frozen |
➕ Add |
| Arrival Stream |
arrivalStream |
GATE |
arrival_stream |
— |
arrival_stream |
➕ Add |
TBFM Extended Fields (vATCSCC)
| Concept |
FIXM-like Field |
TFMS |
JSON API |
New DB |
Description |
| Metering Status |
vATCSCC:meteringStatus ⭐ |
MTR_STS |
metering_status |
metering_status |
UNMETERED/METERED/FROZEN/SUSPENDED/EXEMPT |
| Undelayed ETA |
vATCSCC:undelayedEta ⭐ |
UETA |
undelayed_eta |
undelayed_eta |
Baseline ETA without TBFM delay |
| ETA at Vertex |
vATCSCC:etaVertex ⭐ |
ETA_VT |
eta_vertex |
eta_vertex |
ETA at corner post/vertex |
| STA at Vertex |
vATCSCC:staVertex ⭐ |
STA_VT |
sta_vertex |
sta_vertex |
Assigned time at vertex |
| Vertex Point |
vATCSCC:vertexPoint ⭐ |
VT_FIX |
vertex_point |
vertex_point |
Vertex fix identifier |
| Metering Source |
vATCSCC:meteringSource ⭐ |
MTR_SRC |
metering_source |
metering_source |
simtraffic/vatcscc/vnas/topsky |
| Metering Updated |
vATCSCC:meteringUpdatedTime ⭐ |
— |
metering_updated_at |
metering_updated_at |
Last metering update timestamp |
Metering Status Values
| Status |
Description |
UNMETERED |
Not yet under TBFM control |
METERED |
Active TBFM metering, sequence may change |
FROZEN |
Sequence frozen, no further changes |
SUSPENDED |
TBFM suspended (e.g., weather deviation) |
EXEMPT |
Exempt from metering (priority, emergency) |
SimTraffic Integration Flow
SimTraffic ──(POST /ingest/metering)──► SWIM ──(GET /metering/{airport})──► vNAS ──► CRC Datablock
SimTraffic provides:
sequence_number - Arrival sequence (1 = next to land)
scheduled_time_of_arrival - STA at runway threshold
metering_time - STA at meter fix
metering_delay - Minutes of assigned delay
metering_frozen - Frozen flag
arrival_stream - Corner post assignment
vNAS/CRC displays:
- Sequence number in datablock
- STA/ETA comparison (delay indicator)
- Frozen status
14. SimBrief Integration (vATCSCC Extension)
| Concept |
FIXM-like Field |
JSON API |
Current DB |
New DB |
Migration |
| OFP ID |
vATCSCC:simbriefOfpId ⭐ |
simbrief_ofp_id |
— |
simbrief_ofp_id |
➕ Add |
| SimBrief Route |
vATCSCC:simbriefRoute ⭐ |
simbrief_route |
— |
simbrief_route |
➕ Add |
| Cost Index |
vATCSCC:costIndex ⭐ |
cost_index |
— |
cost_index |
➕ Add |
| Block Fuel |
vATCSCC:blockFuel ⭐ |
block_fuel |
— |
block_fuel |
➕ Add |
| ZFW |
vATCSCC:zeroFuelWeight ⭐ |
zero_fuel_weight |
— |
zero_fuel_weight |
➕ Add |
| TOW |
vATCSCC:takeoffWeight ⭐ |
takeoff_weight |
— |
takeoff_weight |
➕ Add |
15. Data Source Timestamps (vATCSCC Extension)
| Concept |
FIXM-like Field |
JSON API |
Current DB |
New DB |
Migration |
| ADL Updated |
vATCSCC:adlUpdatedTime ⭐ |
adl_updated_at |
adl_updated_at |
adl_updated_at |
✅ OK |
| Track Updated |
vATCSCC:trackUpdatedTime ⭐ |
track_updated_at |
track_updated_at |
track_updated_at |
✅ OK |
| SimBrief Updated |
vATCSCC:simbriefUpdatedTime ⭐ |
simbrief_updated_at |
simbrief_updated_at |
simbrief_updated_at |
✅ OK |
| Created At |
recordCreationTime |
created_at |
created_at |
created_at |
✅ OK |
| Updated At |
recordUpdateTime |
updated_at |
updated_at |
updated_at |
✅ OK |
16. Migration Summary
By Action Type
| Action |
Count |
Description |
| ✅ OK (No change) |
22 |
Already compliant or acceptable |
| 🔄 Rename |
42 |
Existing columns need renaming |
| ➕ Add |
45 |
New columns to add |
17. vATCSCC Extension XSD Namespace
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:vATCSCC="http://vatcscc.org/schema/1.0"
xmlns:fx="http://www.fixm.aero/flight/4.3"
targetNamespace="http://vatcscc.org/schema/1.0"
elementFormDefault="qualified">
<!-- VATSIM Pilot Identification -->
<xs:complexType name="VatsimIdentificationType">
<xs:sequence>
<xs:element name="pilotCid" type="xs:positiveInteger"/>
<xs:element name="pilotName" type="xs:string" minOccurs="0"/>
<xs:element name="pilotRating" type="vATCSCC:PilotRatingType" minOccurs="0"/>
<xs:element name="homeArtcc" type="xs:string" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
<!-- Airport Zone Detection -->
<xs:complexType name="AirportZoneType">
<xs:sequence>
<xs:element name="currentAirportZone" type="vATCSCC:ZoneNameType" minOccurs="0"/>
<xs:element name="currentZoneAirport" type="xs:string" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
<!-- Zone Times -->
<xs:complexType name="ZoneTimesType">
<xs:sequence>
<xs:element name="parkingLeftTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="taxiwayEnteredTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="holdEnteredTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="runwayEnteredTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="rotationTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="approachStartTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="thresholdTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="touchdownTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="rolloutEndTime" type="xs:dateTime" minOccurs="0"/>
<xs:element name="parkingEnteredTime" type="xs:dateTime" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
<!-- SimBrief integration -->
<xs:complexType name="SimbriefDataType">
<xs:sequence>
<xs:element name="ofpId" type="xs:string" minOccurs="0"/>
<xs:element name="route" type="xs:string" minOccurs="0"/>
<xs:element name="costIndex" type="xs:integer" minOccurs="0"/>
<xs:element name="blockFuel" type="xs:decimal" minOccurs="0"/>
<xs:element name="zeroFuelWeight" type="xs:decimal" minOccurs="0"/>
<xs:element name="takeoffWeight" type="xs:decimal" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
<!-- Enumerations -->
<xs:simpleType name="PilotRatingType">
<xs:restriction base="xs:string">
<xs:enumeration value="NEW"/>
<xs:enumeration value="PPL"/>
<xs:enumeration value="IR"/>
<xs:enumeration value="CMEL"/>
<xs:enumeration value="ATPL"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="ZoneNameType">
<xs:restriction base="xs:string">
<xs:enumeration value="PARKING"/>
<xs:enumeration value="TAXIWAY"/>
<xs:enumeration value="HOLD"/>
<xs:enumeration value="RUNWAY"/>
<xs:enumeration value="AIRBORNE"/>
<xs:enumeration value="APPROACH"/>
<xs:enumeration value="FINAL"/>
</xs:restriction>
</xs:simpleType>
</xs:schema>
18. API Response Example (Post-Migration)
{
"gufi": "VAT-20260116-UAL123-KJFK-KLAX",
"flight_key": "UAL123-KJFK-KLAX-20260116",
"aircraft_identification": "UAL123",
"pilot_cid": 1234567,
"operator_icao": "UAL",
"operator_name": "United Airlines",
"aircraft_type": "B738",
"other_aircraft_type": "B738",
"wake_turbulence": "MEDIUM",
"weight_class": "L",
"departure_aerodrome": "KJFK",
"arrival_aerodrome": "KLAX",
"departure_airspace": "ZNY",
"arrival_airspace": "ZLA",
"route_text": "DEEZZ5 DEEZZ J60 PSB J584 BJARR ANJLL4",
"cruising_level": 35000,
"cruising_speed": 460,
"total_flight_distance": 2475.3,
"latitude": 39.8561,
"longitude": -104.6737,
"altitude": 35000,
"ground_speed": 487,
"track": 268,
"percent_complete": 45.2,
"current_airport_zone": null,
"actual_off_block_time": "2026-01-16T14:30:00Z",
"actual_time_of_departure": "2026-01-16T14:45:00Z",
"estimated_time_of_arrival": "2026-01-16T19:15:00Z",
"flight_status": "CRUISING",
"is_active": true,
"last_source": "VATSIM",
"position_time": "2026-01-16T16:45:00Z",
"updated_at": "2026-01-16T16:45:15Z"
}
11. Airport Taxi Reference Data (FAA ASPM Extension)
FIXM 4.3 does not define taxi time fields. VATSWIM extends the data model with
airport taxi-out reference times using FAA ASPM terminology and methodology.
Endpoint: GET /reference/taxi-times, GET /reference/taxi-times/{airport}
| JSON API (snake_case) |
FIXM (camelCase) |
Description |
Source |
airport_icao |
aerodromeIcao |
ICAO airport code |
airport_taxi_reference.airport_icao |
unimpeded_taxi_out_sec |
unimpededTaxiOutSeconds |
Unimpeded taxi-out time in seconds (p5-p15 avg) |
airport_taxi_reference.unimpeded_taxi_sec |
sample_count |
sampleCount |
Observation count in 90-day window |
airport_taxi_reference.sample_count |
confidence |
confidenceLevel |
Data quality: HIGH/MEDIUM/LOW/DEFAULT |
airport_taxi_reference.confidence |
percentile_5 |
percentile5 |
5th percentile taxi time (seconds) |
airport_taxi_reference.percentile_5 |
percentile_15 |
percentile15 |
15th percentile taxi time (seconds) |
airport_taxi_reference.percentile_15 |
last_refreshed_utc |
lastRefreshedTime |
Last stored procedure refresh |
airport_taxi_reference.last_refreshed_utc |
Dimensional breakdown (single-airport detail):
| JSON API |
FIXM |
Description |
dimension |
dimension |
Dimension type: WEIGHT_CLASS, CARRIER, ENGINE_CONFIG, DEST_REGION |
dimension_value |
dimensionValue |
Dimension value (e.g., "H", "UAL", "JET_TWIN") |
unimpeded_taxi_out_sec |
unimpededTaxiOutSeconds |
Dimension-specific unimpeded taxi time |
sample_count |
sampleCount |
Dimension-specific sample count |
Methodology: FAA ASPM p5-p15 average over 90-day rolling window. Airports with
fewer than 50 observations receive a default of 600 seconds (10 minutes). Data sourced
from VATSIM OOOI events (out_utc → off_utc delta). Refreshed daily at 02:00Z.
End of Field Mapping Document v1.2