Page 1 of 1
Getting The Allowed Column In Treatment Plan
Posted: Wed Jan 05, 2022 7:43 am
by nmk1
I am trying to get the "Allowed" In the Treatment Plan page.
After consulting with the OpenDental Documentation, in the "claimproc", I see this
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?
Re: Getting The Allowed Column In Treatment Plan
Posted: Wed Jan 05, 2022 10:34 am
by joes
How do you plan to use the calculation? Is this part of a query or a plugin?
Re: Getting The Allowed Column In Treatment Plan
Posted: Thu Jan 06, 2022 7:12 am
by nmk1
Query
Re: Getting The Allowed Column In Treatment Plan
Posted: Thu Jan 06, 2022 7:12 am
by nmk1
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
Re: Getting The Allowed Column In Treatment Plan
Posted: Thu Jan 06, 2022 11:15 am
by joes
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.
Re: Getting The Allowed Column In Treatment Plan
Posted: Thu Jan 06, 2022 11:37 am
by nmk1
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?
Re: Getting The Allowed Column In Treatment Plan
Posted: Thu Jan 06, 2022 12:05 pm
by joes
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.
Re: Getting The Allowed Column In Treatment Plan
Posted: Sat Jan 08, 2022 6:42 pm
by jordansparks
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.