- Version
- Download 422
- 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
| File | Action |
|---|---|
| list of emails for patients seen within the past 36 months | Download |