| 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. |
| ACFT_SEQ |
AIRCRAFT SEQUENCE | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The number that identifies the sequence of each aircraft in the event (i.e., 1 = first aircraft, 2 = second aircraft, etc.). |
| EVENT_DATE |
EVENT DATE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The year and month the event occurred. See Business Rules below for format. |
| LOC_STATE_REF_CODE |
LOCATION STATE REFERENCE CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The code for the state nearest the event. See Business Rules below for the U.S. code standards and Foreign codes and descriptions. |
| LOC_REF_ARPT_CODE |
LOCATION REFERENCE AIRPORT CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The identifier code for the airport involved in (or closest to) the event. See Business Rules below for description and examples. NOTE: This field is not standardized; use the AIRPORT CODE STD field for standardized codes. |
| FLT_OPN_TYPE_COMMON_CARR_DESC |
FLIGHT OPERATIONS TYPE COMMON CARRIER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of commercial operation being conducted at the time of the event. See Business Rules below for examples. |
| AIRPORT_CODE_STD |
ASIAS STANDARD AIRPORT CODE | VARCHAR2 | 16 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The standardized code for the airport associated with the event location. See Business Rules below for examples. |
| AIRPORT_NAME_STD |
ASIAS STANDARD AIRPORT NAME | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The standardized name for the airport associated with the event location. NOTE: The ASIAS standard airport name is taken directly from the National Flight Data Center (NFDC) Landing Facilities guide. |