Capturing more than one care_site_id or provider_id per visit_occurrence

[jenniferduryea (Jen Duryea)]

We have also discussed the visits vs. encounters (micro-visits) in this thread here:

Definition of Visit, transfers and referrals, and distinction of ER from hospital visits

Friends: Transferring a discussion from the CDM working group here: @rimma said: Hi @zwbutt : Could you please elaborate your concerns about the current proposal? It seems to me that we are on the same page, but I may be wrong. @Christian_Reich said: I think you are on the same page. I am the one who is trying to avoid these claim-based or encounter-based approaches. I was thinking that each exposure of a patient to an organizational unit providing care is a visit. So, those units would…

We create encounters (or micro-visits) using the visit_occurrence table to capture the granularity of multiple providers and care_sites. The only downside I see is that the number of visits looks inflated when using OHDSI tools. But we just interpret visits as “encounters”. Just another ETL option you might want to consider.