Refer to the below for a list of field names and their corresponding description in the Emissions Schedules table.
Field Name |
Name in Database |
Type |
Description |
Scheduled Flight Leg PK
|
SCHEDULED_FLIGHT_LEG_PK |
VARCHAR (16777216) |
Unique combination of the FLIGHT_DESIGNATOR, FLIGHT_NUMBER, SERVICE_SUFFIX, SEQUENCE_NUMBER, PERIOD_OF_OPERATION_START_DATE, PERIOD_OF_OPERATION_END_DATE, DAYS_OF_OPERATION, OUTBOUND_CODE, STOPS, RELEASE_SELL_DATE |
Carrier Code
|
CARRIER_CODE |
VARCHAR (16777216) |
This field contains a carrier designator code assigned by either: · IATA (International Air Transport Association) · ICAO (International Civil Aviation Organization) · OAG (Controlled duplicate designators) |
Outbound Code |
OUTBOUND_CODE |
VARCHAR (16777216) |
An in-house OAG code to differentiate between duplicate codes issued by IATA to Passenger and Cargo carriers, (e.g. 7C) |
Service Suffix |
SERVICE_SUFFIX |
VARCHAR (16777216) |
A code assigned by the administrating carrier for operational purposes.
|
Flight Number
|
FLIGHT_NUMBER |
VARCHAR (16777216) |
The four digit flight number of the leg. |
Departure Airport |
DEPARTURE_AIRPORT |
VARCHAR (16777216) |
The departure port code as assigned by IATA e.g. JFK.
|
Arrival Airport |
ARRIVAL_AIRPORT |
VARCHAR (16777216) |
The arrival port code as assigned by IATA e.g. LAX.
|
Schedule Departure Date |
SCHEDULED_DEPARTURE_DATE |
VARCHAR (16777216) |
The schedule departure date that the operation departs in YYYY-MM-DD |
Aircraft Type
|
AIRCRAFT_TYPE |
VARCHAR (16777216) |
IATA 3-character designator for the aircraft/equipment type code. E.g. CR1
|
Seats |
SEATS |
NUMBER(38,0) |
Available seats for the operation. The value is taken from information from the operating carrier where applicable. Where specific seats data by carrier is not available the value is calculated using a proprietary data model. |
Estimated Fuel Burn Taxi Out Tonnes |
ESTIMATED_FUEL_BURN_TAXI_OUT_TONNES |
FLOAT |
An estimation in of the amount of fuel consumed in tonnes when the aircraft is taxing out to the runway from the terminal |
Estimated Fuel Burn Takeoff Tonnes |
ESTIMATED_FUEL_BURN_TAKEOFF_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is taking off from the runway |
Estimated Fuel Burn Climb Out Tonnes |
ESTIMATED_FUEL_BURN_CLIMBOUT_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is climbing to cruising altitude after take-off |
Estimated Fuel Burn Cruise Tonnes |
ESTIMATED_FUEL_BURN_CRUISE_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is at cruising altitude after climbing out |
Estimated Fuel Burn Approach Tonnes |
ESTIMATED_FUEL_BURN_APPROACH_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is dropping from cruising altitude to landing |
Estimated Fuel Burn Taxi in Tonnes
|
ESTIMATED_FUEL_BURN_TAXI_IN_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is taxing from the runway to the terminal |
Estimated Fuel Burn Total Tonnes |
ESTIMATED_FUEL_BURN_TOTAL_TONNES |
FLOAT
|
The total estimated fuel consumed in tonnes during the flight operation |
Estimated CO2 Taxi Out Tonnes |
ESTIMATED_CO2_TAXI_OUT_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing out to the runway from the terminal |
Estimated CO2 Take Off Tonnes |
ESTIMATED_CO2_TAKEOFF_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taking off from the runway |
Estimated CO2 Climb Out Tonnes |
ESTIMATED_CO2_CLIMBOUT_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is climbing to cruising altitude after take-off |
Estimated CO2 Cruise Tonnes |
ESTIMATED_CO2_CRUISE_TONNE |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is at cruising altitude after climbing out |
Estimated CO2 Approach Tonnes |
ESTIMATED_CO2_APPROACH_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is dropping from cruising altitude to landing |
Estimated CO2 Taxi in Tonnes |
ESTIMATED_CO2_TAXI_IN_TONNE |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing in from the runway to the terminal |
Estimated CO2 Total Tonnes |
ESTIMATED_CO2_TOTAL_TONNES |
FLOAT |
The total estimated CO2 emitted in tonnes during the flight operation
|
Missing Reference Flight Times |
MISSING_REFERENCE_FLIGHT_TIMES |
BOOLEAN |
Indicates when the flight instance is missing the historic flight times on this route needed for the fuel burn consumption and CO2 emission calculation. |