| Column Name | English Name | Data Type | Length | Precision | Scale | Updated | Created | Description |
|---|---|---|---|---|---|---|---|---|
| ACESN_NBR |
ACCESSION NUMBER | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The accession number of the event. NOTE: This is a unique ASRS incident tracking number and the primary reference link for the ASIAS database. |
| EVENT_SEQ |
EVENT SEQUENCE NBR | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The event enumerator. |
| ANOMALY_ACFT_EQUP_DESC |
ANOMALY AIRCRAFT EQUIPMENT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the severity of the aircraft equipment problem. See Business Rules below for examples. |
| ANOMALY_ASP_VIOL_DESC |
ANOMALY AIRSPACE VIOLATION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates when the airspace excursion or incursion occurred. See Business Rules below for examples. |
| ANOMALY_ALT_DEV_DESC |
ANOMALY ALTITUDE DEVIATION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of altitude deviation that occurred. See Business Rules below for examples. |
| ANOMALY_CABIN_EVENT_DESC |
ANOMALY CABIN EVENT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of cabin event that occurred. See Business Rules below for examples. |
| ANOMALY_CNFLCT_DESC |
ANOMALY CONFLICT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates where the conflict occurred and it's severity. See Business Rules below for examples. |
| ANOMALY_EXCUR_DESC |
ANOMALY EXCURSION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates where an excursion occurred. See Business Rules below for examples. |
| ANOMALY_GRND_ENCTR_DESC |
ANOMALY GROUND ENCOUNTER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of ground anomoly that was encountered. See Business Rules below for examples. |
| ANOMALY_INCUR_DESC |
ANOMALY INCURSION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of incursion that occurred. See Business Rules below for examples. |
| ANOMALY_INFLT_ENCTR_DESC |
ANOMALY INFLIGHT ENCOUNTER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of inflight anomoly that was encountered. See Business Rules below for examples. |
| ANOMALY_MAINT_PRBLM_DESC |
ANOMALY MAINTENANCE PROBLEM DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of maintenance problem that was encountered. See Business Rules below for examples. |
| ANOMALY_NONADHER_DESC |
ANOMALY NONADHERENCE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of nonadherance that was encountered. See Business Rules below for examples. |
| ANOMALY_NONADHER_OTR_DESC |
ANOMALY NON ADHERENCE OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the type of nonadherance that occurred. See Business Rules below for examples. |
| ANOMALY_OTR_ANMLY_DESC |
ANOMALY OTHER ANOMALY DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates any other type of anomaly found or encountered. See Business Rules below for examples. |
| ANOMALY_OTR_SPTL_DEV_DESC |
ANOMALY OTHER SPACTIAL DEVIATION DESRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Describes the anomaly as some other spatial deviation. See Business Rules below for examples. |
| ANOMALY_MISS_DIST_HRZNTL_QTY |
ANOMALY MISS HORIZONTAL DISTANCE QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The estimated horizontal distance in feet for a reported near miss occurrence. |
| ANOMALY_MISS_DIST_UNSPEC_QTY |
ANOMALY MISS DISTANCE UNSPECIFIED | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The estimated distance in feet (unspecified direction) for a reported near miss occurrence. |
| ANOMALY_MISS_DIST_VERT_QTY |
ANOMALY MISS VERTICAL DISTANCE QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The estimated vertical distance in feet for a reported near miss occurrence. |
| ANOMALY_CONSEQ_DESC |
ANOMALY CONSEQUENCE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates what type of action was taken because of the anomoly. See Business Rules below for examples. |
| ANOMALY_CONSEQ_OTR_DESC |
ANOMALY CONSEQUENCE OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates what other consequences occurred as a result of the anomoly. See Business Rules below for examples. |
| ANOMALY_CONSEQ_OTR_OTR_DESC |
ANOMALY CONSEQUENCE OTHER OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the consequences of the ANOMALY CONSEQ OTR DESC field. See Business Rules below for examples. |
| ANOMALY_DETCTR_CTRL_A_DESC |
ANOMALY CONTROLLER A DETECTED DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates which air traffic controller was aware of the anomoly. NOTE: This field is usually numeric and refers to the PERSON SEQ number(s) (listed under the REPORTER DATA table). |
| ANOMALY_DETCTR_CTRL_B_DESC |
ANOMALY CONTROLLER B DETECTED DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates which other air traffic controller was aware of the anomoly. NOTE: This field is usually numeric and refers to the PERSON SEQ number(s) (listed under the REPORTER DATA table). |
| ANOMALY_DETCTR_CREW_A_DESC |
ANOMALY CREW A DETECTED DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates which crew member(s) of the first aircraft were aware of the anomoly. NOTE: This field is usually numeric and refers to the PERSON SEQ number(s) (listed under the REPORTER DATA table). |
| ANOMALY_DETCTR_CREW_B_DESC |
ANOMALY CREW B DETECTED DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates which crew member(s) of the second aircraft were aware of the anomoly. NOTE: This field is usually numeric and refers to the PERSON SEQ number(s) (listed under the REPORTER DATA table). |
| ANOMALY_RES_ACFT_DESC |
ANOMALY RESOLUTION AIRCRAFT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Discribes how the aircraft resolved the anomoly. See Business Rules below for examples. |
| ANOMALY_RES_CTRL_DESC |
ANOMALY RESOLUTION CONTROLLER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Describes how air traffic control resolved the anomoly. See Business Rules below for examples. |
| ANOMALY_RES_CREW_DESC |
ANOMALY RESOLUTION CREW DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Describes how the aircraft crew resolved the anomoly. See Business Rules below for examples. |
| ANOMALY_RES_ACTION_OTR_DESC |
ANOMALY RESOLUTION ACTION OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Provides further description of how the anomoly was resolved. See Business Rules below for examples. |
| ANOMALY_NO_ACTION_DESC |
ANOMALY NO ACTION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Describes why no action was taken when the anomoly was encountered. See Business Rules below for examples. |
| ANOMALY_EVENT_TYPE_DESC |
ANOMALY EVENT TYPE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates what type of event occurred. See Business Rules below for examples. |