FAA_ENFORCEMENT DATABASE
ACTIONS TABLE LAYOUT
Updated Oct. 2008
(See codesheet for more information)

FIELD		DESCRIPTION				TYPE-LGTH		CODETABLE
							
ID		Report number assigned by 
		the originating office			CHAR 	12		None

FINA_CODE	Code Identifying Last Legal
			Action Taken			CHAR  	2		LCA

FINA_DESC	Last Legal Action Text			CHAR	30		LCA

FINA_SANC	Code Identifying Last
			Sanction Imposed		CHAR	2		SAN

FINA_SDESC	Text of last sanction			CHAR	30		SAN

FINA_AMT	Last Sanction Imposed in
			Days or Dollars			NUM	8		None

FINA_CERT	Code identifying type of certificate
			affected by action taken	CHAR	2		CRT
			(i.e. scheduled air carrier, 
			private pilot, airframe 
			mechanic, etc.)