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 |