How to run this report?

[fishdrzig]

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

[teethdood]

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?!?"

[KevinRossen]

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

Query example #69 looks like it might get you part way there:

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;

[KevinRossen]

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

If you're a PPO office this one might help, too:

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;

[fishdrzig]

Where do you find these numbered reports in OD??

[KevinRossen]

Where do you find these numbered reports in OD??

http://opendentalsoft.com:1942/ODQueryL ... yList.aspx