======Patients By Rendering Provider======

Back to [[QueryDirectory Query Directory]]

// 
I need a report that lists by rendering provider the names of any patients who had a service by that provider—and I need to set the date parameters and choose the therapist I want that info on.
//
Here's the query, which is easy enough. Just adjust the conditions in the WHERE clause 
for the desired date range and provider codes. 

%%(sql)
SELECT 
  DISTINCT pr.provcode, pt.lastname, pt.firstname, pt.id
FROM 
  providers pr 
  JOIN jcharges jc ON pr.providernum = jc.providernum
  JOIN journal jou ON jc.jnum = jou.jnum
  JOIN patients pt ON jou.ptnum = pt.ptnum
WHERE 
  jou.trandate BETWEEN '2010-01-01' AND '2010-12-31'
  AND pr.provcode IN ('VB1','VB2','VB3')
ORDER BY 
  pr.provcode, pt.lastname, pt.firstname, pt.id
%%


----
CategoryQueries