NASA AVIATION SAFETY REPORTING SYSTEM
RECORD LAYOUTS 
Updated March 2010

MAIN.dbf
===========
ACCNSION	CHAR		10	Accension or report number assigned by NASA
ENTITY		CHAR		30	One of 10 possible entity values that describe the type of data contained on that line. These are: aircraft, component, environment, events, factors, person, place, situations, time and supplementary.
ENUMER		CHAR		1	Only used for aircraft, component and person, if there is more than one involved. For example, if the entity is "person" and enumer=1, then the data on that line refers to the first person. Where enumer=2, the data would refer to the second reporting person.
ATTRIBUTE	CHAR		65	Further defines the data that is in the value field on that particular line. There are 239 possible attributes. See the lookup table for all the possible values. 
VALUE		CHAR		100	This is the actual data, defined by the entity, enumerator and attribute fields. 


REMARKS.dbf
============
ACCNSION	CHAR		6	Accension or report number assigned by NASA. Use this field to match up to the main table.
ATTRIBUTE	CHAR		9	Whether the information contained on this line is the narrative or synopsis.
VALUE		MEMO			Contains either the full narrative from the reporting person or the synopsis written by the NASA analyst who handled the report.


STATIC.dbf
============
ENTITY		CHAR		30	Topic Grouping (GenericAircraft.)
ATTRIBUTE	CHAR		65	Report SubGrouping (GenericAircraft -Make Model Name, Make Model Code, Number Of Engines, Weight Classification, Propulsion, Wings, Surface, Gear, Number of Engines)
VALUE		CHAR		65	VALUE of the ENTITY,ATTRIBUTE (Aircraft - Make Model Name - Boeing 747-400)
IDENTITY	CHAR		65	(Identifier for all related attributes and values.  Example rows include
			

			Example 1		Example 2		Example 3
Entity			�GenericAircraft�	�GenericAircraft�	�GenericAircraft�
Attribte		�Make Model Name�	�Make Model Code�	�Weight Classification�
Value			�B747-400� 		�148.57�		�Widebody Transport�
Identity		�148.57�		�148.57�			�148.57�