Case Study: Occupational Medical Results

---

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 certified data regarding employees’ health test results.

The Solution

Build a client-only extranet system to handle the importing, viewing and downloading of test information. Clients can search on different criteria for tests, such as Company, employee number, test date ranges, and more. All single tests can be downloaded as signed, watermarked PDF documents as can the aggregated test history (blood levels with on-the-fly generated graphs) per employee.

• Hepatitis Tests
• Lead/ZPP Tests
• Respiratory Fit/Clearance Tests
• Audiometry Tests

The Results

A system built in ColdFusion that receives data nightly, imported into a Microsoft SQL Server database, for dissemination by authorized staff members of clients.