Reports - Patient

Join us to receive an overview of the Enterprise EHR (Works) database model, including patient demographics and dictionary linking. We will study the tables involved, database diagrams and write T-SQL queries against the Works database in SQL Server Management Studio.

Webcast Q&A

Q: Are all fields that end in DE mean they are deprecated or not used?

A: The fields ending in DE indicate that they reference a dictionary (DE stands for Dictionary Entry). Tables ending in "_DE" correspond to these columns.

Resources

Introduction to the Allscripts DB (PDF)

Links

Other Galen Webcasts