SQL: ADHD Recall

About

This SQL will show all active patients of your practice for whom you have prescribed an ADHD medication in the past year and do not have a future follow up appointment on the schedule. The report will show:
  • Last well visit which you coded ADHD as a diagnosis in Dx 2-Dx 4.
  • Encounter noted which you coded ADHD in Dx 1.
  • Last ADHD Rx was written

A sample image of this SQL report run in the Database Viewer is shown below:

Report Usage Ideas

  • Run the ADHD SQL and sort by PCP and print the list for each. The PCP can reach out telephonically to his or her parents on the list as a "virtual check-in" (G2012) and schedule the next appointment.
  • Rn the ADHD SQL and create a message using PMX (Patient Message Exchange) with a link to chadis.com asking the family to login and complete ADHD home forms.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select r.patno, staffname, fname, lname, birthdat, last_well_adhd, last_visit, mdm_plan as last_plan,  last_rx, next_appt from register r
left outer join (select patno, max(date1) as last_visit from enc_note where dxcode like 'F90%' group by patno)
 e on e.patno = r.patno  left outer join (select patno, max(date1) as last_well_adhd from physical where (dxcd2 like 'F90%' or dxcd3 like 'F90%' or dxcd4 like 'F90%')  group by patno) w on w.patno = r.patno inner join (select patno, max(date1) as last_Rx from medications  where
 ( lower(prescrib) like '%adderall%' or
 lower(prescrib) like '%concerta%' or lower(prescrib) like '%methylphenidate%' or lower(prescrib) like
 '%vyvanse%' or lower(prescrib) like '%ritalin%' or lower(prescrib) like '%guanfacine%' or lower(prescrib) like
 '%dextroamphetamine%' or lower(prescrib) like '%clonidine%' or lower(prescrib) like '%intuniv%' or
lower(prescrib) like '%focalin%' or lower(prescrib) like '%procentra%' or lower(prescrib) like '%quillivant%' or lower(prescrib) like '%metadate%' or lower(prescrib) like '%tenex%' or lower(prescrib) like '%quillichew%' or lower(prescrib) like '%strattera%') and purpose not like '%reference%'
and date1 >= cast('today' as date) - 365  group by patno) m on m.patno = r.patno
left outer join (select patno, date1, mdm_plan from enc_note) e2 on e2.patno = r.patno and e2.date1 = e.last_visit
left outer join (select patno, min(appt_date) as next_appt from schedule where appt_date > cast('today' as date) and( visit_status is null or visit_status not in ('Cancelled','Canceled','No Show','No Show*')) group by patno) s on s.patno = r.patno
left outer join staff1 on staff1.staffid = r.addr_id
where status_pat = 'ACTIVE' and lname <> 'TESTPATIENT'
and next_appt is null