| 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_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. |
| EVENT_LCL_TIME |
EVENT LOCAL TIME | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The local time quarter when the event occurred. See Business Rules below for valid field values. |
| EVENT_DAY_NAME |
EVENT DAY NAME | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The day of the week that the event occurred. |
| LOC_REF_ATC_FAC_CODE |
LOCATION REFERENCE ATC FACILITY CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The identifier code for the air traffic control (ATC) facility involved in the event. See Business Rules below for description and examples. |
| 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 in the BRIEF REPORT TBL for standardized codes. |
| ACFT_RELTV_POS_ANGLE_RDL_QTY |
AIRCRAFT RELATIVE POSITION ANGLE RADIAL QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The magnetic bearing of the aircraft in degrees from the nearest airport, navigational aid, or other fix. |
| ACFT_RELTV_DSTC_QTY |
AIRCRAFT RELATIVE DISTANCE QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The distance in nautical miles (nm) from the nearest airport, navigational aid, or other fix. |
| ALT_AGL_LOW_FT_QTY |
ALTITUDE AGL LOW FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The above ground level (AGL) altitude in feet of the aircraft at the time of the event (low end of range). |
| ALT_AGL_HI_FT_QTY |
ALTITUDE AGL HI FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The above ground level (AGL) altitude in feet of the aircraft at the time of the event (high end of range). |
| ALT_MSL_LOW_FT_QTY |
ALTITUDE MSL LOW FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The mean sea level (MSL) altitude in feet of the aircraft at the time of the event (low end of range). |
| ALT_MSL_HI_FT_QTY |
ALTITUDE MSL HI FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The mean sea level (MSL) altitude in feet of the aircraft at the time of the event (high end of range). |
| WX_LGT_COND_DESC |
WEATHER LIGHT CONDITION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The light conditions at the time of the event. See Business Rules below for examples. |
| WX_FLT_COND_DESC |
WEATHER FLIGHT CONDITION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The flight conditions at the time of the event. See Business Rules below for examples and code descriptions. |
| WX_CELNG_FT_QTY |
WEATHER CEILING FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The visual ceiling above ground level (AGL) in feet. |
| RWY_VIS_LOW_FT_QTY |
RUNWAY VISIBILITY LOW FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The runway visual range (RVR) visibility in feet (low end of range). |
| RWY_VIS_HI_FT_QTY |
RUNWAY VISIBILITY HI FEET QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The runway visual range (RVR) visibility in feet (high end of range). |
| WX_VIS_LOW_SM_QTY |
WEATHER VISIBILITY LOW STATUE MILES QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The visibility in statute miles (sm) at the time of the event (low end of range). |
| WX_VIS_HI_SM_QTY |
WEATHER VISIBILITY HI STATUE MILES QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The visibility in statute miles (sm) at the time of the event (high end of range). |
| INCDNT_ATC_DESC |
INCIDENT ATC DESCRIPTION | VARCHAR2 | 100 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Supplementary information indicating whether further processes were taken against the pilot(s) and/or air traffic control personnel in the form of an operational error/deviation, pilot deviation, etc. See Business Rules below for examples. NOTE: This |
| SYNOPSIS |
ASRS SYNOPSIS | VARCHAR2 | 4000 | 0 | 0 | 24-JAN-02 | 24-JAN-02 | A synopsis of the NARRATIVE field. NOTE: This field is free-form text. |
| NARRATIVE |
ASRS NARRATIVE DESCRIPTION | VARCHAR2 | 4000 | 0 | 0 | 24-JAN-02 | 24-JAN-02 | The original reporter narrative about the event. NOTE: This field is free-form text. |
| KEYWORD |
ASRS KEYWORD | VARCHAR2 | 4000 | 0 | 0 | 24-JAN-02 | 24-JAN-02 | The ASRS analysts' analysis of the event. NOTE: This field is free-form text. |
| DOCUMENT |
ASRS DOCUMENT | VARCHAR2 | 4000 | 0 | 0 | 24-JAN-02 | 24-JAN-02 | CLOB FIELD |