Hello everyone,
I am working on mapping the following variable:
family history of type 2 diabetes (DM2)
0 = no relative with DM2,
1 = at least 1 second degree relative with DM2 ,
2 = 1 first degree relative with DM2,
3 = 1 first degree relative and at least 1 second degree relative with DM2,
4 = 2 or more first degree relatives with DM 2
What I have thought of so far:
0 → 4334340 no family history diabetes type 2
1 → Observation_concept_id: 4051106 family history diabetes type 2
Value_concept_id: 44783070 Second degree blood relative
Value as number: 1
Qualifier value: 4172704 >
Categories 2 and 4 I could map according to the approach for category 1
However, I can not think of how to map category 1. Maybe I could split it up into two parts (“first degree relative” and “at least 1 second degree relative with DM2”) and then combine with fact_relationship? Or is it so complex that we should rather think about using the 2 billion approach?
I am very grateful for any tips and thoughts.
Thank you very much
Ivona