Printing my Insurance Carriers list

For users or potential users.
Post Reply
jonesdds12
Posts: 12
Joined: Tue May 07, 2013 12:57 pm

Printing my Insurance Carriers list

Post by jonesdds12 » Sat Mar 23, 2019 10:07 am

Is there no way to do this?

I'd want the carrier name, phone, address and ideally the electronic id. How can I do this?

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

Re: Printing my Insurance Carriers list

Post by Tom Zaccaria » Sat Mar 23, 2019 12:13 pm

Try this,
drtmz

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier

jonesdds12
Posts: 12
Joined: Tue May 07, 2013 12:57 pm

Re: Printing my Insurance Carriers list

Post by jonesdds12 » Sat Mar 23, 2019 1:34 pm

That worked ok but it's not a complete list, some are missing and it's in a very odd order. I was going to post the screenshot but no idea how to do that. Seems odd there's not a standard report to print this list.

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

Re: Printing my Insurance Carriers list

Post by Tom Zaccaria » Sun Mar 24, 2019 7:37 am

There is:

Main Menu, Lists, Insurance Carriers

drtmz

jonesdds12
Posts: 12
Joined: Tue May 07, 2013 12:57 pm

Re: Printing my Insurance Carriers list

Post by jonesdds12 » Sun Mar 24, 2019 9:45 am

Yes, but can't print it. Or can I some way(and not screen shots)

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

Re: Printing my Insurance Carriers list

Post by Tom Zaccaria » Mon Mar 25, 2019 2:53 am

Work around:
Make the window as large as you can by stretching it to the top and bottom of the screen. Then use screen shots.

drtmz

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

Re: Printing my Insurance Carriers list

Post by Jorgebon » Mon Mar 25, 2019 4:27 am

Does this work for you?

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier where IsHidden = 0 order by CarrierName
Jorge Bonilla DMD
Open Dental user since May 2005

User avatar
irfan
Posts: 216
Joined: Thu Oct 21, 2010 9:09 am

Re: Printing my Insurance Carriers list

Post by irfan » Wed Mar 27, 2019 2:25 pm

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
order by carriername asc

Post Reply