Schedule

CVSA Data Management, Quality and FMCSA Systems Training

January 29-31, 2019 San Antonio, Texas
    Monday, January 28, 2019
  • Event Registration and Member Services

    2:00 PM—5:00 PM
    at Regency Foyer, Ballroom Level
  • Tuesday, January 29, 2019
  • Event Registration and Member Services

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

    7:00 AM—8:30 AM
    at Regency Foyer, Ballroom Level
  • General Session

    8:30 AM—9:30 AM
    at Regency Ballroom West, Ballroom 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
    Training Overview and Instructor Introductions
    FMCSA Crash Data Update

  • Networking Refreshment Break

    9:30 AM—10:00 AM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    10:00 AM—12:00 PM
    at
    TRACK 1 SAFETYNET: How to Configure SAFETYNET for Improved Efficiency and Improved Data Quality Bowie Room, Losoya Conference Center Even if you are not a SAFETYNET Administrator, understanding configuration options and features can help complete tasks efficiently and make your data better. To supplement discussion and help participants apply what they've learned, participants will be able to take home a list of configuration ideas that can be shared 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
    • How to navigate the interface
    • How to configure a variety of changes, including entering different components of locally defined fields for State-specific activity (pages versus fields), mapping State violations, and exporting the configurations to Aspen
    TRACK 2 State Safety Data Quality (SSDQ) Measures: How to Understand the SSDQ Measures Navarro Room, Losoya Conference Center 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 the new data visualization features on the FMCSA Data Quality website, and talk about the SSDQ criteria and FMCSA expectations. Using technical demonstration and hands-on SSDQ exercises, participants will learn:
    •  How the SSDQ methodology works
    • What are the changes to the methodology, including changing the selection criteria from "Event Date" to "Upload Date," adding the new Crash VIN measure, changing the Crash Completeness Measure, and adding a new indicator that shows States the direction their ratings are trending (or forecasting?)
    • How to use the new data visualization tool to dig deeper into the data underlying the SSDQ measures
     
  • Lunch On Your Own

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

    1:30 PM—3:30 PM
    at
    TRACK 1 SAFETYNET Systems to Research and Improve Data Bowie Room, Losoya Conference CenterLearn about the several FMCSA and non-FMCSA systems available to research data and improve data quality. Participants become familiar with which systems to navigate to support their research efforts. Techniques learned in this session will be reinforced throughout other SAFETYNET sessions. Used in combination with the SSDQ measures, participants will return to their States armed with powerful tools to improve the data that supports State and FMCSA safety programs. Using technical demonstrations and hands-on exercises, participants learn:
    • How to navigate the systems
    • When to use one system over another
    • What information is available from each system
    TRACK 2 DataQs Inspections: Adjudicated Citations Topics Navarro Room, Losoya Conference CenterThe FMCSA's DataQs system is used by motor carriers and drivers to request a review of crash and inspection data issues. This session will review examples of requests submitted in the Inspection Adjudicated Citation. Using case studies and group discussion, participants will learn:
    • A review of the basic and finer points of the Adjudicated Citations Policy
    • How to apply the Adjudicated outcomes
    • How to apply definitions like costs, fines or fees to the outcomes
    • How to evaluate plea agreements
    • How to handle multiple violations on a single citation
     
  • Networking Refreshment Break

    3:30 PM—4:00 PM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    4:00 PM—5:30 PM
    at Orlando Ballroom Foyer, Convention Level
    TRACK 1 SAFETYNET: How to Write Basic Queries for Inspections and Crashes Bowie Room, Losoya Conference Center 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 very basics of query writing with the intent to give novices confidence to write easy queries that they can build on over time. Time will be available for participants to share their 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
    • How to write basic query language
    • How to 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
    • How to use fields that are available for queries, including what questions can and cannot be answered
    • How to navigate pitfalls and limitations
    TRACK 2 Inspections: Third-Party Procedures Navarro Room, Losoya Conference CenterFMCSA has published procedures for how States begin using third party or homegrown inspection software packages. Through presentation and discussion, participants will learn:
    • What is the process for a new inspection software package
    • How updates are validated between the State and FMCSA
    • What resources are available for learning about updates
     
  • Wednesday, January 30, 2019
  • Event Registration and Member Services

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

    7:00 AM—8:00 AM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    8:00 AM—9:30 AM
    at
    TRACK 1 SAFETYNET: How to Write Advanced Queries for Inspections and Crashes Bowie Room, Losoya Conference CenterLearn 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 very basics of query writing with the intent to give novices confidence to write easy queries that they can build on over time. Time will be available for participants to share their 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
    • How to write basic query language
    • How to 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
    • How to use fields that are available for queries, including what questions can and cannot be answered
    • How to navigate pitfalls and limitations
    TRACK 2 FMCSA Cybersecurity and Privacy Compliance Topics Navarro Room, Losoya Conference CenterThe FMCSA's DataQs system contains crash and inspection data issues. Based on the data this information is subject to protections with confidentiality, integrity and availability. This session will review best practices and compliance requirements to protect data that could potentially cause harm if compromised. Provide personnel that access, and transmit Personally Identifiable Information / Sensitive Personal Information (PII/SPII) data with the knowledge of safeguards that must be in place. This session will cover introductory and more in-depth issues. Using federal requirements, best practices and group discussion, participants will learn:
    • Laws and Policies in place that support FMCSA’s compliance requirements to protect data
    • Types of information that need protection – PII/SPII
    • Best Practices and methods to ensure the confidentiality, integrity and availability of PII/SPII data is appropriately safeguarded
    • A review of potential outcomes when data is compromised due to the lack of safeguards
    • How to report a compromise or suspected compromise
     
  • Networking Refreshment Break

    9:30 AM—10:00 AM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    10:00 AM—11:30 AM
    at
    TRACK 1 SAFETYNET: How to Run and Use the Inspection and Crash Data Quality Tool Bowie Room, Losoya Conference CenterLearn about the SAFETYNET Data Quality reports that identify issues with crash and inspection data before uploading to the Motor Carrier Management Information System (MCMIS). Run these two reports instead of writing and running separate queries to find data issues. Time will be available for an open discussion 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 installation instructions
    • How and when to run reports
    • How to interpret report results
    TRACK 2 DataQs Crash Topics Navarro Room, Losoya Conference Center The FMCSA's DataQs system ls used by motor carriers and drivers to request a review of crash and inspection data issues. This session will review examples of requests submitted in the Crash-Not Reportable category. This session will cover introductory and more in-depth issues. Using case studies and group discussion, participants will learn:
    • A review of the criteria for the vehicles and accident severity
    • How to identify vehicles that qualify and do not qualify
    • How to qualify non-collision accidents (overturns, fires, etc.)
    • How to qualify non-contact vehicles
    • How to determine disabling vs functional or mechanical issues
     
  • Lunch on Your Own

    11:30 AM—1:00 PM
    at
  • Workshop Breakouts

    1:00 PM—2:30 PM
    at
    TRACK 1 SAFETYNET: How to Understand Inspection and Crash Reports Bowie Room, Losoya Conference Center Learn about the reports that can help answer management's questions or 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 are the types of reports available
    • How to run a query, use the results in a report, and export the results to Excel
    TRACK 2 State Panel: Exploring Crash Process Issues and Solutions Navarro Room, Losoya Conference Center During this session, a few States will share their challenges and/or solutions to issues to improve their state crash processes. States experience a variety of challenges as they work to collect and report crash and inspection data to the FMCSA. These challenges often arise from process or system issues over which they have little control. States will learn from one another and be given examples of how their peers successfully navigated and solved common problems. Through a facilitated discussion, participants will learn:
    • How their peers addressed issues arising from multiple software vendors
    • How their peers addressed issues arising from reporting needs
    • How their peers addressed issues arising from the crash process
     
  • Networking Refreshment Break

    2:30 PM—3:00 PM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    3:00 PM—4:30 PM
    at
    TRACK 1 SAFETYNET: Tips and TricksBowie Room, Losoya Conference Center Learn about SAFETYNET tips and tricks that could improve your efficiency and data quality by adopting them and including them in your daily process. This collection of procedures has been gathered from experienced SAFETYNET operators and administrators. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How to run carrier search on partial carrier information
    • How to automate queries
    • How to assign shipper violations to a shipper
    • How to check for an interrupted download
    • How to re-upload previously uploaded records
    TRACK 2 Analysis & Information (A&I) Online Navarro Room, Losoya Conference Center The FMCSA's A&I Online website houses a variety of resources that can be used to improve your data or understand your State 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 the A&I Online website
    • What information is available and how to use specific areas such as DIR and SMS
     
  • Thursday, January 31, 2019
  • Event Registration and Member Services

    7:00 AM—4:30 PM
    at Regency Foyer, Ballroom Level
  • Networking Breakfast

    7:00 AM—8:00 AM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    8:00 AM—9:30 AM
    at
    TRACK 1 SAFETYNET: How to Improve Accuracy in Inspections and Crashes Bowie Room, Losoya Conference Center Understand the important link between reporting the correct carrier and safety. Learn about the 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 are the comprehensive steps for completing the carrier search, including the pros and cons of individual and in-batch options
    • How to use the A&I Non-Match reports to improve data quality
    • Why census updates are important to data quality
    • How to complete census updates.
    TRACK 2 FMCSA Portal Navarro Room, Losoya Conference Center The FMCSA Portal is the focal point for how most of FMCSA's systems are accessed. This session is geared for participants to be able to request roles and access, and to navigate through the Portal. 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 to FMCSA's connected systems
    • For Organization Coordinators, how to manage their users' accounts
    • For Organization Coordinators, get answers to questions on account management

  • Networking Refreshment Break

    9:30 AM—10:00 AM
    at Regency Foyer, Ballroom Level
  • Workshop Breakouts

    10:00 AM—11:30 AM
    at
    TRACK 1 SAFETYNET: How to Improve Completeness in Inspections and Crashes Bowie Room, Losoya Conference Center Understand how complete driver and vehicle data supports FMCSA safety programs, such as the identification of chameleon carriers. Learn about the SSDQ Inspection Record Completeness, the enhanced Crash Record Completeness, the Inspection Vehicle Identification Number (VIN) Accuracy, and the new Crash Vehicle VIN Accuracy measures. Time will be available for participants to share their ideas for how to research driver and vehicle data. Using technical instruction and hands-on SAFETYNET exercises, participants will learn:
    • How to identify incomplete records
    • How to research the data (e.g., Driver's license#, incomplete VINs, cargo body type) to fill in blank or incomplete fields
    TRACK 2 Motor Carrier Management Information System (MCMIS) Overview Navarro Room, Losoya Conference Center The Motor Carrier Management Information System (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

  • Lunch on Your Own

    11:30 AM—1:00 PM
    at
  • Workshop Breakouts

    1:00 PM—2:30 PM
    at
    TRACK 1 SAFETYNET: Comprehensive Crash and Inspection Processing Exercise Bowie Room, Losoya Conference Center Apply many of the tools and practices you learned over the course of the training during this session. Solve common issues faced by SAFETYNET analysts, discuss best practices, and work with your peers to process and improve data from a three-vehicle crash case study. Through a comprehensive crash reporting exercise, participants will be asked to work in groups to:
    • Consider reportable crash data
    • Process two crash records and one inspection record using SAFETYNET, DIR, and other researching tools
    • Discuss best practices and office protocol for completing standard SAFETYNET operations
    TRACK 2 Aspen Enhancements and Configuration Navarro Room, Losoya Conference Center Aspen is the software that FMCSA has created to assist Federal and State enforcement personnel conduct roadside inspections. This session is geared for State personnel to learn about recent enhancements, how to optimally configure Aspen, and to ask questions about the software. Through presentation and demonstration, participants will learn:
    • Recent changes and features
    • Configuration options
    • Upcoming releases

  • Closing Session: Workshop Wrap-up and Open Forum

    3:00 PM—4:30 PM
    at Regency Ballroom West, Ballroom Level