We are working with EHR data, where one patient can visit multiple care sites and each care site maintains his record as a different patient ID.
We also have a linkage table that indicates this linkage information.
So, in our data-set each patient has multiple care sites and his records are specific to that care site.
My first question is, how do I map this patient in PERSON table? As according to wiki and Themis discussion there can be only one unique record per patient.
My second question is, Since he visits multiple care sites which one should I choose as CARE_SITE_ID?
Can someone help me with this? How do you handle this in case of your data-set?