Importing Personnel Data for Random Selection for Drug and Alcohol Testing

DrugTestNetwork’s online application software for drug and alcohol testing data management and random selection has easy to use import features to manage the upkeep of employer personnel rosters.

One of the biggest challenges faced by TPAs is keeping employee rosters up-to-date for the random selection of personnel for drug and alcohol testing.  Importing data is an easy task with resources that read Excel spreadsheets saved as “tab delimited” text files.

Employers often have the capability to review their active personnel/employee lists in an Excel spreadsheet.  From there it’s easy to modify the spreadsheet to import the data into the Employer’s account.  The system has the capability to import far more than simply an employee’s first name, last name and employee ID whether it is a Social Security Number or other proprietary employment ID, however, this article will limit the discussion to a subset of the possible fields for import. Continue reading

Random Selection Audit for Drug & Alcohol Testing

When you generate a random selection for drug and alcohol testing, the online software application, DrugTestNetwork, a cloud based SaaS system, maintains a thorough and complete audit trail.

The original list of employees eligible for random drug and alcohol testing from which the randomization was conducted is saved as a permanent record.  If John Doe was in the list at the time the random selection was conducted, his name will appear in the audit trail record.  If John Doe is removed from the personnel roster for the company in which he was employed, his name is forever maintained in the audit record.

A safety sensitive employee who must comply with Federal DOT guidelines must have passed a pre-employment drug test prior to his or her employment and must be eligible for random drug and alcohol testing from that point forward.  Therefore, one of the most frequently asked questions regarding random selection for drug and alcohol testing is whether an employee was in the list at the time a particular randomization was generated regardless if the employee is currently in the client’s pool of personnel eligible for selection.

The random selection audit answers the questions:
Users can query a list of random selections for a client by date as shown below.  To review the list of personnel eligible for the selection, the user simply clicks the icon to review the entire list that participated in the random selection generated for a specific randomization request.

In the application the user clicks the personnel icon (seen on the right) to review the list of employees eligible for each random selection in the report.


The Random Selection Listing for a specific account for a specified period of time:random selection audit trail


DOT MIS Report

DrugTestNetwork produces the DOT MIS report with ease and has an analytical reporting tool to clarify any potential problems regarding the reporting accuracy of test results for a client.

Only Drug and Alcohol Tests for specific reasons for testing and specific overall qualitative results are counted for the DOT MIS report.  Only test results recorded with be below listed Reasons for Testing are counted:

  • Pre-Employment
  • Random Selection
  • Post Accident
  • Reasonable Suspicion
  • Reasonable Cause
  • Return to Duty
  • Follow-Up Testing

If a test result is recorded with ANY OTHER reason for testing, it is NOT counted in the reported tests for the DOT MIS Report.

Test Result Codes: Only the Overall Qualitative Test Results listed below are counted in the DOT MIS Report:

  • Negative
  • Positive
  • Cancelled
  • Shy-Bladder (No Medical Explanation)
  • Shy-Lung (Breath-Alcohol)
  • Declined to Participate (Other Refusals)

Test Results that use ANY OTHER overall qualitative test result are NOT Included in the reported test counts for the DOT MIS Report.