Primco Dene’s medical clinics are required to provide regular reports to clients on the medical services provided to their employees for accounting purposes. Clinic visits had to be recorded in considerable detail, covering a wide variety of conditions, both work related and personal. To complicate things further, many of the employees worked for other companies that are also Primco Dene’s clients. Historically, staff had been collecting the information using Excel spreadsheets and then distilling it down into charts. This was very labour intensive and error-prone.
Using Primco Dene’s existing spreadsheets as templates, substantial modifications to S2Web’s medical application forms were made to capture the necessary details. All the historical data was migrated manually into the database. Dedicated report queries and charts were created along with special security permissions to enable clients to login and obtain the information they need without compromising the confidentiality of employee’s medical data.