Recently a THEMIS issue that has come up is what to do when a provider has multiple addresses. For example, provider works at multiple facilities. Additionally, mixed with this question is what happens if there are multiple locations associated with care (e.g. provider address and provider location).
THEMIS #48 - under review for THEMIS V2.0.0.
Here is our initial recommendation:
The CDM allows us to capture location of visits, so knowing where a patient was treated is quantified in the CDM. If a provider has multiple addresses the ETL should just choose one as it is unknown what the analytical use case for storing multiple addresses per provider.
The question of how to handle a situation where the billing address differs from where the patient received care is already handled in the CDM. The VISIT_OCCURRENCE table has a separate PROVIDER_ID and CARE_SITE_ID for expressly this purpose. This is already handled with Convention #8 on the VISIT_OCCURRENCE page (https://github.com/OHDSI/CommonDataModel/wiki/VISIT_OCCURRENCE).
Update Convention #3 under PROVIDER.
A single Provider cannot be listed twice (be duplicated) in the table. In situations where a provider has multiple addresses the ETL should choose the best one. If a Provider has more than one Specialty, the main or most often exerted specialty should be recorded.
Update Conventions #8 under VISIT_OCCURRENCE:
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. When the address of the provider and site of care differ you can use the CARE_SITE_ID to capture location of care and PROVIDER_ID to capture provider office.