RECALLS.DBF Updated June 2005 The Recall file contains all NHTSA safety-related defect and compliance campaigns since 1967. FIELDNAME TYPE/LENGTH DESCRIPTION REC_ID NUMBER(9) RUNNING SEQUENCE NUMBER,WHICH UNIQUELY IDENTIFIES THE RECORD CAMPNO CHAR(12) NHTSA CAMPAIGN NUMBER MAKETXT CHAR(25) VEHICLE/EQUIPMENT MAKE MODELTXT CHAR(25) VEHICLE/EQUIPMENT MODEL YEARTXT CHAR(4) MODEL YEAR, 1900 IF UNKNOWN MFGCAMPNO CHAR(20) MFR CAMPAIGN NUMBER COMPNAME MEMO COMPONENT DESCRIPTION MFGTXT CHAR(40) MANUFACATURER'S INVOLVED IN THE RECALL BGMAN CHAR(8) BEGIN DATE OF MANUFACTURING BG_MAN DATE(8) NICAR-created field, converted to date format ENDMAN CHAR(8) END DATE OF MANUFACTURING. END_MAN DATE(8) NICAR-created field, converted to date format RCLTYPECD CHAR(4) VEHICLE, EQUIPMENT OR TIRE REPORT V=vehicle recall campaign E=equipment vehicle recall campaign T=tire vehicle recall campaign I=vehicle safety improvement campaign C=Child restraint system vehicle recall campaign X= equipment/tire improvement campaign NOTE: improvement campaigns are not recalls NOTE: I and X are no longer used POTAFF NUMBER(9) POTENTIAL NUMBER OF UNITS AFFECTED. ODATE CHAR(8) DATE OWNER NOTIFIED BY MFR. O_DATE DATE(8) NICAR-created field, converted to date format INFL CHAR(4) RECALL INITIATOR MFG/OVSC/ODI MFG= manufacturer OVSC= Office of Vehicle Safety Compliance ODI= Office of Defect Investigation MFGNAME CHAR(40) MANUFACTURER RESPONSIBLE FOR RECALL RCDATE CHAR(8) DATE REPORT RECEIVED BY ODI. RC_DATE DATE(8) NICAR-created field, converted to date format DATEA CHAR(8) DATE ADDED TO FILE. DATE_A DATE(8) NICAR-created field, converted to date format RPNO CHAR(3) REGULATION PART NUMBER FMVSS CHAR(3) FEDERAL MOTOR VEHICLE SAFETY STANDARD NUMBER. DESCDFCT MEMO DEFECT SUMMARY CON_DFCT MEMO CONSEQUENCE SUMMARY CORR_ACT MEMO CORRECTIVE SUMMARY