Number of active patients in practice
This is a report that looks for patient that have actually been seen in the clinic. It checks to see if there is a signed encounter entry.
Patient volume.txt
—
Plain Text,
0Kb
File contents
<report title="Active patients/provider" description="Number Active Patients in Practice by provider" active="1">
<query>
select count(distinct last_name, first_name)"Active patients" from demographic, eChart where
patient_status = 'AC' and encounter like "%igned%" and provider_no = '{provider_no}' and
demographic_no = demographicNo ;
</query>
<param id="provider_no" type="list" description="Provider Number">
<param-query>select provider_no, CONCAT(last_name, ', ', first_name, ' (', provider_no, ')') from provider where provider_no >= 1 and provider_no < 999 order by last_name;</param-query>
</param>
</report>
