search

outcomesinsights / generalized_data_model

Outcomes Insights' Data Model for Clinical Research
MIT License
16 stars 3 forks source link

Consider how to add a family group to patients #103

Closed marc-outins closed 7 years ago

marc-outins commented 7 years ago

There are instances where patients are grouped, most likely by a family id as is the case with CPRD. There are a couple of ways to handle this:

  1. Add family_id_source_value variable to patients table that is the source value from the source data
  2. Add family_id to patients table and add families table to GDM
  3. Add the family id to the patient_details table somehow. Currently that table expects a vocabulary associated with the detail we are adding so it seems weird to create a CPRD family vocab
marc-outins commented 7 years ago

Will use LOINC code 74024-1 Family member identifier for concept_id and vocabulary and enter the family identifier as the source value