Reporting on Results

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to: navigation, search

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.