We are going to load data from several EMR sources, however, I could not find a way to track the source system (name) in any on OMOP tables . For example, having system 1 and system 2 that both use ICD10 for diagnoses. How do we track that a specific record came from System 1 or system 2?
@yguilarte
The information about the source can be stored in CDM_SOURCE table https://github.com/OHDSI/commondatamodel/wiki/CDM_SOURCE
But I don’t think this can solve your problem.
Usually, we do not mix up the CDM from multiple institutions. We develop CDM data for each institution in independent database.
You could put the information in the condition_source_value column. But as @scyou said, many keep different sources in separate CDMs, especially if they contain the same data.