Insurance Carrier list printed

For users or potential users.
Post Reply
Craig-DMA
Posts: 11
Joined: Fri May 20, 2016 6:54 am

Insurance Carrier list printed

Post by Craig-DMA » Wed Jun 15, 2016 11:02 am

Is there a way to get the Insurance carrier list printed? maybe by a query?
Basically if you select list at the top then insurance carriers I need that list printed out and can't find a query that lists this..

User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Re: Insurance Carrier list printed

Post by Jorgebon » Wed Jun 15, 2016 1:29 pm

Run this query and then print the results:

Select carrier.carriername, carrier.Address, carrier.Address2, carrier.City, carrier.State, carrier.Zip, carrier.Phone, carrier.ElectID from carrier
where carrier.ishidden = 0
Jorge Bonilla DMD
Open Dental user since May 2005

Craig-DMA
Posts: 11
Joined: Fri May 20, 2016 6:54 am

Re: Insurance Carrier list printed

Post by Craig-DMA » Wed Jun 15, 2016 1:32 pm

Almost perfect but I also need the number of ppl on each carrier as well

User avatar
Arna
Posts: 444
Joined: Tue Jul 09, 2013 3:16 pm

Re: Insurance Carrier list printed

Post by Arna » Wed Jun 15, 2016 1:36 pm

The built in Insurance Plan List in the Reports window will list all your plans and carriers. You'll need a query for a count of subscribers for each plan.
Entropy isn't what it used to be...

Arna Meyer

Craig-DMA
Posts: 11
Joined: Fri May 20, 2016 6:54 am

Re: Insurance Carrier list printed

Post by Craig-DMA » Wed Jun 15, 2016 1:55 pm

That list just lists out each patient. I just want the number in each like its listed in the lists/insurance carriers

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Insurance Carrier list printed

Post by Tom Zaccaria » Wed Jun 15, 2016 3:54 pm

Try this:

/*122*/ SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients'
FROM carrier
INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum
INNER JOIN inssub ib ON ib.PlanNum=ip.PlanNum
INNER JOIN patplan pp ON pp.InsSubNum=ib.InsSubNum
INNER JOIN patient p ON pp.PatNum=p.PatNum
WHERE p.PatStatus=0
GROUP BY CarrierName
ORDER BY CarrierName;

drtmz

User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Re: Insurance Carrier list printed

Post by Jorgebon » Thu Jun 16, 2016 5:36 am

If you combine both queries you can get all the info:

SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients',carrier.Address, carrier.Address2, carrier.City, carrier.State, carrier.Zip, carrier.Phone, carrier.ElectID
FROM carrier
INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum
INNER JOIN inssub ib ON ib.PlanNum=ip.PlanNum
INNER JOIN patplan pp ON pp.InsSubNum=ib.InsSubNum
INNER JOIN patient p ON pp.PatNum=p.PatNum
WHERE p.PatStatus=0
AND carrier.ishidden = 0
GROUP BY CarrierName
ORDER BY CarrierName;
Jorge Bonilla DMD
Open Dental user since May 2005

Craig-DMA
Posts: 11
Joined: Fri May 20, 2016 6:54 am

Re: Insurance Carrier list printed

Post by Craig-DMA » Thu Jun 16, 2016 6:01 am

I saw that one in the examples already, I appreciate all the help but If I could combine that query and one that adds the carrier info it'd be great but I'm having a hard time writing this sql. It's a bit of a learning curve if you havent done much with it. I thought I could just add carrier.address, carrier.city etc but I always get errors and I just dont understand :(

Craig-DMA
Posts: 11
Joined: Fri May 20, 2016 6:54 am

Re: Insurance Carrier list printed

Post by Craig-DMA » Thu Jun 16, 2016 6:03 am

Jorgebon wrote:If you combine both queries you can get all the info:

SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients',carrier.Address, carrier.Address2, carrier.City, carrier.State, carrier.Zip, carrier.Phone, carrier.ElectID
FROM carrier
INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum
INNER JOIN inssub ib ON ib.PlanNum=ip.PlanNum
INNER JOIN patplan pp ON pp.InsSubNum=ib.InsSubNum
INNER JOIN patient p ON pp.PatNum=p.PatNum
WHERE p.PatStatus=0
AND carrier.ishidden = 0
GROUP BY CarrierName
ORDER BY CarrierName;
I missed this reply. Thank you so much!!!! You're seriously the best!

Post Reply