Extract data from Sage PCN Health Network‘s native Unify SQL database into Microsoft Access for data analysis.

This project consists of –

• Script of SQL queries to extract data from Unify into tab-delimited files
• PHP script to extract binary data from the Billing Header Add-on table (b3llihwc)
• Bourne Shell script to combine data into compressed tar file for easy transmission to Windows
• Microsoft Access database
• Links to exported tab-delimited files
• Physician Procedure Report detailing all procedures performed by each physician
• Resident Procedure Report detailing all procedures performed by each resident
• Data analysis of billing revenues by date