Open Dental Forum

Hello,
I was wondering if there was a way to track Pre-Authorizations... I would like to be able to pull up a list from open dental that lists all the pending Pre-authorizations, sent pre-authorizations, and received pre-authorizations.

This way, we can see if it's taking too long for an insurance to come back with the estimate. Currently, we are just keeping a hard copy list of all the pre-authorizations we send, and we track it that way.

Bump, anyone know how to track treatment plan PreAuthorizations?

Here's a query I wrote for this purpose. Check it out to see if it will give you what you need:

SET @FromDate='2012-01-01' , @ToDate='2013-01-01';
SELECT claim.plannum, claim.claimstatus, claim.datesent, claim.patnum, claim.claimfee
FROM claim
WHERE claim.claimtype = 'preauth'
AND claim.datesent >=@FromDate
AND claim.datesent <=@ToDate
ORDER BY datesent

Jorge Bonilla DMD

One way to track them is to go to (Reports / Outstanding Insurance Claims) and check the box to include preauths. This only tracks the outstanding ones.

If you need something more than than then you will probably need a custom query. This is quick and dirty but might do what you need.


/*Adjust Claim status Like as needed for U=Unsent, H=Hold until pri received, W=Waiting in queue, S=Sent, R=Received */

Select patnum, claimfee, InsPayEst, InsPayAmt, ReasonUnderPaid, ClaimNote
from claim
where claim.ClaimType like '%PreAuth%'
AND claim.claimstatus like '%R%'

Thanks for the help guys! The query works great now.
I am using Jorgebon's query. Its good because it sorts out the dates of the preauthorizations, that way my receptionist can follow-up on patients who did not schedule an appointment after getting approved for a few months.