Skip to main content
A condition is used to record detailed information about a condition, problem, diagnosis, or other event, situation, issue, or clinical concept that has risen to a level of concern. The condition could be a point in time diagnosis in context of an encounter, it could be an item on the practitioner’s Problem List, or it could be a concern that doesn’t exist on the practitioner’s Problem List. Often times, a condition is about a clinician’s assessment and assertion of a particular aspect of a patient’s state of health. It can be used to record information about a disease/illness identified from application of clinical reasoning over the pathologic and pathophysiologic findings (diagnosis), or identification of health issues/situations that a practitioner considers harmful, potentially harmful and may be investigated and managed (problem), or other health issue/situation that may require ongoing monitoring and/or management (health issue/concern). Reference Table: The condition_references table contains normalized references from the condition to other entities. It supports the following reference properties:
  • subject (required): links to the patient who has the condition
  • encounter: links to the encounter where the condition was recorded
  • recorder: links to the practitioner who recorded the condition
For detailed information about reference table structure and indexing, see the Reference Tables documentation. Condition Table: Primary Keys:
  • condition_id
Foreign Keys:
  • patient_id
ColumnData TypeDescription
condition_idvarcharUnique identifier for the condition
patient_idvarcharUnique identifier for the patient
recorded_datedateDate when the condition was recorded
onset_datedateDate when the condition began
end_datedateDate when the condition ended
icd_10_cm_codevarcharICD-10-CM code for the condition
icd_10_cm_displayvarcharHuman-readable description of ICD-10-CM code
snomed_codevarcharSNOMED CT code for the condition
snomed_displayvarcharHuman-readable description of SNOMED CT code
icd_9_cm_codevarcharICD-9-CM code for the condition
icd_9_cm_displayvarcharHuman-readable description of ICD-9-CM code
category_hl7_codevarcharHL7 category code for the condition
category_hl7_displayvarcharHuman-readable description of HL7 category
source_category_codevarcharOriginal category code from source system
source_category_displayvarcharOriginal category display from source system
source_category_systemvarcharOriginal category system from source system
clinical_status_hl7_codevarcharHL7 clinical status code
clinical_status_hl7_displayvarcharHuman-readable description of clinical status
source_clinical_status_codevarcharOriginal clinical status code from source system
source_clinical_status_displayvarcharOriginal clinical status display from source system
source_clinical_status_systemvarcharOriginal clinical status system from source system
note_textvarcharAdditional notes about the condition
data_sourcevarcharSource of the condition data