OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
880 stars 450 forks source link

Add Condition Status to CONDITION_OCCURRENCE #84

Closed clairblacketer closed 7 years ago

clairblacketer commented 7 years ago

Add Condition Status to Condition_Occurrence

Condition status reflects point of care at which the condition was diagnosed: Admitting, Preliminary, Discharge/Final. Presently, Condition status is stored in the Observation table and linked to Condition_Occurrence table via Fact_Relationship.


Proposal

Relevant table: CONDITION_OCCURRENCE

Field Required Type Description
CONDITION_STATUS_CONCEPT_ID Integer No A foreign key to the predefined concept in the standard vocabulary reflecting the condition status.
CONDITION_STATUS_SOURCE_VALUE Varchar(50) No The source code for the condition status as it appears in the source data.

Presently, there is no designated vocabulary, domain, or class that represents condition status. The following concepts from SNOMED are recommended:

These concepts can be grouped into a new designated class “Condition status”.

Use Cases

Diagnosis discrepancy on admission may be a marker of diagnosis uncertainty or poor patient assessment/documentation. Research is needed to understand the underlying reasons for this discrepancy and its association with LOS, and, potentially, clinical outcomes. 1

Admitting and discharge diagnoses may differ as a result of patient complexity, diagnostic dilemmas, or errors in clinical judgment at the time of primary assessment. When diagnoses at admission and discharge are not in agreement, this discrepancy may indicate more complex processes of care and resultant costs. Diagnosis discrepancy maybe associated with hospital quality outcome measures. 2

Importance, also with respect to other projects

Consequences

This change will enhance representation and analysis of condition status in OMOP CDM and simplify ETL for the sites that are presently using Observation and Fact_Relationship tables. It will have no implications on vocabulary or existing software.

References

  1. Tricia Johnson, ea. Discrepancy between admission and discharge diagnoses as a predictor of hospital length of stay. Journal of Hospital Medicine. Apr 22, 2009.
  2. McNutt R, ea. Cost and quality implications of discrepancies between admitting and discharge diagnoses. Qual Manag Health Care. 2012 Oct-Dec
clairblacketer commented 7 years ago

Closing this proposal as it was added to CDM v5.2