Bureau of Transportation Statistics (BTS)
Printable Version

MV PENALTY DATA RECORD LAYOUT

Excel | CSV

FIELD NAME FIELD DESCRIPTION TYPE/LGTH
MVKEY (GROUP)    
MPCASENO MP MSIS CASE NO CHAR(10)
MVSKEY (GROUP LINKER)  
MVCIF1 CIF-2 SUPPL REC TYPE CHAR(1)
MVCIF2 CIF-3 NUM SUP REC CHAR(2)
MVCIF3 CIF-4 NUM-PEN-MAT-RESP CHAR(2)
MVGROUP (GROUP OF CHANGEABLE FIELDS)  
MVCN MV CASE NUMBER CHAR(10)
*CFRUSC (VIOLATION CITATION) CHAR(20)
STATPEN STATUTORY PENALTY CHAR(6)
PENASSES PENALTY ASSESSED CHAR(6)
PENPAID PENALTY PAID CHAR(6)
RESSTAT RESOLUTION STATUS CHAR(3)
VCDATE DATE CLOSED  
VCDATEDD DAY CHAR(2)
VCDATEMM MONTH CHAR(3)
VCDDATEYY Year CHAR(4)
PIND PIRS POLLUTION INDICATOR CHAR(1)

PRIMARY KEY IS MVKEY