Data vault for multiple electronic medical records systems

Data Vault 2.0
1

Hi,

I’m trying to create a data vault for multiple source systems, every EMR system treat encounter as an example separately
EMR (1) encounter classified as specific document types or visits with specific billing codes
EMR(2) encounter table

Sources tables
1- document
2-document type
3- visit
4- visit procedure
5- encounter
In the raw vault should I create the hub from the combination of the business key of the tables knowing I will have to use reference tables to filter documents and billing codes as hard rule or should they be 3 hubs (document , visit, encounter) and classifying them will be BV issue ?
Thanks for the insights

2

mate, i think you would struggle for decent advice on here if the only context you have provided is “visit”, “encounter”, “document type” etc.

From the outset there is so much that can go wrong with your proposal