Best Practice – Find patients who have attended your practice in the last 2 years with a family history of hepatitis B
The BP search screen allows you to search for patients with particular attributes. In this case we’re going to combine Demographics with Family/Social to get a list of patients with a family history of hepatitis B and have attended in the last two years.
Start a new search and click on Visits.
Once again select your From and To dates to limit the query to patients presenting between these dates, click “Include inactive providers” then click Add to continue.
Best Practice searches for active patients by default, and we want to include inactive patients in this search, so tick the box “Include inactive patients”.
Next click “Family/Social”.
On the Family history drop down, select “Any”.
In the top right search box, click the three dots button then type into the Search list “HEPATITIS B”.
Find “Hepatitis B”, and double-click it and click Select.
Finally click Add then OK.
Once again you may wish to “Save query” so that you can use it again. Click “Run query” and save the resulting patients as before.
ADVANCED NOTE:
You may want to add both Hepatitis B and Hepatitis B infection and Hepatitis B vaccination declined. However adding just one of these is sufficient – because we are searching for a coded diagnosis BP uses the Disease code which includes all of these.
ADVANCED NOTE 2:
If you’ve worked through our ATSI query you’ll know that you can add more than one condition to a query. Just remember to replace the AND with OR in the SQL statement.