TreatPlanAttaches GET

For requests or help with our API
Post Reply
PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

TreatPlanAttaches GET

Post by PBECKER » 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

justine
Posts: 168
Joined: Tue Dec 28, 2021 7:59 am

Re: TreatPlanAttaches GET

Post by justine » Wed May 31, 2023 1:45 pm

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

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: TreatPlanAttaches GET

Post by PBECKER » 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

justine
Posts: 168
Joined: Tue Dec 28, 2021 7:59 am

Re: TreatPlanAttaches GET

Post by justine » Wed May 31, 2023 1:54 pm

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.

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: TreatPlanAttaches GET

Post by PBECKER » 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

justine
Posts: 168
Joined: Tue Dec 28, 2021 7:59 am

Re: TreatPlanAttaches GET

Post by justine » Thu Jun 01, 2023 7:54 am

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.

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: TreatPlanAttaches GET

Post by PBECKER » 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.

justine
Posts: 168
Joined: Tue Dec 28, 2021 7:59 am

Re: TreatPlanAttaches GET

Post by justine » Thu Jun 01, 2023 12:54 pm

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!

Post Reply