> ## Documentation Index
> Fetch the complete documentation index at: https://docs.metriport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Condition

> Schema documentation for the Condition table in the Metriport data model

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](/medical-api/handling-data/schema-v000/reference-tables).

**Condition Table:**

**Primary Keys:**

* condition\_id

**Foreign Keys:**

* patient\_id

| Column | Data Type | Description |
| - | - | - |
| condition\_id | varchar | Unique identifier for the condition |
| patient\_id | varchar | Unique identifier for the patient |
| recorded\_date | date | Date when the condition was recorded |
| onset\_date | date | Date when the condition began |
| end\_date | date | Date when the condition ended |
| icd\_10\_cm\_code | varchar | ICD-10-CM code for the condition |
| icd\_10\_cm\_display | varchar | Human-readable description of ICD-10-CM code |
| snomed\_code | varchar | SNOMED CT code for the condition |
| snomed\_display | varchar | Human-readable description of SNOMED CT code |
| icd\_9\_cm\_code | varchar | ICD-9-CM code for the condition |
| icd\_9\_cm\_display | varchar | Human-readable description of ICD-9-CM code |
| ccsr\_code | varchar | AHRQ CCSR (Clinical Classifications Software Refined) code for the condition |
| ccsr\_display | varchar | Human-readable description of the AHRQ CCSR code |
| source\_code\_code | varchar | Original code from source system |
| source\_code\_display | varchar | Original code display from source system |
| source\_code\_system | varchar | Original code system from source system |
| category\_hl7\_code | varchar | HL7 category code for the condition |
| category\_hl7\_display | varchar | Human-readable description of HL7 category |
| source\_category\_code | varchar | Original category code from source system |
| source\_category\_display | varchar | Original category display from source system |
| source\_category\_system | varchar | Original category system from source system |
| clinical\_status\_hl7\_code | varchar | HL7 clinical status code |
| clinical\_status\_hl7\_display | varchar | Human-readable description of clinical status |
| source\_clinical\_status\_code | varchar | Original clinical status code from source system |
| source\_clinical\_status\_display | varchar | Original clinical status display from source system |
| source\_clinical\_status\_system | varchar | Original clinical status system from source system |
| note\_text | varchar | Additional notes about the condition |
| chronicity\_code | varchar | Chronicity code indicating if the condition is acute or chronic |
| hcc\_code | varchar | CMS HCC (Hierarchical Condition Category) code for risk adjustment |
| verification\_status | varchar | Verification status of the condition. Set to `unconfirmed` for algorithmic suspects |
| evidence | variant | JSON array of evidence references supporting the condition (used for suspects) |
| meta\_source | varchar | Source document filename from FHIR meta.source |
| data\_source | varchar | **Deprecated.** Use `meta_source` instead. |
| data\_source\_ext | varchar | Integration source of the data, derived from FHIR extension |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.