For complex topics that regular users would not be interested in. For power users and database administrators.
-
nmk1
- Posts: 6
- Joined: Wed Jul 28, 2021 1:37 pm
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
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
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?
-
nmk1
- Posts: 6
- Joined: Wed Jul 28, 2021 1:37 pm
Post
by nmk1 » Thu Jan 06, 2022 7:12 am
Query
-
nmk1
- Posts: 6
- Joined: Wed Jul 28, 2021 1:37 pm
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
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.
-
nmk1
- Posts: 6
- Joined: Wed Jul 28, 2021 1:37 pm
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
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.
-
jordansparks
- Site Admin
- Posts: 5742
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
-
Contact:
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.