Notifications
Clear all
General Discussion
4
Posts
3
Users
0
Reactions
79
Views
Topic starter
Good Morning,
I hope there is a simple way to do this.
Looking to get a total patient count of active patients in our EMR? What is the quickest way to go about this?
Thank you!
Rebecca
Posted : May 19, 2013 11:18 pm
select count(*) from ml.person where ispatient = 'Y' and pstatus = 'A' will give you all active patients (at least in the Oracle EMR world).
David Shower
OU Tulsa School of Community Medicine
Posted : May 20, 2013 2:49 am
Inside the EMR Reports area you can create a quick inquiry that just looks for patients and select the option for Active Patients only and then select Count as the option and run the inquiry. We have over 600K active patients and it runs in about 2 seconds on my system.
Posted : May 20, 2013 2:55 am
Topic starter
Thank you. That worked!
Rebeca
Posted : May 20, 2013 4:25 am
