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
ccsr_codevarcharAHRQ CCSR (Clinical Classifications Software Refined) code for the condition
ccsr_displayvarcharHuman-readable description of the AHRQ CCSR code
source_code_codevarcharOriginal code from source system
source_code_displayvarcharOriginal code display from source system
source_code_systemvarcharOriginal code system from source system
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
chronicity_codevarcharChronicity code indicating if the condition is acute or chronic
hcc_codevarcharCMS HCC (Hierarchical Condition Category) code for risk adjustment
verification_statusvarcharVerification status of the condition. Set to unconfirmed for algorithmic suspects
evidencevariantJSON array of evidence references supporting the condition (used for suspects)
meta_sourcevarcharSource document filename from FHIR meta.source
data_sourcevarcharDeprecated. Use meta_source instead.
data_source_extvarcharIntegration source of the data, derived from FHIR extension