| adapt_info_tra |
varchar |
TRACON Name Group |
| adapt_info_trn |
varchar |
TRACON Name |
| aircraft_information_air_type |
varchar |
Aircraft type |
| aircraft_information_tma_id |
varchar |
TMA ID |
| airport_accept_rate_aar_type |
varchar |
Airport Acceptance Rate - airport acceptance rate type |
| airport_accept_rate_apt |
varchar |
Airport Acceptance Rate - arrival airport name |
| airport_accept_rate_rat |
integer |
Airport Acceptance Rate - airport acceptance rate |
| airport_accept_rate_tim |
timestamp |
Airport Acceptance Rate - airport acceptance rate change time |
| airport_accept_rate_tra |
varchar |
Airport Acceptance Rate - TRACON name |
| arr_airport_config_aac_type |
varchar |
Arrival Airport Configuration - arrival airport configuration type |
| arr_airport_config_apt |
varchar |
Arrival Airport Configuration - arrival airport name |
| arr_airport_config_cfg |
varchar |
Arrival Airport Configuration - configuration name |
| arr_airport_config_tim |
timestamp |
Arrival Airport Configuration - configuration change time |
| arr_airport_config_tra |
varchar |
Arrival Airport Configuration - TRACON Name |
| eta_eta_dfx |
timestamp |
Estimated Time of Arrival at display fix |
| eta_eta_mfx |
timestamp |
Estimated Time of Arrival at meter fix |
| eta_eta_o3_a |
timestamp |
Estimated Time of Arrival at outer third arc |
| eta_eta_o4_a |
timestamp |
Estimated Time of Arrival at outer fourth arc |
| eta_eta_oma |
timestamp |
Estimated Time of Arrival at outer meter arc |
| eta_eta_ooa |
timestamp |
Estimated Time of Arrival at outer outer arc |
| eta_eta_rwy |
timestamp |
Estimated Time of Arrival at runway |
| eta_eta_sfx |
timestamp |
Estimated Time of Arrival at scheduling fix |
| eta_mfx |
varchar |
Meter fix name |
| flight_plan_a10 |
varchar |
Flight Plan - field 10A route |
| flight_plan_acs |
varchar |
Flight Plan - aircraft status |
| flight_plan_aid |
varchar |
Flight Plan - aircraft ID |
| flight_plan_aot |
timestamp |
Flight Plan - actual OFF time |
| flight_plan_apt |
varchar |
Flight Plan - destination airport name |
| flight_plan_ara |
varchar |
Flight Plan - assigned requested altitude |
| flight_plan_b10 |
varchar |
Flight Plan - field 10B route |
| flight_plan_bcn |
integer |
Flight Plan - beacon code |
| flight_plan_c10 |
varchar |
Flight Plan - field 10C route |
| flight_plan_cfx |
varchar |
Flight Plan - coordination fix name |
| flight_plan_ctm |
timestamp |
Flight Plan - coordination time |
| flight_plan_dap |
varchar |
Flight Plan - departure airport/fix name |
| flight_plan_drw |
varchar |
Flight Plan - departure runway name |
| flight_plan_eng |
varchar |
Flight Plan - engine type |
| flight_plan_est |
varchar |
Flight Plan - EDCT status |
| flight_plan_etd |
timestamp |
Flight Plan - estimated departure time |
| flight_plan_etm |
timestamp |
Flight Plan - EDCT time |
| flight_plan_fps |
varchar |
Flight Plan - flight plan status |
| flight_plan_ina |
varchar |
Flight Plan - interim altitude |
| flight_plan_old |
varchar |
Flight Plan - aircraft identification before amendment |
| flight_plan_pcot |
timestamp |
Flight Plan - predicted coordinated OFF time |
| flight_plan_sfs |
integer |
Flight Plan - SMS flight status |
| flight_plan_spd |
varchar |
Flight Plan - filed speed |
| flight_plan_srs |
varchar |
Flight Plan - SMS request status |
| flight_plan_std |
timestamp |
Flight Plan - scheduled departure time |
| flight_plan_tcr |
varchar |
Flight Plan - TMA converted route |
| flight_plan_tds |
varchar |
Flight Plan - current track data source |
| flight_plan_trw |
varchar |
Flight Plan - TRACON Runway Name |
| flight_plan_typ |
varchar |
Flight Plan - aircraft type |
| flight_plan_ucot |
timestamp |
Undelayed coordinated OFF time |
| gate_accept_rate_apt |
varchar |
Gate Acceptance Rate - arrival airport name |
| gate_accept_rate_gar_type |
varchar |
Gate Acceptance Rate - gate acceptance rate type |
| gate_accept_rate_gat |
varchar |
Gate Acceptance Rate - gate name |
| gate_accept_rate_rat |
integer |
Gate Acceptance Rate - gate acceptance rate |
| gate_accept_rate_tim |
timestamp |
Gate Acceptance Rate - gate acceptance change time |
| gate_accept_rate_tra |
varchar |
Gate Acceptance Rate - TRACON name |
| id |
uuid |
Global unique ID |
| interface_status_group_ifm |
varchar |
TMA Interface Status - interface metering status |
| interface_status_group_ifn |
varchar |
TMA Interface Status - interface name |
| interface_status_group_ifs |
varchar |
TMA Interface Status - interface status |
| interface_status_group_ift |
varchar |
TMA Interface Status - interface type |
| meter_accept_rate_apt |
varchar |
Meter Point Acceptance Rate - arrival airport name |
| meter_accept_rate_mar_type |
varchar |
Meter Point Acceptance Rate - meter point acceptance rate change type |
| meter_accept_rate_mfx |
varchar |
Meter Point Acceptance Rate - meter fix name |
| meter_accept_rate_rat |
integer |
Meter Point Acceptance Rate - meter point acceptance rate |
| meter_accept_rate_tim |
timestamp |
Meter Point Acceptance Rate - meter point acceptance rate change time |
| meter_accept_rate_tra |
varchar |
Meter Point Acceptance Rate - TRACON name |
| meter_ref_cat |
varchar |
Meter Reference Point Assignments - category |
| meter_ref_cfg |
varchar |
Meter Reference Point Assignments - configuration name |
| meter_ref_dfx |
varchar |
Meter Reference Point Assignments - display fix name |
| meter_ref_gat |
varchar |
Meter Reference Point Assignments - gate name |
| meter_ref_mfx |
varchar |
Meter Reference Point Assignments - meter fix name |
| meter_ref_o3_a |
varchar |
Meter Reference Point Assignments - outer third arc name |
| meter_ref_o4_a |
varchar |
Meter Reference Point Assignments - outer fourth arc name |
| meter_ref_oma |
varchar |
Meter Reference Point Assignments - outer meter arc name |
| meter_ref_ooa |
varchar |
Meter Reference Point Assignments - outer outer arc name |
| meter_ref_rwy |
varchar |
Meter Reference Point Assignments - arrival runway name |
| meter_ref_scn |
varchar |
Meter Reference Point Assignments - stream class name |
| meter_ref_sfx |
varchar |
Meter Reference Point Assignments - scheduling fix name |
| meter_ref_tus |
varchar |
Meter Reference Point Assignments - TRACON name |
| meter_status_group_tra |
varchar |
TMA Metering Status - TRACON name |
| msg_id |
integer |
TMA unique identifier |
| msg_time |
timestamp |
Message creation time |
| runway_accept_rate_apt |
varchar |
Runway Acceptance Rate - arrival airport name |
| runway_accept_rate_rar_type |
varchar |
Runway Acceptance Rate - runway acceptance rate type |
| runway_accept_rate_rat |
integer |
Runway Acceptance Rate - runway acceptance rate |
| runway_accept_rate_rwy |
varchar |
Runway Acceptance Rate - arrival runway name |
| runway_accept_rate_tim |
timestamp |
Runway Acceptance Rate - runway acceptance rate change time |
| runway_accept_rate_tra |
varchar |
Runway Acceptance Rate - TRACON name |
| scheduling_info_man |
boolean |
Scheduling Information - manually scheduled |
| scheduling_info_mfx |
varchar |
Scheduling Information - meter fix name |
| scheduling_info_rfz |
boolean |
Scheduling Information - runway frozen |
| scheduling_info_sfz |
boolean |
Scheduling Information - scheduling frozen |
| scheduling_info_sus |
boolean |
Scheduling Information - scheduling suspended |
| sta_mfx |
varchar |
Scheduled Time of Arrivals - meter fix |
| sta_sta03_a |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at outer third arc |
| sta_sta04_a |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at outer fourth arc |
| sta_sta_dfx |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at display fix |
| sta_sta_oma |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at outer meter arc |
| sta_sta_ooa |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at outer outer arc |
| sta_sta_rwy |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at runway |
| sta_sta_sfx |
timestamp |
Scheduled Time of Arrivals - scheduled time of arrival at scheduling fix |
| track_als |
varchar |
Tracking Information - altitude status |
| track_alt |
real |
Tracking Information - altitude |
| track_gsp |
real |
Tracking Information - ground speed |
| track_hdg |
real |
Tracking Information - heading |
| track_lat |
varchar |
Tracking Information - latitude |
| track_lon |
varchar |
Tracking Information - longitude |
| track_rca |
boolean |
Tracking Information - reached cruise altitude |
| track_tkc |
boolean |
Tracking Information - track coasting |
| track_ttm |
timestamp |
Tracking Information - track time |
| track_tus |
varchar |
Tracking Information - turn status |
| track_vsp |
real |
Tracking Information - vertical speed |
| tracon_accept_rate_rat |
integer |
TRACON Acceptance Rate - TRACON acceptance rate |
| tracon_accept_rate_tar_type |
varchar |
TRACON Acceptance Rate - TRACON acceptrance rate type |
| tracon_accept_rate_tim |
timestamp |
TRACON Acceptance Rate - TRACON acceptrance change time |
| tracon_accept_rate_tra |
varchar |
TRACON Acceptance Rate - TRACON name |