As it stands, the definition of a “visit” for our site is a unique combination of person, date, care site, and visit type concept. We leave provider null in the visit_occurrence table since there is often times many providers per visit and no way to determine which one to pick. To get around this we have tossed around the idea of linking visits to providers using the fact relationship table, however I’m not finding an appropriate relationship_concept_id and domain_concept_id for this. Any suggestions?
If you have a provider that is primarily involved in a visit (treating physician) you can capture that. It makes sense for outpatient visits. But if there is more than one, performing different aspects of the care provided (counseling, surgery, imaging etc.) link them to the appropriate PROCEDURE record.
So, don’t stress. Leave that field empty if it cannot be filled unambiguously.
Will do, thanks for the reply!