# Data vault for multiple electronic medical records systems
**URL:** https://forum.data-community.org/t/data-vault-for-multiple-electronic-medical-records-systems/1323
**Category:** Data Vault 2.0
**Created:** [May 27, 2024, 1:33pm UTC](https://forum.data-community.org/t/data-vault-for-multiple-electronic-medical-records-systems/1323 "2024-05-27T13:33:27Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Amro](https://forum.data-community.org/u/Amro)
#### Post date: [May 27, 2024, 1:33pm UTC](https://forum.data-community.org/t/data-vault-for-multiple-electronic-medical-records-systems/1323/1 "2024-05-27T13:33:27Z")
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
---
### Author:  [@patrickcuba](https://forum.data-community.org/u/patrickcuba)
#### Post date: [July 8, 2024, 2:00am UTC](https://forum.data-community.org/t/data-vault-for-multiple-electronic-medical-records-systems/1323/2 "2024-07-08T02:00:32Z")
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