Reporting on Results

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Webcast Overview

Galen continues its series on reporting from the Allscripts Enterprise EHR database with a focus on the Results. This webcast will take clients through the database to report on orders tied to patients and the tables in the application build for Results.


Files

Delivered 9/19/2012: Download slideshow

Delivered 6/11/2014: Download slides

Questions

Will you be offering a similar seminar for orders?

Answer: Yes, Galen will continue to have reporting webcasts on various clinical topics.

Are the vitals results in the Result tables?

Answer: No, vitals are not stored in the results tables. They can be found in the Finding tables.

What do QO stand for?

Answer: QO stands for Questions and Orders

Why do queries require so many tables?

Answer: The Works database is a relational database utilizing many normalization standards. Database normalization is the process of splitting large tables into smaller tables for ease of updates, among other reasons. Updating a single small table is much simpler when a defined relationship exists, especially when records in the larger tables can get into the millions. Additional information can be found on wikipedia.