Encounters per Year

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 17:03, 29 July 2014 by Litisha.Turner (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Finding the number of annual encounters involves running the following query against the Works DB in SQL:

select count( * ) from encounter where DATEDIFF(day,encounter.dttm, GETDATE()) < 365