Difference between revisions of "Reports - Patient"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 +
[[Category:Webcasts]]
 
__TOC__
 
__TOC__
  
Line 5: Line 6:
 
===Webcast Q&A===
 
===Webcast Q&A===
  
'''Q:''' Are all fields that end in DE mean they are deprecated or not used?
+
'''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.
 
'''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.
Line 13: Line 14:
  
 
==Links==
 
==Links==
 
Other Galen [[Webcasts]]
 

Latest revision as of 22:27, 26 December 2012

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