Apparently, we never got around to mapping the units for lab results we get out of Epic Clarity. I have a whole list of units that need to get mapped so we can populate unit_concept_id, but I’m not sure how best to do it, other than manually, which I’d like to avoid if at all possible. I tried using Usagi, but it attempted to map to some concepts that were totally off base. I can’t join to CONCEPT on vocabulary_id = ‘UCUM’ and concept_code = [source_unit_value] because the formats don’t match.
Does anyone have any relevant experience mapping units, especially from Epic? Any approaches that worked for the community would be great to hear about.