Hello,
In our source data, we have multiple specialities for a given provider. Seeing as how the PROVIDER_ID column is meant to be unique in the PROVIDER table, what is the best approach to store the multiple entries for each clinician? I thought of using the OBSERVATION table. However that is used for patients generally. How about the FACT_RELATIONSHIP table to indicate the secondary specialities for each provider? Anyone have useful suggestions?
Regards,
Vimala