Getting The Allowed Column In Treatment Plan

[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?

[joes]

How do you plan to use the calculation? Is this part of a query or a plugin?

[nmk1]

Query

[nmk1]

How do you plan to use the calculation? Is this part of a query or a plugin?

Query

[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.

[nmk1]

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]

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]

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.