How to run this report?
How to run this report?
How can I run a report in OD to show me the number or % of patients without insurance coverage and/or with insurance that I do not par with? Thanks
Re: How to run this report?
Slightly off-topic as I cannot help you here, but just a question: For insurances that you are not enrolled as a participating dentist, you can still bill out as out-of-network, right? I get confused sometimes when some patient comes to see me saying that her previous dentist no longer accepts her insurance. In my head I'm thinking, "what the heck, why didn't that dentist just bill out-of-network?!?"
Philip H. Doan, DDS
http://www.kaweahdental.com/
http://www.kaweahdental.com/
-
- Posts: 293
- Joined: Mon Apr 22, 2013 8:49 am
- Location: Dallas, TX
- Contact:
Re: How to run this report?
Query example #69 looks like it might get you part way there:fishdrzig wrote:How can I run a report in OD to show me the number or % of patients without insurance coverage and/or with insurance that I do not par with? Thanks
Code: Select all
/*69 Count of patients by Carrier with procedures
completed in date range*/
SET @FromDate='2014-01-01' , @ToDate='2014-01-31';
/*Adjust above Dates AS needed*/
SELECT carrier.CarrierName, COUNT(DISTINCT claimproc.PatNum) AS 'Patients'
FROM carrier
INNER JOIN insplan ON carrier.CarrierNum=insplan.CarrierNum
INNER JOIN claim ON insplan.PlanNum=claim.PlanNum
INNER JOIN claimproc ON claim.ClaimNum=claimproc.ClaimNum
INNER JOIN procedurelog ON claimproc.ProcNum=procedurelog.ProcNum
INNER JOIN procedurecode ON procedurelog.CodeNum=procedurecode.CodeNum
AND (procedurelog.ProcDate BETWEEN @FromDate AND @ToDate)
AND ProcStatus=2
GROUP BY CarrierName
ORDER BY CarrierName;
-
- Posts: 293
- Joined: Mon Apr 22, 2013 8:49 am
- Location: Dallas, TX
- Contact:
Re: How to run this report?
If you're a PPO office this one might help, too:fishdrzig wrote:How can I run a report in OD to show me the number or % of patients without insurance coverage and/or with insurance that I do not par with? Thanks
Code: Select all
/*317 Show count of active patients using each fee schedule whether through primary insurance, patient level feesched or provider fee schedule*/
DROP TABLE IF EXISTS tmp;
CREATE TABLE tmp SELECT p.PatNum, IFNULL(fs.Description,
IFNULL((SELECT fs1.Description FROM feesched fs1 WHERE fs1.FeeSchedNum=p.FeeSched),
(SELECT fs2.Description FROM feesched fs2,provider WHERE p.PriProv=provider.ProvNum AND fs2.FeeSchedNum=provider.FeeSched)
)) AS FeeSchedule
FROM patient p
LEFT JOIN patplan pp ON p.PatNum=pp.PatNum AND pp.Ordinal=1 /*only primary insurance matters here*/
LEFT JOIN inssub iss ON iss.InsSubNum=pp.InsSubNum
LEFT JOIN insplan ip ON ip.PlanNum=iss.PlanNum
LEFT JOIN feesched fs ON ip.FeeSched=fs.FeeSchedNum
WHERE p.PatStatus=0 /*Active Patients*/
ORDER BY p.LName, p.FName;
SELECT FeeSchedule, COUNT(FeeSchedule) FROM tmp
GROUP BY FeeSchedule
ORDER BY FeeSchedule ASC;
DROP TABLE IF EXISTS tmp;
Re: How to run this report?
Where do you find these numbered reports in OD??
-
- Posts: 293
- Joined: Mon Apr 22, 2013 8:49 am
- Location: Dallas, TX
- Contact:
Re: How to run this report?
http://opendentalsoft.com:1942/ODQueryL ... yList.aspxfishdrzig wrote:Where do you find these numbered reports in OD??