Page 1 of 1
Clarification on Provider and Clinic Relationship in Open Dental
Posted: Mon Mar 24, 2025 4:42 am
by 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!
Re: Clarification on Provider and Clinic Relationship in Open Dental
Posted: Mon Mar 24, 2025 10:56 am
by justine
Ummehani wrote: ↑Mon Mar 24, 2025 4:42 am
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!
Re: Clarification on Provider and Clinic Relationship in Open Dental
Posted: Tue Mar 25, 2025 3:25 am
by 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.
Re: Clarification on Provider and Clinic Relationship in Open Dental
Posted: Tue Mar 25, 2025 9:10 am
by justine
Ummehani wrote: ↑Tue Mar 25, 2025 3:25 am
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!