Clinical Data Export

Designed and Implemented data portability concepts using PHP scripts that allow extraction of clinic or practice specific data from a legacy custom MySQL database on an ongoing basis. The current system uses the same tables for storing patient and billing data for all clinics / practices and our goal was to provide for a way to share back data to specific clinics that were requesting this info.

We setup the script as a daily cron that runs during non-peak hours and dumps data into a clinic specific database. We then implemented replication of this clinic database to a slave db that resides on the clinic’s server so that they had real time data on an ongoing basis. We also implemented a custom function to download scanned documents to the clinic’s server from Amazon S3.