We tackled this pre-Themis. However, many questions remain and the collective "we" need to give input and clarify conventions with the Themis WG. Some questions I have re: the lifestyle/social history domain:
- There are multiple, standard concepts for alcohol drinker. Which ones should we use?
- If you have more granular data (start and quit dates, amounts consumed, type consumed, etc.), where should it go? And how do you capture all the data in the CDM?
- There are multiple classes and multiple domains for other lifestyle/social history concepts. How do we reconcile?
You should join the WG More points of view will make the conventions more robust!
Below is our current implementation:
We create a concept in the Concept table, then create a relationship to a standard concept in the Concept Relationship table.
Our EHR data does not have a source "code" attached to lifestyle/social history data elements. So, I took the field "alcohol use" and then the individual values "yes", "no" and concatenated the two. The result "AlcoholUse:Yes" is our concept_name and our concept_code. Our data in the Concept table looks like this:
The record for the mapping resides in the Concept Relationship table:
concept_id = 45766930 = Admits alcohol use