list of emails for patients seen within the past 36 months.

  • Version
  • Download 577
  • File Size 0.84 KB
  • File Count 1
  • Create Date March 28, 2023
  • Last Updated March 28, 2023

list of emails for patients seen within the past 36 months.

Created by Stanley Hurwitz.


select distinct CONCAT( "/" , 'Demographic', "/" ) As "Demographic",demo.last_name"Last Name",demo.first_name"First Name",demo.phone "Home Phone",demo.phone2"Alternate Phone",demo.email"Email",b.billing_date "Billing Date"

from billing b, billingmaster bm, demographic demo where (demo.email != "" and b.billing_no = bm.billing_no and demo.demographic_no = b.demographic_no and b.billing_date >DATE_SUB(now(), INTERVAL 36 MONTH) and demo.patient_status = 'AC 'and demo.roster_status <> 'Private billings')

group by demo.email
order by b.billing_date desc

Attached Files and Latest Versions

FileAction
list of emails for patients seen within the past 36 monthsDownload
  Administrative     Appointment     email     follow up     RBT     Report By Template  
[featured_image]