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 |