| 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. |
| PERSON_SEQ |
PERSON SEQUENCE | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | A consecutive number identifying each person involved in the event. |
| RPRTR_FUNCT_CTLR_DESC |
REPORTER FUNCTION CONTROLLER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the position or activity of the reporting air traffic controller at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_FLT_ATTNDNT_DESC |
REPORTER FUNCTION FLIGHT ATTENDANT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the position or activity of the reporting flight attendant at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_FLT_CREW_DESC |
REPORTER FUNCTION FLIGHT CREW DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the position or activity of the reporting flight crew member at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_INSTRCTR_DESC |
REPORTER FUNCTION INSTRUCTOR DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's flight instruction duties at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_MAINT_DESC |
REPORTER FIUNCTION MAINTENANCE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's maintenance duties at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_OBSVR_DESC |
REPORTER FUNCTION OBSERVER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's observer duties at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_OTR_PRSNL_DESC |
REPORTER FUNCTION OTHER PERSONNEL DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's function as other personnel at the time of the event. See Business Rules below for examples. |
| RPRTR_FUNCT_OVRSGT_DESC |
REPORTER FUNCTION OVERSIGHT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's oversight duties at the time of the event. See Business Rules for examples. |
| RPRTR_ACTVTY_DESC |
REPORTER ACTIVITY DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the reporter's activity at the time of the event. See Business Rules for examples. |