Schedule

CVSA Data Management, Quality and FMCSA Systems Workshop

January 28-31, 2019
San Antonio, Texas

    Monday, August 7, 2017
  • Event Registration and Member Services

    2:00 PM—5:00 PM
    at Orlando Ballroom Foyer, Convention Level
  • Tuesday, August 8, 2017
  • Networking Breakfast

    7:00 AM—8:30 AM
    at
  • Event Registration and Member Services

    7:00 AM—5:00 PM
    at Orlando Ballroom Foyer, Convention Level
  • General Session

    8:30 AM—10:00 AM
    at Orlando Ballroom N, Convention Level
    Moderator: Holly Skaar, Chair, Information Systems Committee
    CVSA Executive Director's Remarks Collin Mooney, Executive Director, CVSA
    Federal Motor Carrier Safety Administration Welcome Remarks Jack Van Steenburg, Assistant Administrator and Chief Safety Officer, FMCSA Joel Hiatt, Acting Chief Information Officer, FMCSA
    Workshop Overview and Instructor Introductions Scott Valentine, Data Quality Program Manager, Analysis Division, FMCSA
    FMCSA Crash Data Update Scott Valentine, Data Quality Program Manager, Analysis Division, FMCSA
  • Workshop Breakouts

    10:30 AM—12:00 PM
    at
    TRACK 1 SAFETYNET: Aspen 3.1 Enhancements Orlando Ballroom M, Convention Level Aspen is the software that FMCSA created to help federal and state enforcement personnel conduct roadside inspections. Learn about recent Aspen enhancements and ask questions about the software. Through presentations and demonstrations, participants will learn about:
    • Recent changes related to violations, SmartLogic and other features
    • Upcoming releases
    TRACK 2 State Safety Data Quality (SSDQ) Measures: How to Understand Current Measures and Upcoming Changes Orlando Ballroom L, Convention Level The SSDQ measures are central to FMCSA’s Data Quality Program. These performance measures let states know the quality of the data they upload to FMCSA. Review the SSDQ measures and upcoming changes, and talk about the SSDQ criteria and FMCSA expectations. Using technical demonstrations and hands-on SSDQ exercises, participants will learn:
    • How the SSDQ methodologies work
    • What planned changes are to methodologies, including changing "Event Date" to "Upload Date," new crash VIN measures, changes to the inspection and crash completeness measures and a new indicator that shows states their ratings
    • Why the SSDQ criteria is set where it is and what those expectations mean for states
  • Lunch

    12:00 PM—1:30 PM
    at
  • Workshop Breakouts

    1:30 PM—3:00 PM
    at
    TRACK 1 SAFETYNET: How to Improve Accuracy in Inspections and Crashes Orlando Ballroom M, Convention Level Understand the important link between reporting the correct carrier and safety. Learn about State Safety Data Quality (SSDQ) inspection accuracy and crash accuracy measures, and how to use the carrier match tool in SAFETYNET to report the correct carrier. Time will be available for participants to share their ideas for how to research carrier data. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How and why to record the correct carrier type (for crash)
    • What the comprehensive steps are for completing the carrier search, including the pros and cons of individual and in-batch options
    • How to research data to fill in blank or incorrect carrier fields
    • Why census updates to data quality are important
    • How to complete census updates
    TRACK 2 DataQs Topics - Inspection Adjudicated Citations Case Studies I Orlando Ballroom L, Convention Level FMCSA's DataQs system is used by motor carriers and drivers to request a review of crash and inspection data issues. This session will cover introductory and basic-level definitions and DataQs examples, and review examples of requests submitted in the Inspection-Citation with Associated Violation category. Using case studies and group discussion, participants will learn how to:
    • Apply the policy, definitions and manual guidance to specific cases
    • Review supporting documentation regarding the court adjudication
    • Make a final determination on how to record the court adjudicated outcome
  • Workshop Breakouts

    3:30 PM—5:00 PM
    at
    TRACK 1 SAFETYNET: How to Improve Completeness in Inspections and Crashes Orlando Ballroom M, Convention Level Understand how complete driver and vehicle data supports FMCSA safety programs. Learn about SSDQ inspection record completeness, crash record completeness and inspection Vehicle Identification Number (VIN) accuracy measures. Time will be available for participants to share ideas for how to research driver and vehicle data. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How to search for incomplete fields using simple queries and reports
    • How to research the data (e.g., driver’s license number, incomplete VINs, cargo body type) to fill in blank or incomplete fields
    TRACK 2 DataQs Topic: Inspection Adjudicated Citations Case Studies II Orlando Ballroom L, Convention Level This session will cover advanced-level DataQs examples and review examples of requests submitted in the Inspection-Citation with Associated Violation category. Using case studies and group discussion, participants will build upon the previous session and learn how to:
    • Correctly discern differences in conviction of original charge, conviction of a different charge and not guilty/dismissed
    • Handle multiple violations on a single citation or multiple citations
  • 2017 NAIC Sponsor Recognition, Volunteer Appreciation and Patch Exchange Reception

    7:00 PM—9:00 PM
    at Upper Pool Deck, Recreation Level
  • Wednesday, August 9, 2017
  • Networking Breakfast

    7:00 AM—8:30 AM
    at
  • Event Registration and Member Services

    7:00 AM—5:00 PM
    at Orlando Ballroom Foyer, Convention Level
  • Workshop Breakouts

    8:30 AM—10:00 AM
    at
    TRACK 1 SAFETYNET: How to Write Basic Queries for Inspections and Crashes Orlando Ballroom M, Convention Level Learn how simple queries can save you time responding to data requests and how to proactively find compromised data in your SAFETYNET database that can be corrected before reporting it to FMCSA. Participants will write basic queries in SAFETYNET through technical instruction and hands-on exercises. This session will cover the basics of query writing with the goal of giving novices confidence to write easy queries that they can build on over time. Time will be available for participants to share ideas for queries or ask how to write queries specific to their jobs. Using technical instruction and hands-on SAFETYNET exercises, participants will learn how to:
    • Access and navigate the query function
    • Write basic query language
    • Write simple queries to complete routine tasks (e.g., counting records, responding to inspector activity requests or responding to requests to support new state legislation) more efficiently
    • Use fields that are available for queries, including what questions can and cannot be answered
    • Navigate pitfalls and limitations
    TRACK 2 Motor Carrier Management Information System (MCMIS) Overview Orlando Ballroom L, Convention Level MCMIS is FMCSA’s central repository containing information related to company registrations (census), crashes, inspections, investigations and enforcement actions. Through presentation and demonstration, participants will learn:
    • How to find information about specific motor carriers
    • How to find inspections and crash records
    • What reports are available to support data collection
  • Networking Refreshment Break

    10:00 AM—10:30 AM
    at
  • Workshop Breakouts

    10:30 AM—12:00 PM
    at
    TRACK 1 SAFETYNET: How to Write Advanced Queries for Inspections and Crashes Orlando Ballroom M, Convention Level In addition to processing inspection and crash reports for FMCSA, SAFETYNET is also considered states’ commercial motor vehicle activity database. Learn how advanced queries can help you understand your state’s safety activity, using, for example, your locally defined fields. Time will be available for an open discussion for participants to share advanced query ideas. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How to access and navigate the query function
    • How to write advanced queries, including grouping, date ranges, multiple layered queries and wildcards
    • How to save, export and print queries
    • What the best practices are for how and when to use queries in the daily routine
    • What fields are available for queries, including what questions can and cannot be answered
    • How to navigate pitfalls and limitations
    TRACK 2 FMCSA Portal - Organization Coordinators Orlando Ballroom L, Convention Level The FMCSA Portal is the focal point for how most of FMCSA’s systems are accessed. This session is for students to be able to request roles and access, and navigate through the portal. Experienced organization coordinators (OCs) are also encouraged to attend for refresher training. Through presentation and demonstration, participants will learn:
    • How to create accounts and request access to FMCSA systems
    • How to navigate FMCSA’s connected systems
    • How to manage users’ accounts
    • The answers to questions on account management
  • Lunch

    12:00 PM—1:30 PM
    at
  • Workshop Breakouts

    1:30 PM—3:00 PM
    at
    TRACK 1 SAFETYNET: How to Understand Inspection and Crash Reports Orlando Ballroom M, Convention Level Learn about the reports that can help management understand your data. The reports have been developed over the years from states’ data requests; they reflect your needs. The session provides time for states to share their favorite reports with one another. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How and why to run a report
    • How to use the SAFETYNET report module interface
    • What types of reports are available
    • How to run a query, use the results in a report and export the results to Excel
    TRACK 2 Analysis & Information (A&I) Online Orlando Ballroom L, Convention Level FMCSA’s A&I Online website houses a variety of resources that can be used to improve your data or understand your state's program activities. The session allows participants to become familiar with the information available through demonstrations and hands-on practice. The session provides time for States to share how they use A&I Online. Using technical demonstration and hands-on A&I Online exercises, participants will learn:
    • How to navigate A&I Online
    • What information is available and how to use specific areas such as DIR, SMS and Gotham
  • Networking Refreshment Break

    3:00 PM—3:30 PM
    at
  • Workshop Breakouts

    3:30 PM—5:00 PM
    at
    TRACK 1 SAFETYNET: How to Run and Use Inspection and Crash Data Quality Reports Orlando Ballroom M, Convention Level Learn about the SAFETYNET data quality reports that identify issues with crash and inspection data before uploading to MCMIS. Run these two reports instead of writing and running separate queries to find data issues. Time will be available for participants to share how they use SAFETYNET reports. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How reports can help identify problems (e.g., duplicates or VIN issues) with inspection and crash data before it is uploaded to MCMIS
    • How SSDQ measures can be improved by making discreet changes to the SAFETYNET data before upload to MCMIS
    • How to locate the download instructions on FMCSA’s information systems
    • How and when to run reports
    • How to interpret report results
    TRACK 2 DataQs: Requests or Appeals Processes (Panel Discussion) Orlando Ballroom L, Convention Level This session will have short presentations by several states who will each share some aspect of their DataQs process. This session is intended to let states talk about DataQs issues they encounter and will include the chance for attendees to share comments and ask questions.  
  • Thursday, August 10, 2017
  • Event Registration and Member Services

    7:00 AM—5:00 PM
    at Orlando Ballroom Foyer, Convention Level
  • Networking Breakfast

    7:00 AM—8:30 AM
    at Orlando Ballroom Foyer, Convention Level
  • Workshop Breakouts

    8:30 AM—10:00 AM
    at Orlando Ballroom Foyer, Convention Level
    TRACK 1 SAFETYNET: How to Configure for Improved Efficiency and Data Quality Orlando Ballroom M, Convention Level Even if you are not a SAFETYNET administrator, understanding configuration options and features can help complete tasks efficiently and improve your data. To supplement discussion and help states apply what they’ve learned, participants will be able to take home a list of configuration ideas states can share with their SAFETYNET administrators. Using technical instruction and hands-on SAFETYNET exercises, participants will learn how:
    • The SAFETYNET configuration options help with daily routines and data quality
    • To navigate the interface
    • To configure a variety of changes, including entering different components of locally defined fields for state-specific activity, mapping state violations and exporting the configurations to Aspen
    TRACK 2 DataQs Topics: Crash, Not Reportable Case Studies I Orlando L Ballroom, Convention Level This session will review examples of requests submitted in the Crash-Not Reportable category, and cover introductory and basic-level issues. FMCSA’s DataQs system is used by motor carriers and drivers to request a review of crash and inspection data issues. Using case studies and group discussion, participants will:
    • Identify vehicles that qualify and do not qualify
    • Learn the criteria for the vehicles and crash
    • Apply the qualifications and criteria to DataQs cases
  • Networking Refreshment Break

    10:00 AM—10:30 AM
    at Orlando Ballroom Foyer, Convention Level
  • Workshop Breakouts

    10:30 AM—12:00 PM
    at
    TRACK 1 SAFETYNET Inspection Capstone: How to Handle Daily Processing of Inspection Records Orlando Ballroom M, Convention Level Experience the daily SAFETYNET practices of your peers. Understand the important steps that take place in order to process and upload quality inspection data. Exercises bring together inspection processing steps and research resources introduced throughout previous SAFETYNET sessions. The session provides time for states to share best practices with one another. Using technical demonstration and hands-on SAFETYNET exercises, participants learn:
    • What daily steps are to import/input inspections into SAFETYNET, the variety of resources to identify problems with the data and how to research the data
    • What FMCSA, state and other resources are available to research data
    • How to develop and practice skills learned in previous SAFETYNET sessions
    TRACK 2 DataQs Topics: Crash, Not Reportable Case Studies II Orlando Ballroom L, Convention Level This session will review examples of requests submitted in the Crash-Not Reportable category and cover more in-depth issues. Using case studies and group discussion, participants will learn how to:
    • Qualify non-collision incidents (overturns, fires, etc.)
    • Qualify non-contact vehicles
    • Determine disabling versus functional or mechanical issues
  • Lunch On Your Own

    12:00 PM—1:30 PM
    at
  • Workshop Breakouts

    1:30 PM—3:00 PM
    at
    TRACK 1 SAFETYNET Crash Capstone: How to Handle Daily Process of Crash Records Orlando Ballroom M, Convention Level Experience the daily SAFETYNET practices of your peers. Understand the important steps that take place in order to process and upload quality crash data. Exercises bring together crash processing steps and research resources introduced throughout previous SAFETYNET sessions. The session provides time for states to share best practices with one another. Using technical demonstration and hands-on SAFETYNET exercises, participants will learn:
    • What daily steps are to import/input crashes into SAFETYNET, the variety of resources to identify problems with the data, and how to research the data
    • What FMCSA, state and other resources are available to research data
    • How to develop and practice skills learned in previous SAFETYNET sessions
    TRACK 2 Inspections: Third Party Procedures Orlando Ballroom L, Convention Level FMCSA published procedures for how states may begin using third-party or homegrown inspection software packages. Through presentation and discussion, participants will learn:
    • What the process is for a new inspection software package
    • How updates are validated between the state and FMCSA
    • What resources are available for learning about updates
  • Networking Refreshment Break

    3:00 PM—3:30 PM
    at Orlando Ballroom Foyer, Convention Level
  • Closing Session: Workshop Wrap-up and Open Forum

    3:30 PM—5:00 PM
    at Orlando Ballroom N, Convention Level
    Moderators: Holly Skaar, Chair, Information Systems Committee;
    Scott Valentine, Data Quality Program Manager, Analysis Division, FMCSA;
    Joel Hiatt, Acting Chief Information Officer, FMCSA
    • Review and address topics brought up during the workshop
    • Discuss what you want to see in future FMCSA systems
    • Discuss how FMCSA how can better serve your state
    • Ask questions of FMCSA and CVSA during an open forum
    • Share what you liked or didn't like about the workshop