Multiple Addresses per Provider, Provider Address differs from Care Site

[Gowtham_Rao]

Hi

@ericaVoss

In situations where a provider has multiple addresses the ETL should choose the best one.

Based on the CDM, provider is at a care_site_id (provider table does not have location_id), care_site_id is at a location_id. So, I think this must be re-worded as ‘providers with multiple care_sites, the ETL should choose the best one’.

Although, I think this convention is inherently limiting – because majority of the time a provider_id will have more than one care_site_id.

@ericaVoss

If a Provider has more than one Specialty, the main or most often exerted specialty should be recorded.

This probably needs to be updated with more specifics - considering the updates to specialty that @Christian_Reich is introducing - along with hierarchy.

@ericaVoss

One visit may involve multiple care sites, in which case the ETL must specify how a single CARE_SITE_ID is selected or leave the CARE_SITE_ID field null.

This is where I would advocate for visit_detail. We probably can capture the multiple care_sites within the same visit_occurrence_id as a separate record in visit_detail. I made a similar argument here in favor of using the visit_detail.