Getting The Allowed Column In Treatment Plan
Getting The Allowed Column In Treatment Plan
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?
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
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
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
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 wrote: ↑Thu Jan 06, 2022 11:15 amThe "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
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.
- jordansparks
- Site Admin
- Posts: 5746
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: Getting The Allowed Column In Treatment Plan
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
http://www.opendental.com