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