How to store family history in the OBSERVATION table

未关闭
#656 4 条评论 0 个 reaction 已指派 1 人 在 GitHub 查看

@MelaniePhilofsky 已经在做这个了。

开始于 2024年4月16日。

评估

这个 Issue 还没有评估数据。

描述

Documentation

How to store family history in the OBSERVATION table

CDM or THEMIS convention?

CDM

Table or Field level?

Table

Is this a general convention?

No

Summary of issues

  1. If these is an established best practice for representing family history in the OBSERVATION table? There seems 2 options for this family history.
    Image

Summary of answer

  1. Melanie https://forums.ohdsi.org/t/how-to-represent-family-history/3386/45
    There are 2 ways: The first is the OBSERVATION.observation_concept_id = 4210989 (Family history with explicit context) and the disease/condition is found in the OBSERVATION.value_as_concept_id = 317009 (Asthma).
    Or the data might be the pre-coordinated with 4051241 (Family history of asthma).

  2. Erica Voss https://forums.ohdsi.org/t/how-to-represent-family-history/3386/9
    RECOMMENDATION:
    If we have a matching concept in SNOMED, then use the respective observation_ concept_id.
    If we do NOT have a matching SNOMED code, then observation_concept_id should be ‘4210989 Family history with explicit context’ and value_as_concept_id should be the related procedure, condition etc.

ACTION:
Add as a convention under the OBSERVATION page.

  1. Alexander Davydov https://forums.ohdsi.org/t/how-to-represent-family-history/3386/47
    Be careful with the 4210989 (Family history with explicit context). One of the descendant branch is 4051104 (No family history of). So when you pick the top-level guy you don't actually say whether it's happened or not.
    So it's better to pick more specific, e.g. 4167217 (Family history of clinical finding) or 4051255 (Family history with explicit context pertaining to mother).

Related links

OHDSI Forum: https://forums.ohdsi.org/t/how-to-represent-family-history/3386

Other comments/notes

From my side, I prefer to

  1. Firstly, use specific observation domain standard concept which represent the family history directly, e.g. 4051241 (Family history of asthma).
  2. Secondly, if I cannot find a specific standard concept directly, then use 4167217 (Family history of clinical finding) as OBSERVATION.observation_concept_id and 317009 as OBSERVATION.value_as_concept_id.

We have ETL Conversion projects in our organization. I used this logic for our OMOP CDM database. Yang, Qi is my colleague. I also discussed this logic with him before.

@MelaniePhilofsky, @clairblacketer, I am not sure if there is a convention on Family history data now.
According to the discussion in this OHDSI Forum post, Melanie suggested the logic for how to store family history into OBSERVATION table. But is there any order for which way should be first? And if it is a good choice to replace 4210989 (Family history with explicit context) with 4167217 (Family history of clinical finding)?

主要语言
HTML
星标
1.1k
派生
515
平均合并
10 天 13 小时
30 天内合并 PR
3

环境准备

这个项目没有提供开发容器、Dockerfile 或贡献指南,环境需要你自己搭建:先看它的 README,通用步骤见我们的新手贡献指南。

从这里开始

  1. 先读完整个 Issue,再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库,在一个分支上完成修改。
  4. 提交 Pull Request,并在描述里引用这个 Issue 编号。

OHDSI/CommonDataModel 的其他 Issue

查看 OHDSI/CommonDataModel 的全部 Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。