Has anyone developed database queries to automate sending lab values or specific bio-metric data to specific insurance companies? We have lab feeds built to upload data to some insurance companies but there are others who can not receive in the format that we send it.
Yes I build these for a lab company I support. Contact me if you are interested, [email protected]
Are you familiar at all with SQL Server Reporting Services? This provides a way to create a report and schedule the report to send to a user if email is the destination. The final output can be csv, excel, html, or word.
I am sure you could do something similar with Crystal, but I am not as familiar.
This sounds more like an interface than a SQL query. It sounds fairly simple as well. If you would like assistance with having one written let me know. I have written dozens in both Mirth and Qvera.