Difference between revisions of "Reports - Patient"
Jump to navigation
Jump to search
(Created page with ' '''Description:''' This webcast will provide an overview on reporting for patient demographics within the Allscripts EHR application. ---- '''Questions & Answers from the Webc…') |
|||
| Line 1: | Line 1: | ||
| + | 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=== | ||
| + | [[Media:Introduction to the Allscripts DB.pdf|Introduction to the Allscripts DB (PDF)]] | ||
Revision as of 21:05, 8 May 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.