Case Study: Fit For Duty

---

The Challenge

Clarity Testing offers a full suite of onsite medical and testing services throughout the Northeast. Operating the largest fleet of state-of-the art “Labmobiles”, Clarity's expert and certified professionals provide the highest quality onsite workplace safety services without breaking the stride of business.

Clarity Testing hired Sidian Consulting to build an extranet for their customers who have the need to review and download the status of union drivers that are fit to operate a motor vehicle.

The Solution

Build a client-only extranet system to handle the importing, viewing and downloading of fit for duty status information for drivers. Clients can search on different criteria for tests, such as Company, employee number, fit date ranges, and more. All single tests can be printed as signed, watermarked documents.

• Union Information Management
• Driver Information Management / Driver Queries
• Audit Logs (for logins and driver queries)
• Driver Import (manually from a spreadsheet template)

The Results

A system built in ColdFusion that receives data nightly, imported into a Microsoft SQL Server database, for dissemination and download by authorized union staff.