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 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?