Bureau of Transportation Statistics (BTS)
Printable Version

MPRN NON-CG RESPONSE DATA RECORD LAYOUT

Excel | CSV

FIELD NAME FILE DESCRIPTION TYPE/LGTH
RNKEY (GROUP)    
RNCASENO MP MSIS CASE NO CHAR(10)
RNCIF1 CIF-1 SUPPL REC TYPE CHAR(1)
RNCIF2 CIF-2 NUM SUP REC CHAR(2)
MPRNGROUP (GROUP OF CHANGEABLE FIELDS)  
RNVER VERFICATION CHAR(1)
RNCLASS CLASS CHAR(1)
RNNDATE DATE NOTIFIED  
RNNDATEDD DAY NOTIFIED CHAR(2)
RNNDATEMM MONTH NOTIFIED CHAR(3)
RNNDATEYY YEAR NOTIFIED CHAR(4)
RUNTIME TIME NOTIFIED CHAR(4)
RNADM ROLE ADMINISTRATION CHAR(1)
RNREM ROLE CONTAIN REMOVAL CHAR(1)
RNINV ROLE INVESTIGATE CHAR(1)
RNSPV ROLE SUPERVISE CHAR(1)
RNMON ROLE MONITOR CHAR(1)
PIND PIRS POLLUTION INDICATOR CHAR(1)

PRIMARY KEY IS RNKEY