| 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. |
| A266 |
Cloud amount |
| A85 |
Dew point, specified in celsius |
| A127 |
Weather conditions |
| A129 |
Dang goods involved |
| A140 |
Height of cloud base, specified in feet |
| A168 |
Light conditions |
| A176 |
Maximum gust, specified in knot |
| A275 |
Speed measured at |
| A287 |
Air temperature, specified in celsius |
| A310 |
Visibility, specfied in metres |
| A320 |
Wind direction, specified in degrees |
| A321 |
Wind gusts |
| A322 |
Wind speed, specified in knot |
| A428 |
ATM contribution |
| A431 |
Occurrence class |
| A432 |
Highest damage |
| A433 |
Local date |
| A434 |
Date report created |
| A435 |
Report last modified |
| A436 |
Effect on ATM service |
| A439 |
Latitude of the place of the occurrence in degrees, minutes and seconds |
| A440 |
Location name |
| A444 |
Longitude of the place of the occurrence in degrees, minutes and seconds |
| A446 |
Occurrence moderator |
| A448 |
Damage not to a/c |
| A451 |
Injury level |
| A454 |
State/area of occ |
| A455 |
Occurrence status |
| A457 |
Local time |
| A458 |
Total fatalities |
| A459 |
Total fatalities aircraft |
| A460 |
Total fatalities ground |
| A461 |
Total involved |
| A462 |
Total on board a/c |
| A463 |
Total injuries-ground |
| A464 |
Total injuries-unknown |
| A465 |
Total injuries-unknown, aircraft |
| A466 |
Total injuries-unknown, ground |
| A467 |
Total minor injuries |
| A468 |
Total minor injuries-aircraft |
| A469 |
Total minor injuries-ground |
| A470 |
Total serious injuries |
| A471 |
Total serious injuries-aircraft |
| A472 |
Total serious injuries-ground |
| A473 |
Total no injuries |
| A474 |
Total no injuries-aircraft |
| A475 |
Total no injuries-ground |
| A477 |
UTC date of the occurrence |
| A478 |
UTC time |
| A601 |
Headline for the human reader |
| A606 |
Weather relevant |
| A621 |
Wind description |
| A672 |
Maint. report type |
| A673 |
Manufacturer inf |
| A674 |
Operator informed |
| A708 |
Notification text |
| A709 |
Date published |
| A710 |
Original language |
| A712 |
Investigation scope |
| A713 |
Investigating entity |
| A714 |
Invest. delegated |
| A795 |
Validation status |
| A798 |
Date entered |
| A803 |
Investig report ID |
| A822 |
Validation date |
| A1049 |
Applicability SES performance scheme |
| A1072 |
Detection phase |
| A1073 |
Ground severity applied? |
| A1074 |
Ground severity |
| A1075 |
Ground repeatability |
| A1076 |
Overall severity applied? |
| A1077 |
Overall severity |
| A1078 |
Overall repeatability |
| A1079 |
Tech. severity applied? |
| A1080 |
Spec./Tech. severity |
| A1081 |
Spec./Tech. repeatability |
| A1087 |
Authority occ. closure |
| A454_T |
Extension to State or area of occurrence, text |
| A672_T |
Extension to Maintenance report type, text |
| A713_T |
Extension to Type of entity investigating, text |
| A1072_T |
Extension to Detection phase, text |
| A266_1 |
Extension to The amount of cloud, part 1 |
| A127_1 |
Extension to Weather conditions, part 1 |
| A129_1 |
Extension to Dangerous goods involved, part 1 |
| A168_1 |
Extension to Light conditions, part 1 |
| A275_1 |
Extension to Wind speed measured at, part 1 |
| A321_1 |
Extension to Wind gusts, part 1 |
| A428_1 |
Extension to ATM contribution, part 1 |
| A431_1 |
Extension to Occurrence class, part 1 |
| A431_2 |
Extension to Occurrence class, part 2 |
| A432_1 |
Extension to Damage severity level, part 1 |
| A436_1 |
Extension to Effect on ATM service, part 1 |
| A448_1 |
Extension to Damage on aerodrome, part 1 |
| A451_1 |
Extension to Injury severity level, part 1 |
| A454_1 |
Extension to State or area of occurrence, part 1 |
| A454_2 |
Extension to State or area of occurrence, part 2 |
| A454_3 |
Extension to State or area of occurrence, part 3 |
| A455_1 |
Extension to Occurrence status, part 1 |
| A606_1 |
Extension to Weather relevance, part 1 |
| A621_1 |
Extension to Wind description, part 1 |
| A672_1 |
Extension to Maintenance report type, part 1 |
| A673_1 |
Extension to Manufacturer informed, part 1 |
| A674_1 |
Extension to Operator informed, part 1 |
| A710_1 |
Extension to Original language of final report, part 1 |
| A712_1 |
Extension to The scope of the investigation, part 1 |
| A713_1 |
Extension to Type of entity investigating, part 1 |
| A714_1 |
Extension to Delegation of the investigation, part 1 |
| A714_2 |
Extension to Delegation of the investigation, part 2 |
| A795_1 |
Extension to Occurrence validation status, part 1 |
| A1049_1 |
Extension to Information of the applicability of the occurrence to the SES performance scheme, part 1 |
| A1072_1 |
Extension to Detection phase, part 1 |
| A1073_1 |
Extension to RAT ATM ground severity applied? part 1 |
| A1074_1 |
Extension to RAT ATM ground severity, part 1 |
| A1075_1 |
Extension to RAT ATM ground repeatability, part 1 |
| A1076_1 |
Extension to RAT ATM overall severity applied? part 1 |
| A1077_1 |
Extension to RAT ATM overall severity, part 1 |
| A1078_1 |
Extension to RAT ATM overall repeatability, part 1 |
| A1079_1 |
Extension to RAT ATM specific/technical severity applied? part 1 |
| A1080_1 |
Extension to RAT ATM specific/technical severity, part 1 |
| A1081_1 |
Extension to RAT ATM specific/technical repeatability, part 1 |
| A708_P |
Extension to Notification text, part P |
| A1087_P |
Extension to Competent authority occurrence closure, part P |
| A266_1_Translate |
Translation of the code-value in A266_1 column. |
| A266_Translate |
Translation of the code-value in A266 column. |
| A127_1_Translate |
Translation of the code-value in A127_1 column. |
| A127_Translate |
Translation of the code-value in A127 column. |
| A129_1_Translate |
Translation of the code-value in A129_1 column. |
| A129_Translate |
Translation of the code-value in A129 column. |
| A168_1_Translate |
Translation of the code-value in A168_1 column. |
| A168_Translate |
Translation of the code-value in A168 column. |
| A275_1_Translate |
Translation of the code-value in A275_1 column. |
| A275_Translate |
Translation of the code-value in A275 column. |
| A321_1_Translate |
Translation of the code-value in A321_1 column. |
| A321_Translate |
Translation of the code-value in A321 column. |
| A428_1_Translate |
Translation of the code-value in A428_1 column. |
| A428_Translate |
Translation of the code-value in A428 column. |
| A431_1_Translate |
Translation of the code-value in A431_1 column. |
| A431_Translate |
Translation of the code-value in A431 column. |
| A432_1_Translate |
Translation of the code-value in A432_1 column. |
| A432_Translate |
Translation of the code-value in A432 column. |
| A436_1_Translate |
Translation of the code-value in A436_1 column. |
| A436_Translate |
Translation of the code-value in A436 column. |
| A448_1_Translate |
Translation of the code-value in A448_1 column. |
| A448_Translate |
Translation of the code-value in A448 column. |
| A451_1_Translate |
Translation of the code-value in A451_1 column. |
| A451_Translate |
Translation of the code-value in A451 column. |
| A454_1_Translate |
Translation of the code-value in A454_1 column. |
| A454_2_Translate |
Translation of the code-value in A454_2 column. |
| A454_Translate |
Translation of the code-value in A454 column. |
| A454_3_Translate |
Translation of the code-value in A454_3 column. |
| A455_1_Translate |
Translation of the code-value in A455_1 column. |
| A455_Translate |
Translation of the code-value in A455 column. |
| A606_1_Translate |
Translation of the code-value in A606_1 column. |
| A606_Translate |
Translation of the code-value in A606 column. |
| A621_1_Translate |
Translation of the code-value in A621_1 column. |
| A621_Translate |
Translation of the code-value in A621 column. |
| A672_1_Translate |
Translation of the code-value in A672_1 column. |
| A672_Translate |
Translation of the code-value in A672 column. |
| A673_1_Translate |
Translation of the code-value in A673_1 column. |
| A673_Translate |
Translation of the code-value in A673 column. |
| A674_1_Translate |
Translation of the code-value in A674_1 column. |
| A674_Translate |
Translation of the code-value in A674 column. |
| A710_1_Translate |
Translation of the code-value in A710_1 column. |
| A710_Translate |
Translation of the code-value in A710 column. |
| A712_1_Translate |
Translation of the code-value in A712_1 column. |
| A712_Translate |
Translation of the code-value in A712 column. |
| A713_1_Translate |
Translation of the code-value in A713_1 column. |
| A713_Translate |
Translation of the code-value in A713 column. |
| A714_1_Translate |
Translation of the code-value in A714_1 column. |
| A714_2_Translate |
Translation of the code-value in A714_2 column. |
| A714_Translate |
Translation of the code-value in A714 column. |
| A795_1_Translate |
Translation of the code-value in A795_1 column. |
| A795_Translate |
Translation of the code-value in A795 column. |
| A1049_1_Translate |
Translation of the code-value in A1049_1 column. |
| A1049_Translate |
Translation of the code-value in A1049 column. |
| A1072_1_Translate |
Translation of the code-value in A1072_1 column. |
| A1072_Translate |
Translation of the code-value in A1072 column. |
| A1073_1_Translate |
Translation of the code-value in A1073_1 column. |
| A1073_Translate |
Translation of the code-value in A1073 column. |
| A1074_1_Translate |
Translation of the code-value in A1074_1 column. |
| A1074_Translate |
Translation of the code-value in A1074 column. |
| A1075_1_Translate |
Translation of the code-value in A1075_1 column. |
| A1075_Translate |
Translation of the code-value in A1075 column. |
| A1076_1_Translate |
Translation of the code-value in A1076_1 column. |
| A1076_Translate |
Translation of the code-value in A1076 column. |
| A1077_1_Translate |
Translation of the code-value in A1077_1 column. |
| A1077_Translate |
Translation of the code-value in A1077 column. |
| A1078_1_Translate |
Translation of the code-value in A1078_1 column. |
| A1078_Translate |
Translation of the code-value in A1078 column. |
| A1079_1_Translate |
Translation of the code-value in A1079_1 column. |
| A1079_Translate |
Translation of the code-value in A1079 column. |
| A1080_1_Translate |
Translation of the code-value in A1080_1 column. |
| A1080_Translate |
Translation of the code-value in A1080 column. |
| A1081_1_Translate |
Translation of the code-value in A1081_1 column. |
| A1081_Translate |
Translation of the code-value in A1081 column. |