The first question is always do you have a reason, ‘use case’, to link each team member to a specific procedure. Assuming that you do have a use case, use the fact_relationship table. In one direction, domain_id_1 will be ‘Procedure’, fact_id_1 the procedure record id, domain_id_2 will be ‘Provider’ and fact_id_2 the provider_id. Create a record for each procedure provider. You will probably have to create a custom concept for the relationship_concept_id. Custom concepts are added to the concept table with a concept_id greater then two billion.
As for the provider_id in the procedure records, decide on a scheme to determine the ‘primary’ provider. From your example it would probably be the main surgeon.
2 Likes