Personal tools
Navigation
 

Patients not seen in 10 years

Provided by Leo Pavone. Here is a RBT that seems to work but it's very inefficient. Basically, I'm making a sublist of any health card (HIN) that have a billing after a selected date and then asking for health cards that are NOT IN this list. The "NOT IN" comparison can take a long time if the list is long, so I would be wary about runningg this unless you have done some testing. Maybe someone in the list can suggest an more efficient way.

Plain Text icon Pt not seen in 10 years.txt — Plain Text, 467 bytes

File contents

<report title="No Billings after Date " description="Searches for patients with no billing after a date selected" active="1"><query>select CONCAT(demo.last_name ,", ",demo.first_name) "Date: {start}", demo.hin
from demographic demo
where demo.hin <>""      and demo.hin not in (select DISTINCT bm.hin from billing_on_cheader1 bm where bm.billing_date >= '{start}' and bm.status <>"D"); </query><param id="start" type="date" description="Date:"> </param>
</report> 

Document Actions

 

Download button

DOWNLOAD OSCAR FOR TESTING

 

eForms button

DOWNLOAD SHARED E-FORMS


 Customize button

FIND PLUG-INS AND TWEAKS
FOR YOUR OSCAR EMR

 

Subscribe Button

SUBSCRIBE TO DISCUSSION LIST 
(SEE ALL LISTS)

  

Help button

ACCESS THE ONLINE MANUALS
(PAID SUPPORT)