Convention for patients "still in hospital"
@clairblacketer 已经在做这个了。
开始于 2024年5月2日。
评估
这个 Issue 还没有评估数据。
描述
Convention for patients "still in hospital"
CDM or THEMIS convention?
THEMIS
Table or Field level?
Field
Is this a general convention?
No
Summary of issues
- If patients are still in the hospital at the time of the ETL build, set the visit_end_date to the date of the data extract and set the discharge_to_concept_id to 32220.
Summary of answer
Author 1:
- We updated the
visit_occurrence.end_date, visit_occurrence.end_datetime, visit_detail.visit_detail_end_date, and visit_detail.visit_detail_end_datetimeUser Guide sections to direct users to set the visit_end_datetime to the date of the data extract when an inpatient visit is ongoing and the *.discharged_to_concept_id = 0. - We updated the
visit_occurrence.discharged_to_concept_idandvisit_detail.discharged_to_concept_idETL Conventions sections to notify users it is assumed a Person returns home after a Visit, therefore, there is not a standard concept_id to represent 'home' and set the discharged_to_concept_id = 0
Author 2
We should update this user guidance, as some things have changed.
Concept 32220 - Still Patient is non-standard, and the advice in the user guide for visit_end_date is to add this as the visit_type_concept_id, not discharge_concept_id.
For Inpatient Visits ongoing at the date of ETL, put date of processing the data into visit_end_datetime and visit_type_concept_id with 32220 “Still patient” to identify the visit as incomplete.
This is now conflicting with our conventions for type concepts to be standard and of class 'Type Concept'.
Author 3:
- THEMIS issue and still needs consensus on how patients till in the hospital should be handled.
Related links
Other comments/notes
- Please use this section to add any other relevant notes or comments. (i.e. if links are not working, something is out of date or deprecated)
- 主要语言
- HTML
- 星标
- 1.1k
- 派生
- 513
- 平均合并
- 8 天 3 小时
- 30 天内合并 PR
- 4
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
OHDSI/CommonDataModel 的其他 Issue
-
难度 1/5 1 小时以内 新手友好度 74/100
OHDSI/CommonDataModel#802 · 1 条评论 ·
-
难度 2/5 1-3 小时 新手友好度 72/100
OHDSI/CommonDataModel#799 ·
-
fix: mark cohort_definition_id as primary key in cohort_definition table for v5.3 and v5.4可能已有人在做 @rtmalikian 于 138 天前认领。 未关闭
难度 2/5 1-3 小时 新手友好度 82/100
OHDSI/CommonDataModel#787 ·
-
难度 2/5 1-3 小时 新手友好度 65/100
OHDSI/CommonDataModel#784 ·
-
难度 3/5 1-2 天 新手友好度 55/100
OHDSI/CommonDataModel#823 ·