Skip to content
No results
  • Home
  • Manual
  • About OSCAR
  • News
    • News
    • OSCAR Tips
  • Downloads
    • All Downloads
    • eForms
    • Order an eForm
    • Report by Template (RBT)
    • Browser Addons
  • Donate
The Oscar Galaxy

Open Source Clinical Applications and Resources

  • Home
  • Manual
  • About OSCAR
  • News
    • News
    • OSCAR Tips
  • Downloads
    • All Downloads
    • eForms
    • Order an eForm
    • Report by Template (RBT)
    • Browser Addons
  • Donate
The Oscar Galaxy

Open Source Clinical Applications and Resources

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

  • John RobertsonJohn Robertson
  • March 28, 2023
  • Administrative, Communication with Patient, Report Templates
  • Version
  • Download 691
  • 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]
  • Manual
  • Report Website Issue
  • Donate
  • About this Site
  • Disclaimer
  • Sitemap
  • Links for Developers

Copyright © 2025 The Oscar Galaxy