I am working on a project where one of the data sources is salesforce’s health care offering, health cloud.
It seems to rather awkwardly take standard salesforce objects and forces them into a healthcare context.
- Lead - Referral
- Account - Converted Referral (Patient)
- Contact - basically very similar to account
There are very similar descriptions of the same thing, an individual. I’m not sure how I model this as a hub. In my mind there is an individual hub with three satellites representing the lead, account, and contact. However, I also need to be careful that I don’t lump in any event changes into satellites, since they are just there to describe the individuals attributes in different contexts. Am I correct in my thinking?
Tldr: duplicate attributes across tables, tables effectively representing the same thing in different stages contexts. Internal and external business keys to describe an individual.