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 / random selection participant lists.

It’s a big challenge for TPAs to keep employee rosters up-to-date for the random selection of participants for drug and alcohol testing.  Importing data is an easy task with resources to read “tab-delimited” text files saved from Excel spreadsheets.

Employers will often provide their active personnel/employee lists in an Excel spreadsheet.  It’s easy to save the spreadsheet as “tab-delimited text” for the import into the Employer’s account.  The system has the capability to import far more than the 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 just a few of the available keywords for import. Continue reading →