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.
Tracking PreAuthorizations
Re: Tracking PreAuthorizations
Bump, anyone know how to track treatment plan PreAuthorizations?
Re: Tracking 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
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
Jorge Bonilla DMD
Open Dental user since May 2005
Open Dental user since May 2005
Re: Tracking PreAuthorizations
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%'
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%'
Re: Tracking PreAuthorizations
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.
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.