My database is receiving data from two data source system (A and B). We have a source_code (“21465”) coming from both data source systems, and should be mapped to two different concept (“WBC”, and “RESTRICTED PEAK ALPHA, URINE”). Both are in measurement domain.
Has anyone got into the same issue when you utilize the source_to_concept_map table for mapping?
We are thinking to adding data_source_system field at the end of the table and adding primary key to it, so that we can pick the correct mapping.