Slide 1:
FMCSA's Annual Information Technology Workshop
Betsky Benowski
August 28-31, 2006
Louisville, Kentucky

Slide 2:
Data Quality

Slide 3:
FMCSA Data Quality Programs
Parts of the FMCSA Data Quality Improvement Program

1) DataQs 
2) Ongoing Evaluation of State Safety Data Quality 
3) Monthly Monitoring of State Data Quality
4) UMTRI Off-site Analysis of State Crash Data
5) On-site State Data Quality Reviews
6) Training - Analysis and Improvement of State PARs
7) Safety Data Improvement Funding


Slide 4: State Safety Data Quality (SSDQ) Quarterly Map
Updated Results: June 23, 2006
(Graphic showing map with State Rating colors)

Slide 5: State Safety Data Quality Map Measures
Current Measures
1) Completeness of Fatal Crash File
2) Accuracy Crash plus Inspection Carrier Match US DOT number
3) Timeliness Crash plus Inspection within 90 and 21 days
4) Overiding Indicator

Slide 6: New Measures Proposed
Additional Measures
1) Completeness of Non-Fatal Crash File
2) Two Completeness of Record Measures
  A) Driver Measure
  B) Vehicle Measure
3) Two Accuracy of Record Logic Checking Measures
  A) Hazardous Material Info Logic
  B) Vehicle Info Logic

Slide 7: Non-Fatal Crash File Completeness Measure
Evaluate Completeness of Reporting Non-Fatal Crash Records
Measure equals ratio of fatal crash records in MCMIS to non-fatal crash records in MCMIS
compared to
Expected ratio of fatal crash records to non-fatal crash records (asterisk)
Asterisk notation: See UMTRI state database analysis!
California, Florida, Illinois, Michigan, Missouri, New Mexico, New Jersey, North Carolina, Ohio, Washington, Maryland

Slide 8: New Completeness of Record Measures
The Driver Measure
1) Last and First Name
2) Date of Birth
3) License Number
4) Class
The Vehicle Measure
1) Vehicle Identification Number
2) License Plate
3) Configuration
4) Cargo Body
5) CVWR

Slide 9: New Completeness of Record Measures (continued)
The Driver Measure
- Evaluate if ALL driver identification fields are complete in the crash record
  - This measure equals the number of records with ALL driver identification fields complete divided by the total number of records

The Vehicle Measure
- Evaluate if ALL vehicle identification fields are complete in the crash record
   -This measure equals the number of records with ALL vehicle ID fields complete divided by the total number of records

Slide 10: New Accuracy of Record Logic Checking Measures
Hazardous Materials Logic Checking
- Evaluate the integrity of Hazmat info reported within a crash record
  -This measure equals the number of records with the logical hazmat information reported by the total number of records

Vehicle Logic Checking
-Evaluate the integrity of Vehicle information reported within a crash record
  -This measure equals the number of records with the logical vehicle information reported by the total number of records

Slide 11: Questions????
Contact
Betsy Benkowski
(202) 366-5387
betsy.benkowski@fmcsa.dot.gov