Patient report
-
- Posts: 7
- Joined: Wed Aug 07, 2013 7:55 am
Patient report
Is there a way to get a list/report of our patients that don't have insurance.
Re: Patient report
Here's a quick little query that will give you a list of uninsured patients:
I want to warn you to be careful when looking at our Query Examples page regarding patients with no insurance. Most of them are using the patient.HasIns column which is sort of deprecated.
Code: Select all
SELECT CONCAT(p.LName,', ',p.FName) AS 'Patient Name'
FROM patient p
LEFT JOIN patplan pp ON pp.PatNum=p.PatNum AND pp.Ordinal=1
WHERE pp.PatNum IS NULL
AND p.PatStatus=0
ORDER BY p.LName,p.FName
-
- Posts: 13
- Joined: Thu Dec 17, 2015 10:10 am
Re: Patient report
That is awesome, is there a way I can limit that search to a certain date or date range.
Re: Patient report
This will give you the same list with patients having completed procedures between the indicated dates.
Code: Select all
SET @startDate='2007-01-01' , @endDate='2020-01-01';
SELECT CONCAT(p.LName,', ',p.FName) AS 'Patient Name'
FROM patient p
LEFT JOIN patplan pp ON pp.PatNum=p.PatNum AND pp.Ordinal=1
INNER JOIN procedurelog pl ON p.PatNum=pl.PatNum
WHERE pp.PatNum IS NULL
AND p.PatStatus=0
AND (pl.ProcDate BETWEEN @startDate AND @endDate)
AND pl.ProcStatus=2
GROUP BY p.PatNum
ORDER BY p.LName,p.FName;
Re: Patient report
Note that the above query does not take into account the insurance the patient had at the time the procedure was completed, only what their current insurance coverage is now. The patient may have dropped their insurance plan between the procedure date and today. If you are trying to look back several months/years into the past you will need a more complicated query.
See https://opendentalsoft.com:1943/ODQuery ... tForm.aspx if you are interested in getting a report that would better fit what you're looking for.
See https://opendentalsoft.com:1943/ODQuery ... tForm.aspx if you are interested in getting a report that would better fit what you're looking for.