Clarification on Provider and Clinic Relationship in Open Dental

[Ummehani]

Hello,

We are integrating Open Dental with an external system and are currently working with the Provider API. Upon reviewing both the API response and the database schema, we could not find any column or property that directly links a Provider to a ClinicNum.

Could you please confirm:
1. Is there any direct relationship between Providers and Clinics that we might have missed?
2. If not, is there an alternative method to identify which Clinic a Provider is associated with?

Any guidance on this would be greatly appreciated.

Thank you!

[justine]

Hello,

We are integrating Open Dental with an external system and are currently working with the Provider API. Upon reviewing both the API response and the database schema, we could not find any column or property that directly links a Provider to a ClinicNum.

Could you please confirm:
1. Is there any direct relationship between Providers and Clinics that we might have missed?
2. If not, is there an alternative method to identify which Clinic a Provider is associated with?

Any guidance on this would be greatly appreciated.

Thank you!

Hello Ummehani,

Operatories GET returns ProvDentist, ProvHygienist, and ClinicNum.

Additionally, an appointment has both a ClinicNum and ProvNum and a procedurelog has both a ClinicNum and ProvNum.

Thanks!

[Ummehani]

Thank you for your prompt response and the provided details.

To clarify, since there is no direct association between a Provider and a specific Clinic, does this imply that Providers within a single Open Dental instance can be linked to patients and appointments across multiple Clinics?

In essence, are Providers not restricted to a particular Clinic, allowing their services to extend across various Clinics within the same Open Dental system?

I would greatly appreciate your confirmation on this.

Thank you for your time and assistance.

[justine]

Thank you for your prompt response and the provided details.

To clarify, since there is no direct association between a Provider and a specific Clinic, does this imply that Providers within a single Open Dental instance can be linked to patients and appointments across multiple Clinics?

In essence, are Providers not restricted to a particular Clinic, allowing their services to extend across various Clinics within the same Open Dental system?

I would greatly appreciate your confirmation on this.

Thank you for your time and assistance.

Hello Ummehani,

You can use userods GET to return all Open Dental users. If the userod is a provider, they will have a providerNum and a clinicNum. However, providers are free to operate across clinics. Clinic context is determined by usage, not by fixed assignment.

For clinic information, see:
https://www.opendental.com/manual/clinics.html

Thanks!