Query to compare insurance reimbursements by ADA code

[Tom Zaccaria]

Looking for a query to compare insurance plan reimbursement in a spreadsheet form for all or some of the ADA procedure codes such as:

Insurance Plan...............Aetna......MetLife....Cigna......Delta
Ada code....Description.....Fee.........Fee........Fee.........Fee

It would be helpful if you could select which insurance plans you could select to compare.

Thanks,
drtmz

[joes]

The closest query we have on our Query Examples page is #493. There are a few steps for setting it up properly mentioned in the query's comments. The first column lists all the codes, and each following column lists the fees for a given fee schedule. You could set it up for all of the fee schedules attached to the insurance plans that you are interested in.

Link to the Query Examples page: https://opendentalsoft.com:1943/ODQuery ... yList.aspx

[Tom Zaccaria]

Thanks for your help.

drtmz

[Tom Zaccaria]

Did a little fiddling with a list of Fee Schedules and their corresponding Plan Numbers and it works perfectly. Exactly what I was looking for.
Thanks again,

drtmz

[Tom Zaccaria]

To get rid of the procedures with no fee(s), procedures you do not do in your practice such as ortho, export the report to Excel.
Data sort on the Standard column from low to high value. Then delete all the rows with zero Standard fees.
Lastly, resort on ProcCode column to get your final report.

drtmz