Getting The Allowed Column In Treatment Plan

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
nmk1
Posts: 6
Joined: Wed Jul 28, 2021 1:37 pm

Getting The Allowed Column In Treatment Plan

Post by nmk1 » Wed Jan 05, 2022 7:43 am

I am trying to get the "Allowed" In the Treatment Plan page.

After consulting with the OpenDental Documentation, in the "claimproc", I see this
Image

So it seems that the "Allowed" column is calculated by looking at some column that has "ComputeEstimates" divided by "ComputeBaseEst". Except these column names do not exist. Im not understanding how to calculate the "Allowed" column

I am trying to calculate how do I get the "Allowed" value in any given claim.

How would I do this?

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Getting The Allowed Column In Treatment Plan

Post by joes » Wed Jan 05, 2022 10:34 am

How do you plan to use the calculation? Is this part of a query or a plugin?
Joe Sullivan
Open Dental Software
http://www.opendental.com

nmk1
Posts: 6
Joined: Wed Jul 28, 2021 1:37 pm

Re: Getting The Allowed Column In Treatment Plan

Post by nmk1 » Thu Jan 06, 2022 7:12 am

Query

nmk1
Posts: 6
Joined: Wed Jul 28, 2021 1:37 pm

Re: Getting The Allowed Column In Treatment Plan

Post by nmk1 » Thu Jan 06, 2022 7:12 am

joes wrote:
Wed Jan 05, 2022 10:34 am
How do you plan to use the calculation? Is this part of a query or a plugin?
Query

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Getting The Allowed Column In Treatment Plan

Post by joes » Thu Jan 06, 2022 11:15 am

The "Procedure.ComputEstimates/ClaimProc.ComputeBaseEst" in that column description for AllowedOverride is not a calculation. It is referring to a pair of functions in our code. For each procedure in the treatment plan, the Procedure.ComputeEstimates function calls the ClaimProc.ComputeBaseEst function in which the allowed amount is determined. The ComputeBaseEst function makes many decisions and calculations based on program settings, insurance plan settings, and fee schedules to determine the allowed amount. It would not easily translate to a query.
Joe Sullivan
Open Dental Software
http://www.opendental.com

nmk1
Posts: 6
Joined: Wed Jul 28, 2021 1:37 pm

Re: Getting The Allowed Column In Treatment Plan

Post by nmk1 » Thu Jan 06, 2022 11:37 am

joes wrote:
Thu Jan 06, 2022 11:15 am
The "Procedure.ComputEstimates/ClaimProc.ComputeBaseEst" in that column description for AllowedOverride is not a calculation. It is referring to a pair of functions in our code. For each procedure in the treatment plan, the Procedure.ComputeEstimates function calls the ClaimProc.ComputeBaseEst function in which the allowed amount is determined. The ComputeBaseEst function makes many decisions and calculations based on program settings, insurance plan settings, and fee schedules to determine the allowed amount. It would not easily translate to a query.
Alright! Then for the protcp table ( https://www.opendental.com/OpenDentalDo ... xml#proctp ), this table is for saved treatment plans. Is it possible to get active treatment plans?

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Getting The Allowed Column In Treatment Plan

Post by joes » Thu Jan 06, 2022 12:05 pm

Saved treatment plans are linked to proctps which do capture the allowed amount for a moment in time. Unfortunately, active treatment plans are linked to procedures via the treatplanattach table which only stores the treatment plan priority.
Joe Sullivan
Open Dental Software
http://www.opendental.com

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Getting The Allowed Column In Treatment Plan

Post by jordansparks » Sat Jan 08, 2022 6:42 pm

Would BaseEst be close enough? It does already have percentages applied. Notice that in the description of AllowedOverride, ComputeBaseEst is the function where the allowed fee is calculated. BaseEst is very close to allowed fee.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply