Open Dental

Is it possible to add the below fields to the api response for TreatPlanAttaches GET

tooth Number
Procedure Cost
Insurance Estimate
Patient Estimate

PBECKER wrote: ↑

Wed May 31, 2023 1:00 pm

Is it possible to add the below fields to the api response for TreatPlanAttaches GET

tooth Number
Procedure Cost
Insurance Estimate
Patient Estimate

Hello PBECKER,

The TreatPlanAttach table has a FK to procedurelog.ProcNum. Using the procedurelog.ProcNum, you can look up the procedurelog. The procedurelog contains ProcFee and ToothNum.

1. Use TreatPlans GET, filter by patNum.

• You now have a list of treatment plans for a patient.

2. From that list, use TreatPlansAttaches GET to find TreatPlan by treatPlanNum.

• You now have a list of treatment plan attaches for a specific patient.

3. From that list, use ProcedureLogs GET, filter by patNum.

• You now have a list of procedures for a patient.

Compare list 2 with list 3, for the patient you're interested in.

We can add Procedurelogs GET (single), to our development list, if you'd like.

For Insurance Estimate and Patient Estimate, would this workflow be helpful?
https://www.opendentalsoft.com:8085/for ... 028#p35602

any way to update the existing TreatPlansAttaches GET to return all fields names instead of having to GET then compare with ProcedureLogs GET

PBECKER wrote: ↑

Wed May 31, 2023 1:49 pm

any way to update the existing TreatPlansAttaches GET to return all fields names instead of having to GET then compare with ProcedureLogs GET

TreatPlanAttaches GET does return all fields in the table.

for ProcedureLog GET we don't see insurance Estimate and Patient Estimate. Is it possible to get these two items added to ProcedureLog GET

PBECKER wrote: ↑

Wed May 31, 2023 3:08 pm

for ProcedureLog GET we don't see insurance Estimate and Patient Estimate. Is it possible to get these two items added to ProcedureLog GET

No.

Insurance Estimate and Patient Estimate are not part of the procedurelog table.

How can these items we added to any of the Treatplan Get methods and/or any other API call?

Note these fields are existing fields that are shown to patients for their treatment plan as the patients wants to see how much the insurance is covering and what is their out of pocket cost.

Thank you API team.

PBECKER wrote: ↑

Thu Jun 01, 2023 10:40 am

How can these items we added to any of the Treatplan Get methods and/or any other API call?

Note these fields are existing fields that are shown to patients for their treatment plan as the patients wants to see how much the insurance is covering and what is their out of pocket cost.

Thank you API team.

Hello PBECKER,

Insurance and patient estimates are complex and are calculated in Open Dental based on several different database tables. These fields may be shown to patients in Open Dental, but those calculations are not necessarily stored in the database.

As an example, this post explains how to derive patient portion information as seen on an appointment.

Depending on what you're after, ProcTPs GET may be a resource you are interested in.

Thanks!