OHDSI Home | Forums | Wiki | Github

Provider group-patient relationship

Hi team,
Providers are in different specialties and groups. For example, PCP, Internal Medicine, Surgeon… My question is: how to find the relationship between provider group and patient? For example patients visit PCP.

What do you mean by “relationship”? The patients have visits, conditions, procedures, etc. Each of them can have a link to a provider. The provider record has a specialty_concept_id field.

Is that it?

It is very helpful. Thanks!