Support (323) 793-1535 software@randomware.com
RandomWare: Random Selection & Data Management Software for Drug & Alcohol Testing
MIS DOT Reports: RandomWare Basic

RandomWare Basic & Plus Software Systems for Random Drug & Alcohol Testing generate audit reports as required by the US Department of Transportation (DOT). The reports are referred to as MIS Reports.

The MIS DOT reports require close attention to personnel Mode & Category specifications.  Every personnel record and every drug & alcohol record must have a Mode & Category specified. 

Every time a random selection is generated, a duplicate personnel roster is created.  These duplicate rosters are used to determine the average size of the personnel roster according to the DOT's rules and regulations that determine the numbers reported.  Each personnel record in these duplicate lists must also be managed so the Mode & Category for every record is properly specified.

For DOT reporting purposes, everyone in a personnel roster must be specified by the same Mode.  Some RandomWare applications use the Mode/Category for other purposes other than DOT requirements.  This flexibility prevents a "global" Mode applied to the entire personnel roster.

  • Open your Results for a Client
  • Click the menu Other Data > MIS: Modes/Categories
  • Find FHWA and change it to FMCSA
  • Save.
  • Double Click FMCSA
  • Change one of the Categories to DRIVER (use the space bar to overwrite any trailing characters) 
  • Save & Exit. 
  • Exit MIS Window.
  • Open the Client's Personnel roster.
  • If mode/category columns not displayed, click the Views menu and choose Mode/Category. 
  • Click into a Mode cell and click the dropdown to display the Mode Manager. 
  • Choose FMCSA / Driver 
  • Click the button at the top of the little dialog box "Apply to all records" (acknowledge "Yes" when prompted). 
  • Save & Exit personnel roster. 
  • Open your Results for a Client.
  • If mode/category columns not displayed, click Views menu and choose Mode/Category. 
  • Click into a Mode cell and click the dropdown to display the Mode Manager. Choose FMCSA / Driver 
  • Click the button at the top of the little dialog box "Apply to all records" (acknowledge "Yes" when prompted). 
  • Save & Exit. 
  • From the main menu (when program first starts) click the menu "Admin > Selection History Audit" 
  • Selection History Audit is a list of all the random selections you've conducted for each client in the directory. 
  • Click the sort icon (click the red portion) at the top of the first column so all client names appear grouped together. 
  • Find the first line for a client. 
  • Right click the name and choose "Base List at time of selection" 
  • Click into a Mode cell and click the dropdown to display the Mode Manager. 
  • Choose FMCSA / Driver Click the button at the top of the little dialog box "Apply to all records" (acknowledge "Yes" when prompted). 
  • Save & Exit. 
  • Do the same thing for each line that represents a random selection for 2004. 
  • After you do this for all clients, you'll be ready to run reports for 2004.