Difference between revisions of "Reports - Patient"
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: | + | '''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== | ||
− | |||
− |
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)