Hi Anna
In a lot of cases, the terms don’t “match” but they do have the same meaning. I REALLY like the idea of storing information about the precision of the match.
To answer your clarification questions: Our vocabulary is robust and covers about anything you’d find in a clinical setting. There is quite a bit of internal structure. Again, the full gamut. Ancestor/descendent, categorization, clustering, and probably things I don’t even know about yet.
I think I might have abbreviated my question too much, so I hope you’ll bear with a more verbose version of it.
We’re doing a pilot with a very limited scope just to get the mechanics down. We’re focusing on simply vital signs measurements. We want to only bring things in as we need them. We want to preserve our internal concept IDs as *_source_id. The idea is that as our usecases evolve we can take advantage of our additional structures. (This is probably a topic of its own.)
To illustrate my question as simply as possible: I’m bringing in a height measurement of a person. Our source record references a measurement concept from our vocabulary:
code: C9876 (our internal code)
name: Average Height
preferred name: Height Averaged
mapped to: LOINC 8308-9
We want our OMOP measurement record to reference a standard measurement concept.
concept_id: 3015514
concept_name: Body height --standing
vocabulary_id: LOINC
concept_code: 8308-9
standard_concept: S
My (maybe naive) approach would be to create a new concept in the OMOP vocab for our concept [C9876], and then map it to the standard concept [3015514] (we’d use the LOINC code to find the standard concept.)
Then the measurement record in OMOP would have:
measurement_concept_id: 3015514 (the “standard” concept)
measurement_source_concept_id: (our newly created concept representing the height measurement from our vocabulary)
Phew. If that’s a valid approach, I’d like to capture as much info as I can from our original concept. For example, the preferred name as a synonym? That was my original question, but it’s probably a deeper question. As we get more sophisticated with our usecases, should we capture other more robust elements of that concept (e.g. categorizations, ancestors, etc.) within the OMOP vocabulary? Are others doing similarly?
Hope that wasn’t TL;DR.