| acid |
varchar |
|
| airline |
varchar |
|
| arr_arpt |
varchar |
Arrival airport |
| cdm_part |
boolean |
CDM Participant |
| country_airspace |
varchar |
|
| dep_arpt |
varchar |
Departure airport |
| flight_acc_dep_rwys_values |
varchar |
Flight Acceptable Departure Runways |
| flight_acft_description_registration |
varchar |
Aircraft Registration |
| flight_arr_intent_to_hold_in_move |
boolean |
Arrival intent to hold in movement area |
| flight_arr_intent_to_hold_non_move |
boolean |
Arrival intent to hold in non-movement area |
| flight_arr_nas_aerodrome_icao_code |
varchar |
Arrival airport ICAO code |
| flight_arr_nas_aerodrome_unlisted_name |
varchar |
Arrival airport unlisted airport name |
| flight_arr_nas_rwy_time_airline_actual |
timestamp without time zone |
Actual Landing Time |
| flight_arr_nas_rwy_time_airline_actual_source |
varchar |
Source of Actual Landing Time |
| flight_arr_nas_stand_time_actual |
timestamp without time zone |
Actual In Block Time |
| flight_arr_nas_stand_time_actual_source |
varchar |
Source of Actual In Block Time |
| flight_arr_stand_assignment |
varchar |
Arrival stand |
| flight_arr_stand_available |
boolean |
|
| flight_dep_intent_to_hold_in_move |
boolean |
Departure intent to hold in movement area |
| flight_dep_intent_to_hold_non_move |
boolean |
Departure intent to hold in non-movement area |
| flight_dep_nas_aerodrome_icao_code |
varchar |
Departure airport ICAO code |
| flight_dep_nas_aerodrome_unlisted_name |
varchar |
Departure airport unlisted airport name |
| flight_dep_nas_earliest_off_block_time |
timestamp without time zone |
Earliest off block time (note, this is not currently used by TFMS to store EOBT) |
| flight_dep_nas_rwy_time_airline_actual |
timestamp without time zone |
Actual takeoff time |
| flight_dep_nas_rwy_time_airline_actual_source |
varchar |
Actual takeoff time source |
| flight_dep_nas_rwy_time_earliest |
timestamp without time zone |
Earliest off block time |
| flight_dep_nas_rwy_time_earliest_source |
varchar |
Earliest off block time source |
| flight_dep_nas_rwy_time_original |
timestamp without time zone |
Initial gate time of departure |
| flight_dep_nas_rwy_time_original_source |
varchar |
Initial gate time of departure source |
| flight_dep_nas_stand_time_actual |
timestamp without time zone |
Actual off block time |
| flight_dep_nas_stand_time_actual_source |
varchar |
Actual off block time source |
| flight_dep_nas_stand_time_initial |
timestamp without time zone |
Initial departure stand time (note, this is not currently used by TFMS to store IOBT or IGTD) |
| flight_dep_nas_stand_time_initial_source |
varchar |
Initial departure stand time source |
| flight_dep_nas_stand_time_target |
timestamp without time zone |
Target departure stand time |
| flight_dep_nas_stand_time_target_source |
varchar |
Target departure stand time source |
| flight_dep_nas_target_m_a_entry_time |
timestamp without time zone |
Target movement area entry time |
| flight_dep_readiness |
boolean |
Departure readiness |
| flight_dep_stand_assignment |
varchar |
Departure stand assignment |
| flight_flight_ident_acid |
varchar |
ACID |
| flight_flight_ident_major_carrier |
varchar |
Major carrier |
| flight_flight_type |
varchar |
|
| flight_initial_gate_time_dep |
timestamp without time zone |
The initial gate time of departure |
| flight_intent_return_to_gate |
boolean |
|
| flight_intent_to_be_deiced |
boolean |
|
| flight_intented_arr_spot |
varchar |
|
| flight_intented_deice_location |
varchar |
|
| flight_intented_dep_spot |
varchar |
|
| flight_ref |
varchar |
TFMS flight reference ID |
| flight_target_take_off_time |
timestamp without time zone |
|
| flight_tmat_marked_for_sub |
boolean |
TMAT marked for substitution |
| flight_tmat_relinquish |
boolean |
|
| flight_unacc_dep_rwys_values |
varchar |
Unacceptable departure runways |
| msg_type |
varchar |
Message type (FLTC = cancel, FLTU = update) |
| sens_reason |
varchar |
Sensitivity reason |
| sensitivity |
varchar |
Sensitivity |
| source |
varchar |
|
| source_facility |
varchar |
|
| source_time_stamp |
timestamp without time zone |
|
| xmit_time |
timestamp without time zone |
Message transmission time |