Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Condition Status to CONDITION_OCCURRENCE #84

clairblacketer opened this issue Jul 13, 2017 · 1 comment

Add Condition Status to CONDITION_OCCURRENCE #84

clairblacketer opened this issue Jul 13, 2017 · 1 comment


Copy link

@clairblacketer clairblacketer commented Jul 13, 2017

Add Condition Status to Condition_Occurrence

  • Requester: OMOP-PCORnet Interoperability Collaborative (c/o Rimma Belenkaya)
  • Discussion: link to forum post

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.



  • Move condition status from Observation to Condition_Occurence table as a first class attribute. This change will eliminate the need to join Condition_Occurrence, Observation, and Fact_Relationship tables to link condition and condition status. It will also significantly simplify ETL and DQA from the source by targeting only one table rather than splitting attributes related to a condition to three tables.
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:

  • Admitting diagnosis: 4203942
  • Final diagnosis: 4230359 – should also be used for ‘Discharge diagnosis’
  • Preliminary diagnosis: 4033240

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

  • This change is an important enhancement to the model and can be implemented immediately without impacting other projects.
  • This change will have an immediate effect on three OMOP-based CDRNs: NYC-CDRN representing over 2.5 million patients; pSCANNER covering over 21 million patients; and PEDSnet which includes eight of the nation's largest children's hospitals and provides service to 4.6 million children per year.


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.


  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 added a commit that referenced this issue Jul 14, 2017
@clairblacketer clairblacketer mentioned this issue Jul 20, 2017
clairblacketer added a commit that referenced this issue Jul 27, 2017

This comment has been minimized.

Copy link
Contributor Author

@clairblacketer clairblacketer commented Jul 27, 2017

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
1 participant
You can’t perform that action at this time.