HIPAA Compliant Patient Tracking

One major challenge of current Electronic Medical Record (EMR) technology is that it is virtually impossible for a single hospital department to simply track their own patients.  Most departments only need a small subset of the available information, but they need it accessible in their own format.  To solve this problem many departments use shared spreadsheets and Microsoft Access databases that are NOT HIPAA compliant.

Data Warehouse Consultants has solved this problem for many hospital departments by using custom SQL Server databases with a web application front-end.  We can provide a low-cost, HIPAA-compliant solution, that allows the department to track its own patients without stepping on what the EMR does.  In many cases we can also integrate with the EMR directly via our HL7 Receiver product.  This gives hospital departments a simple solution that helps them work with their patients while also protecting their patients’ medical privacy.

For a live demo of how this product could work for you or your department, please fill out on online Contact Form.

Read Emails into Your Database

Have you ever wanted to integrate your inbox directly into your website or other database application?  Data Warehouse Consultants has developed a Windows application that can handle this.   This software is typically run as a windows service, and monitors an email inbox or other folder over an IMAP connection.  When email arrives the application seamlessly loads the email and any attachments it contains into your local SQL Server database for further processing.  We can also work with you to develop a custom procedure to act on the emails after they are loaded to remove spam, assign them to a particular worker for follow-up, or just to catalog the emails according to your custom specs.  We have already developed the custom code to handle most types of email, and we make it a simple process to move emails and attachments directly into a database.

For a live demo to see how this works, please fill out our Contact Form.

Sickle Cell Patient Pain Log

Virtual Tracking Board

Data Warehouse Consultants developed a virtual tracking board that allows nurses within a hospital to maintain updates on patients who are getting various services across many floors and service rooms.  This web application takes the place of the typical whiteboard by the nurse’s station, and replaces it with a secure HUB for live communications between personnel.  This board enhances communication within the unit and reduces the need to make phone calls by integrating nurses notes with existing event messages that are sent over the UPMC message router.  This custom solution can be tailored to meet the needs of any hospital department by combining several available technologies into one integrated solution at a fraction of the cost of other medical software providers.

A short presentation that highlights this system can be found here.

To request a demo of this solution please fill out our Contact Form.