# Presentation: 365390

## State Data Quality Review Program

- Improving the Quality of State Crash and Inspection Data Uploaded to MCMIS

## Select state
Preanalysis 
On-site visit
Post Visit
Document data reporting processes, observations and recommendations
State selects which recommendations to pursue
FMCSA technical assistance is available

- Select state
- Preanalysis
- On-site visit
- Post Visit
- Document data reporting processes, observations and recommendations
- State selects which recommendations to pursue
- FMCSA technical assistance is available

## Select a state
Preanalysis 
On-site visit
Post Visit
Document data reporting processes, observations and recommendations
State selects which recommendations to pursue
FMCSA technical assistance is available

- Select a state
- Preanalysis
- On-site visit
- Post Visit
- Document data reporting processes, observations and recommendations
- State selects which recommendations to pursue
- FMCSA technical assistance is available

## How do we decide where to go?

## State Safety Data Quality (SSDQ) Results

Contribution to the Nation’s data quality performance

State’s willingness to participate 

**State Selection Methodology**

- State Safety Data Quality (SSDQ) Results
- Contribution to the Nation’s data quality performance
- State’s willingness to participate

## SSDQ Results:  June 2006

- 5%

- Crash Accuracy

- Crash Timeliness

- 13%

- 18%

- 13%

- 5%

- 9%

## Select state
Preanalysis 
On-site visit
Post Visit
Document data reporting processes, observations and recommendations
State selects which recommendations to pursue
FMCSA technical assistance is available

- Select state
- Preanalysis
- On-site visit
- Post Visit
- Document data reporting processes, observations and recommendations
- State selects which recommendations to pursue
- FMCSA technical assistance is available

## SSDQ results (A&I On-Line)
Crash statistics (A&I On-Line)
Ad hoc MCMIS reports
Crash form analysis

- SSDQ results (A&I On-Line)
- Crash statistics (A&I On-Line)
- Ad hoc MCMIS reports
- Crash form analysis

## Select state
Preanalysis 
On-site visit
Post Visit
Document data reporting processes, observations and recommendations
State selects which recommendations to pursue
FMCSA technical assistance is available

- Select state
- Preanalysis
- On-site visit
- Post Visit
- Document data reporting processes, observations and recommendations
- State selects which recommendations to pursue
- FMCSA technical assistance is available

## Federal team
HQ representation (when possible)
MCMIS crash and inspection data
Crash form
Collection & reporting process
SafetyNet use
State managers and support staff
Crash and inspection data
Collection, reporting, training

**Who Participates in an ****On-Site Visit?**

- Federal team
- HQ representation (when possible)
- MCMIS crash and inspection data
- Crash form
- Collection & reporting process
- SafetyNet use
- State managers and support staff
- Crash and inspection data
- Collection, reporting, training

## Talk to managers
Talk to support staff
Use as series of questions to guide the group     through the discussions
Define collection and reporting process
Identify bottlenecks and practices resulting in compromised data quality
Last day Federal team provides draft list of observations

**What Happens****During an On-Site Visit?**

- Talk to managers
- Talk to support staff
- Use as series of questions to guide the group     through the discussions
- Define collection and reporting process
- Identify bottlenecks and practices resulting in compromised data quality
- Last day Federal team provides draft list of observations

## On-Site Visit:  Covers Entire Crash Process

- Crash
- Event

- Input to
- State
- System

- Upload/
- Input
- To SNET

- Upload to
- MCMIS

- Data
- Collected

## Observation:  Crash Collection Process Compromises Data Accuracy

- Complete
- Crash
- Form

- Input to
- State
- System

- Upload/
- Input
- To SNET

- Upload to
- MCMIS

- Data
- Collected

## No distinction between interstate and intrastate trucks on crash form

Crash reports sent to the State with common errors (USDOT#, GVWR, cargo body types)

Prior versions of the crash form used

- No distinction between interstate and intrastate trucks on crash form
- Crash reports sent to the State with common errors (USDOT#, GVWR, cargo body types)
- Prior versions of the crash form used

## Observation:  Crash Reporting Process Compromises Data Accuracy

- Complete
- Crash
- Form

- Input to
- State
- System

- Upload/
- Input
- To SNET

- Upload to
- MCMIS

- Data
- Collected

## Missing data filled-in with incorrect information

Conversion of State data elements to SafetyNet elements

- Missing data filled-in with incorrect information
- Conversion of State data elements to SafetyNet elements

## Observation:  Some Practices and Procedures at the MCSAP Office Compromise Data Quality

- Complete
- Crash
- Form

- Input to
- State
- System

- Upload/
- Input
- To SNET

- Upload to
- MCMIS

- Data
- Collected

## SafetyNet carrier match process not being used before sending data to MCMIS

Infrequent census updates to SafetyNet

MCSAP office uploads from SafetyNet to MCMIS occurring infrequently

- SafetyNet carrier match process not being used before sending data to MCMIS
- Infrequent census updates to SafetyNet
- MCSAP office uploads from SafetyNet to MCMIS occurring infrequently

## Observation:  Not all FMCSA Reportable Crashes are Uploaded to MCMIS

- Complete
- Crash
- Form

- Input to
- State
- System

- Upload/
- Input
- To SNET

- Upload to
- MCMIS

- Data
- Collected

## State and FMCSA CMV definitions do not match

Officers trained to identify FMCSA reportable crashes according to State’s definition. 

State’s definition used to extract FMCSA reportable crashes from State’s database.  

- State and FMCSA CMV definitions do not match
- Officers trained to identify FMCSA reportable crashes according to State’s definition.
- State’s definition used to extract FMCSA reportable crashes from State’s database.

## Select state
Preanalysis 
On-site visit
After the on-site visit
Document data process flows, observations and recommendations
State selects which recommendations to pursue
FMCSA technical assistance is available

- Select state
- Preanalysis
- On-site visit
- After the on-site visit
- Document data process flows, observations and recommendations
- State selects which recommendations to pursue
- FMCSA technical assistance is available

## After the On-Site Visit:  Document  Crash Process Flow

## State decides which recommendations to pursue

FMCSA Technical Assistance is Available
Crash form design to capture FMCSA data elements
Officer training for crash form completion
SafetyNet training

**After the On-Site Visit:  The State is in Control**

- State decides which recommendations to pursue
- FMCSA Technical Assistance is Available
- Crash form design to capture FMCSA data elements
- Officer training for crash form completion
- SafetyNet training

## Opportunity for the state to give feedback to FMCSA

Improve SafetyNet and MCMIS activity log formats
SafetyNet training course needed for new user

- Opportunity for the state to give feedback to FMCSA
- Improve SafetyNet and MCMIS activity log formats
- SafetyNet training course needed for new user

## For more information, please contact:Betsy BenkowskiFMCSA, Analysis Division202-366-5387Beth DeysherUSDOT, Volpe Center617-494-2570