| OID |
OID (database unique ID) - numeric datatype A single column containing a database-unique identifier. It is this identifier which is actually used to link all the records in all the tables to the same Occurrence. |
| ID |
ID (Instance ID) This is the instance ID in this table. |
| A23 |
Actual altimeter setting, specified in hPa |
| A25 |
Aircraft flight level |
| A27 |
Height altimeter, specified in hPa |
| A30 |
Break-up on impact |
| A31 |
Break-up at ditching |
| A46 |
ATS route name |
| A247 |
Requested altitude, specified in feet |
| A248 |
Requested flight level |
| A249 |
Requested height, specified in feet. |
| A250 |
Roll angle specific, specified in degrees |
| A251 |
Roll attitude |
| A252 |
Rwy exit at |
| A254 |
Serial number |
| A255 |
Serious injuries-cabin crew |
| A256 |
Serious injuries-co-pilot |
| A257 |
Serious injuries crew total |
| A258 |
Serious injuries-other crew |
| A259 |
Serious injuries-passengers |
| A260 |
Serious injuries-pilot |
| A261 |
Serious other injuries on a/c |
| A265 |
Pilot advised of SIGMET |
| A53 |
Bearing rwy heading, specified in degrees |
| A58 |
Cleared altitude, specified in feet |
| A59 |
Cleared alt altimeter, specified in hPa |
| A60 |
Cleared flight level |
| A61 |
Cleared height, specified in feet |
| A62 |
Cleared height altim, specified in hPa |
| A65 |
Co-ord entry altitude, specified in feet |
| A75 |
Charts provider |
| A78 |
Crosswind component, specified in knot |
| A84 |
Descent speed, specified in feet per minute |
| A86 |
Distance threshold, specified in metre |
| A87 |
Recording duration, specified in minutes |
| A108 |
Fatal, Co-Pilot |
| A109 |
Fatal, crew total |
| A110 |
Fatal, other flight crew |
| A111 |
Fatal, passengers |
| A112 |
Fatal, pilot |
| A113 |
Other fatalities on a/c |
| A114 |
Total number fatalities" |
| A115 |
Fatal, unknown |
| A120 |
Flight number |
| A133 |
GPWS type/mark |
| A187 |
Total number minor injuries |
| A188 |
Minor injuries-unknown |
| A190 |
No injuries-cabin crew |
| A191 |
No injuries-co-pilot |
| A192 |
No injuries-crew total |
| A193 |
No injuries-other flight crew |
| A194 |
No injuries-passengers |
| A195 |
No injuries-pilot |
| A196 |
No injuries - other |
| A197 |
Total number no injuries |
| A198 |
No injuries unknown |
| A199 |
Non-fatal injuries-burns |
| A201 |
Non-fatal injuries-gasses |
| A202 |
Non-fatal injuries-impact |
| A203 |
Non-fatal injuries-shock |
| A204 |
Non-fatal injuries-other |
| A205 |
Non-fatal injuries-unknown |
| A206 |
Nr of restraint failures |
| A207 |
Nr seat failures |
| A208 |
Number of channels |
| A209 |
Number of engines |
| A210 |
Number of parameters |
| A211 |
Persons evacuated |
| A220 |
Altitude contours |
| A221 |
Provider |
| A222 |
Terrain contours |
| A223 |
Charts different |
| A224 |
Pilot altimeter type |
| A225 |
Pilot restraint system |
| A226 |
Pitch angle specific, specified in degrees |
| A227 |
Pitch attitude |
| A229 |
Wreckage position |
| A231 |
Precision appr cat |
| A232 |
Propulsion type |
| A233 |
Ext agent quantity, specified in litres |
| A234 |
Fuel volume on board, specified in litres |
| A235 |
Radio altimeter inst |
| A237 |
Reason for data loss - FDR (flight data recorder) |
| A240 |
Reason for data loss - CVR (cockpit voice recorder) |
| A241 |
Recording medium - CVR (cockpit voice recorder) |
| A242 |
Recording medium - FDR (flight data recorder) |
| A243 |
Recovery status |
| A244 |
Aircraft registration |
| A245 |
Rel wind direction |
| A246 |
Relevant segment |
| A267 |
Goggles usage |
| A268 |
Smoke hoods usage |
| A269 |
Smoke masks usage |
| A274 |
Speed level |
| A276 |
Type of airspeed |
| A278 |
SSR mode |
| A280 |
Start phase |
| A284 |
Survivability |
| A285 |
Availability |
| A286 |
Operation |
| A293 |
Turbulence intensity |
| A294 |
Turbulence type |
| A295 |
Recorder type |
| A296 |
Terrain type |
| A297 |
Flight plan type |
| A298 |
Type of landing |
| A300 |
Underwater locator: Information regarding the equippage and functioning of a underwater recorder beacon (pinger) attached to the flight data recorder |
| A301 |
Underwater locator: Information regarding the equippage and functioning of a underwater recorder beacon (pinger) attached to the cockpit voice recorder |
| A309 |
VASI used |
| A312 |
Visual approach type |
| A313 |
Wake turb. category |
| A318 |
Weather forecast |
| A319 |
Mass group |
| A323 |
Windshear |
| A324 |
W/Shear alert install |
| A635 |
Aircraft damage |
| A637 |
Schedule type |
| A638 |
Ops range |
| A646 |
Birds/wildlife seen |
| A647 |
Birds/wildlife struck |
| A648 |
Bird size |
| A676 |
Acquisition unit |
| A679 |
Combined recorder |
| A680 |
Time information |
| A692 |
Holding status |
| A804 |
Autopilot |
| A805 |
Auto throttle |
| A806 |
Gear position |
| A807 |
Spoilers position |
| A809 |
Weather radar |
| A876 |
Ash cloud visible |
| A877 |
Color of ash cloud |
| A878 |
Density of ash cloud |
| A1063 |
Vertical profile |
| A1083 |
Old attribute - Not in use or identifiable |
| A30_1 |
Extension to Break-up on impact other than an impact with water, part 1 |
| A31_1 |
Extension to Break-up at ditching, part 1 |
| A251_1 |
Extension to Roll attitude at ground impact, part 1 |
| A252_1 |
Extension to The direction in which the aircraft left the runway, part 1 |
| A265_1 |
Extension to Pilot advised of significant weather, part 1 |
| A220_1 |
Extension to Pilot-in-command charts minimum altitude contours, part 1 |
| A222_1 |
Extension to Pilot-in-command charts terrain contours, part 1 |
| A223_1 |
Extension to Charts different from pilot-in-command to co-pilot, part 1 |
| A224_1 |
Extension to Pilot-in-command altimeter type, part 1 |
| A225_1 |
Extension to Pilot-in-command restraint system, part 1 |
| A227_1 |
Extension to Pitch attitude ground impact, part 1 |
| A229_1 |
Extension to Wreckage position (graph), part 1 |
| A231_1 |
Extension to Precision approach category flown, part 1 |
| A232_1 |
Extension to Aircraft propulsion type, part 1 |
| A235_1 |
Extension to Radio altimeter provided, part 1 |
| A237_1 |
Extension to FDR - reason for data loss, part 1 |
| A240_1 |
Extension to CVR - reason for data loss, part 1 |
| A241_1 |
Extension to CVR - recording medium, part 1 |
| A242_1 |
Extension to FDR - recording medium, part 1 |
| A243_1 |
Extension to The recovery status of the aircraft, part 1 |
| A245_1 |
Extension to Relative wind direction, part 1 |
| A267_1 |
Extension to Smoke goggles usage, part 1 |
| A268_1 |
Extension to Smoke hoods usage, part 1 |
| A269_1 |
Extension to Smoke masks usage, part 1 |
| A274_1 |
Extension to Speed level at ground impact, part 1 |
| A276_1 |
Extension to Type of airspeed, part 1 |
| A278_1 |
Extension to Secondary surveillance radar mode, part 1 |
| A280_1 |
Extension to The phase of flight during which the fire/smoke/fumes started, part 1 |
| A284_1 |
Extension to Survivability in the aircraft, part 1 |
| A285_1 |
Extension to Fire warning system aircraft availability, part 1 |
| A286_1 |
Extension to Fire warning system aircraft operation, part 1 |
| A293_1 |
Extension to Turbulence intensity, part 1 |
| A294_1 |
Extension to Turbulence type, part 1 |
| A295_1 |
Extension to FDR - type, part 1 |
| A296_1 |
Extension to Terrain type where aircraft came to rest, part 1 |
| A297_1 |
Extension to Flight plan type, part 1 |
| A298_1 |
Extension to Type of landing, part 1 |
| A300_1 |
Extension to FDR - underwater locator beacon, part 1 |
| A301_1 |
Extension to CVR - underwater locator beacon, part 1 |
| A309_1 |
Extension to The type of visual approach slope indicator used, part 1 |
| A312_1 |
Extension to Visual approach type, part 1 |
| A313_1 |
Extension to Wake turbulence category, part 1 |
| A318_1 |
Extension to Weather forecast, part 1 |
| A318_2 |
Extension to Weather forecast, part 2 |
| A319_1 |
Extension to Aircraft mass group, part 1 |
| A323_1 |
Extension to Windshear intensity, part 1 |
| A324_1 |
Extension to Windshear alert installed, part 1 |
| A635_1 |
Extension to The level of damage sustained by this aircraft, part 1 |
| A637_1 |
Extension to Air Transport schedule type, part 1 |
| A638_1 |
Extension to Air Transport domestic - international, part 1 |
| A646_1 |
Extension to Number of birds/wildlife seen, part 1 |
| A647_1 |
Extension to Number of birds/wildlife struck, part 1 |
| A648_1 |
Extension to The estimated size of the bird (visual rendering based on average weight), part 1 |
| A676_1 |
Extension to FDR - acquisition unit, part 1 |
| A679_1 |
Extension to CVR - combined recorder, part 1 |
| A680_1 |
Extension to CVR - time information, part 1 |
| A692_1 |
Extension to Holding status, part 1 |
| A804_1 |
Extension to Status of the auto pilot at first event, part 1 |
| A805_1 |
Extension to Auto throttle, part 1 |
| A806_1 |
Extension to Landing gear position, part 1 |
| A807_1 |
Extension to Spoilers position, part 1 |
| A809_1 |
Extension to Weather radar, part 1 |
| A876_1 |
Extension to Ash cloud visible, part 1 |
| A877_1 |
Extension to Color of ash cloud, part 1 |
| A878_1 |
Extension to Density of ash cloud, part 1 |
| A1063_1 |
Extension to Vertical profile at the time of occurrence, part 1 |
| A1083_1 |
Old attribute - Not in use or identifiable |
| A30_1_Translate |
Translation of the code-value in A30_1 column. |
| A30_Translate |
Translation of the code-value in A30 column. |
| A31_1_Translate |
Translation of the code-value in A31_1 column. |
| A31_Translate |
Translation of the code-value in A31 column. |
| A251_1_Translate |
Translation of the code-value in A251_1 column. |
| A251_Translate |
Translation of the code-value in A251 column. |
| A252_1_Translate |
Translation of the code-value in A252_1 column. |
| A252_Translate |
Translation of the code-value in A252 column. |
| A265_1_Translate |
Translation of the code-value in A265_1 column. |
| A265_Translate |
Translation of the code-value in A265 column. |
| A220_1_Translate |
Translation of the code-value in A220_1 column. |
| A220_Translate |
Translation of the code-value in A220 column. |
| A222_1_Translate |
Translation of the code-value in A222_1 column. |
| A222_Translate |
Translation of the code-value in A222 column. |
| A223_1_Translate |
Translation of the code-value in A223_1 column. |
| A223_Translate |
Translation of the code-value in A223 column. |
| A224_1_Translate |
Translation of the code-value in A224_1 column. |
| A224_Translate |
Translation of the code-value in A224 column. |
| A225_1_Translate |
Translation of the code-value in A225_1 column. |
| A225_Translate |
Translation of the code-value in A225 column. |
| A227_1_Translate |
Translation of the code-value in A227_1 column. |
| A227_Translate |
Translation of the code-value in A227 column. |
| A229_1_Translate |
Translation of the code-value in A229_1 column. |
| A229_Translate |
Translation of the code-value in A229 column. |
| A231_1_Translate |
Translation of the code-value in A231_1 column. |
| A231_Translate |
Translation of the code-value in A231 column. |
| A232_1_Translate |
Translation of the code-value in A232_1 column. |
| A232_Translate |
Translation of the code-value in A232 column. |
| A235_1_Translate |
Translation of the code-value in A235_1 column. |
| A235_Translate |
Translation of the code-value in A235 column. |
| A237_1_Translate |
Translation of the code-value in A237_1 column. |
| A237_Translate |
Translation of the code-value in A237 column. |
| A240_1_Translate |
Translation of the code-value in A240_1 column. |
| A240_Translate |
Translation of the code-value in A240 column. |
| A241_1_Translate |
Translation of the code-value in A241_1 column. |
| A241_Translate |
Translation of the code-value in A241 column. |
| A242_1_Translate |
Translation of the code-value in A242_1 column. |
| A242_Translate |
Translation of the code-value in A242 column. |
| A243_1_Translate |
Translation of the code-value in A243_1 column. |
| A243_Translate |
Translation of the code-value in A243 column. |
| A245_1_Translate |
Translation of the code-value in A245_1 column. |
| A245_Translate |
Translation of the code-value in A245 column. |
| A267_1_Translate |
Translation of the code-value in A267_1 column. |
| A267_Translate |
Translation of the code-value in A267 column. |
| A268_1_Translate |
Translation of the code-value in A268_1 column. |
| A268_Translate |
Translation of the code-value in A268 column. |
| A269_1_Translate |
Translation of the code-value in A269_1 column. |
| A269_Translate |
Translation of the code-value in A269 column. |
| A274_1_Translate |
Translation of the code-value in A274_1 column. |
| A274_Translate |
Translation of the code-value in A274 column. |
| A276_1_Translate |
Translation of the code-value in A276_1 column. |
| A276_Translate |
Translation of the code-value in A276 column. |
| A278_1_Translate |
Translation of the code-value in A278_1 column. |
| A278_Translate |
Translation of the code-value in A278 column. |
| A280_1_Translate |
Translation of the code-value in A280_1 column. |
| A280_Translate |
Translation of the code-value in A280 column. |
| A284_1_Translate |
Translation of the code-value in A284_1 column. |
| A284_Translate |
Translation of the code-value in A284 column. |
| A285_1_Translate |
Translation of the code-value in A285_1 column. |
| A285_Translate |
Translation of the code-value in A285 column. |
| A286_1_Translate |
Translation of the code-value in A286_1 column. |
| A286_Translate |
Translation of the code-value in A286 column. |
| A293_1_Translate |
Translation of the code-value in A293_1 column. |
| A293_Translate |
Translation of the code-value in A293 column. |
| A294_1_Translate |
Translation of the code-value in A294_1 column. |
| A294_Translate |
Translation of the code-value in A294 column. |
| A295_1_Translate |
Translation of the code-value in A295_1 column. |
| A295_Translate |
Translation of the code-value in A295 column. |
| A296_1_Translate |
Translation of the code-value in A296_1 column. |
| A296_Translate |
Translation of the code-value in A296 column. |
| A297_1_Translate |
Translation of the code-value in A297_1 column. |
| A297_Translate |
Translation of the code-value in A297 column. |
| A298_1_Translate |
Translation of the code-value in A298_1 column. |
| A298_Translate |
Translation of the code-value in A298 column. |
| A300_1_Translate |
Translation of the code-value in A300_1 column. |
| A300_Translate |
Translation of the code-value in A300 column. |
| A301_1_Translate |
Translation of the code-value in A301_1 column. |
| A301_Translate |
Translation of the code-value in A301 column. |
| A309_1_Translate |
Translation of the code-value in A309_1 column. |
| A309_Translate |
Translation of the code-value in A309 column. |
| A312_1_Translate |
Translation of the code-value in A312_1 column. |
| A312_Translate |
Translation of the code-value in A312 column. |
| A313_1_Translate |
Translation of the code-value in A313_1 column. |
| A313_Translate |
Translation of the code-value in A313 column. |
| A318_1_Translate |
Translation of the code-value in A318_1 column. |
| A318_Translate |
Translation of the code-value in A318 column. |
| A318_2_Translate |
Translation of the code-value in A318_2 column. |
| A319_1_Translate |
Translation of the code-value in A319_1 column. |
| A319_2_Translate |
Translation of the code-value in A319_2 column. |
| A319_Translate |
Translation of the code-value in A319 column. |
| A323_1_Translate |
Translation of the code-value in A323_1 column. |
| A323_Translate |
Translation of the code-value in A323 column. |
| A324_1_Translate |
Translation of the code-value in A324_1 column. |
| A324_Translate |
Translation of the code-value in A324 column. |
| A635_1_Translate |
Translation of the code-value in A635_1 column. |
| A635_Translate |
Translation of the code-value in A635 column. |
| A637_1_Translate |
Translation of the code-value in A637_1 column. |
| A637_Translate |
Translation of the code-value in A637 column. |
| A638_1_Translate |
Translation of the code-value in A638_1 column. |
| A638_Translate |
Translation of the code-value in A638 column. |
| A646_1_Translate |
Translation of the code-value in A646_1 column. |
| A646_Translate |
Translation of the code-value in A646 column. |
| A647_1_Translate |
Translation of the code-value in A647_1 column. |
| A647_Translate |
Translation of the code-value in A647 column. |
| A648_1_Translate |
Translation of the code-value in A648_1 column. |
| A648_Translate |
Translation of the code-value in A648 column. |
| A676_1_Translate |
Translation of the code-value in A676_1 column. |
| A676_Translate |
Translation of the code-value in A676 column. |
| A679_1_Translate |
Translation of the code-value in A679_1 column. |
| A679_Translate |
Translation of the code-value in A679 column. |
| A680_1_Translate |
Translation of the code-value in A680_1 column. |
| A680_Translate |
Translation of the code-value in A680 column. |
| A692_1_Translate |
Translation of the code-value in A692_1 column. |
| A692_Translate |
Translation of the code-value in A692 column. |
| A804_1_Translate |
Translation of the code-value in A804_1 column. |
| A804_Translate |
Translation of the code-value in A804 column. |
| A805_1_Translate |
Translation of the code-value in A805_1 column. |
| A805_Translate |
Translation of the code-value in A805 column. |
| A806_1_Translate |
Translation of the code-value in A806_1 column. |
| A806_Translate |
Translation of the code-value in A806 column. |
| A807_1_Translate |
Translation of the code-value in A807_1 column. |
| A807_Translate |
Translation of the code-value in A807 column. |
| A809_1_Translate |
Translation of the code-value in A809_1 column. |
| A809_Translate |
Translation of the code-value in A809 column. |
| A876_1_Translate |
Translation of the code-value in A876_1 column. |
| A876_Translate |
Translation of the code-value in A876 column. |
| A877_1_Translate |
Translation of the code-value in A877_1 column. |
| A877_Translate |
Translation of the code-value in A877 column. |
| A878_1_Translate |
Translation of the code-value in A878_1 column. |
| A878_Translate |
Translation of the code-value in A878 column. |
| A1063_1_Translate |
Translation of the code-value in A1063_1 column. |
| A1063_Translate |
Translation of the code-value in A1063 column. |