> ## 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 A clinical condition, problem, diagnosis, or other event, situation, issue, or clinical concept that has risen to a level of concern. See the [HL7 FHIR R4 spec](https://hl7.org/fhir/R4/condition.html) for full details. **Previous version:** [condition](/medical-api/handling-data/schema-v000/condition) **Tables in this resource:** * **condition** – Main condition record (this page) * [condition\_clinicalstatus\_coding](/medical-api/handling-data/schema-v100/condition/clinicalstatus_coding) * [condition\_verificationstatus\_coding](/medical-api/handling-data/schema-v100/condition/verificationstatus_coding) * [condition\_category](/medical-api/handling-data/schema-v100/condition/category) – Backbone for category; codings in condition\_category\_coding * [condition\_category\_coding](/medical-api/handling-data/schema-v100/condition/category_coding) * [condition\_code\_coding](/medical-api/handling-data/schema-v100/condition/code_coding) * [condition\_extension](/medical-api/handling-data/schema-v100/condition/extension) * [condition\_extension\_vcc\_coding](/medical-api/handling-data/schema-v100/condition/extension_vcc_coding) * **condition\_references** – Normalized references to patient, encounter, recorder; see [Reference Tables](/medical-api/handling-data/schema-v100/reference_tables) **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-v100/reference_tables). **Primary Keys:** * condition\_id **Foreign Keys:** * patient\_id – links to the [patient](/medical-api/handling-data/schema-v100/patient/base) table (subject)
† Metriport Platform added
| Column | Data Type | Description | | --------------------------------- | --------- | ------------------------------------------------------------------ | | condition\_id | varchar | Unique identifier for the condition | | patient\_id | varchar | Unique identifier for the patient | | recordeddate | datetime | Date when the condition was recorded (FHIR-compliant name) | | onsetdatetime | datetime | Onset date/time if provided directly | | onsetperiod\_start | datetime | Start of onset period | | onset\_date† | datetime | Coalesced onset date (onsetdatetime or onsetperiod\_start) | | onsetperiod\_end | datetime | End of onset period | | onsetage\_value | varchar | Onset age value | | onsetage\_unit | varchar | Unit for onset age (e.g. a for years) | | code\_text | varchar | Free-text description of the condition | | code\_icd\_10\_cm\_code† | varchar | ICD-10-CM code for the condition | | code\_icd\_10\_cm\_display† | varchar | Human-readable description of ICD-10-CM code | | code\_snomed\_code† | varchar | SNOMED CT code for the condition | | code\_snomed\_display† | varchar | Human-readable description of SNOMED CT code | | code\_icd\_9\_cm\_code† | varchar | ICD-9-CM code for the condition | | code\_icd\_9\_cm\_display† | varchar | Human-readable description of ICD-9-CM code | | code\_ccsr\_code† | varchar | AHRQ CCSR (Clinical Classifications Software Refined) code | | code\_ccsr\_display† | varchar | Human-readable description of the AHRQ CCSR code | | clinicalstatus\_text | varchar | Free-text clinical status of the condition | | clinicalstatus\_hl7\_code† | varchar | HL7 clinical status code (condition-clinical) | | clinicalstatus\_hl7\_display† | varchar | Human-readable description of clinical status | | verificationstatus\_text | varchar | Verification status text (e.g. confirmed, unconfirmed) | | verificationstatus\_hl7\_code† | varchar | HL7 verification status code (condition-ver-status) | | verificationstatus\_hl7\_display† | varchar | Human-readable description of verification status | | category\_hl7\_code† | varchar | HL7 category code (condition-category, extensible binding) | | category\_hl7\_display† | varchar | Human-readable description of HL7 category | | note\_text† | varchar | Additional notes about the condition (first note) | | 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 | | meta\_source | varchar | Source document filename from FHIR meta.source | | data\_source\_ext† | varchar | Integration source of the data, derived from FHIR extension | **Related Tables:** **Parent:** * [patient](/medical-api/handling-data/schema-v100/patient/base) **Child:** * [condition\_category](/medical-api/handling-data/schema-v100/condition/category) * [condition\_clinicalstatus\_coding](/medical-api/handling-data/schema-v100/condition/clinicalstatus_coding) * [condition\_code\_coding](/medical-api/handling-data/schema-v100/condition/code_coding) * [condition\_extension](/medical-api/handling-data/schema-v100/condition/extension) * [condition\_verificationstatus\_coding](/medical-api/handling-data/schema-v100/condition/verificationstatus_coding) * [encounter\_diagnosis](/medical-api/handling-data/schema-v100/encounter/diagnosis) ## Version diff **Renamed** * `end_date` → `onsetperiod_end` * `recorded_date` → `recordeddate` * `icd_10_cm_code` → `code_icd_10_cm_code` * `icd_10_cm_display` → `code_icd_10_cm_display` * `snomed_code` → `code_snomed_code` * `snomed_display` → `code_snomed_display` * `icd_9_cm_code` → `code_icd_9_cm_code` * `icd_9_cm_display` → `code_icd_9_cm_display` * `ccsr_code` → `code_ccsr_code` * `ccsr_display` → `code_ccsr_display` * `clinical_status_hl7_code` → `clinicalstatus_hl7_code` * `clinical_status_hl7_display` → `clinicalstatus_hl7_display` * `data_source` → `meta_source` **Moved to separate tables** * `source_clinical_status_code` → [`condition_clinicalstatus_coding.code`](/medical-api/handling-data/schema-v100/condition/clinicalstatus_coding) w/ `code_rank = 1` * `source_clinical_status_display` → [`condition_clinicalstatus_coding.display`](/medical-api/handling-data/schema-v100/condition/clinicalstatus_coding) w/ `code_rank = 1` * `source_clinical_status_system` → [`condition_clinicalstatus_coding.system`](/medical-api/handling-data/schema-v100/condition/clinicalstatus_coding) w/ `code_rank = 1` * `source_code_code` → [`condition_code_coding.code`](/medical-api/handling-data/schema-v100/condition/code_coding) w/ `code_rank = 1` * `source_code_display` → [`condition_code_coding.display`](/medical-api/handling-data/schema-v100/condition/code_coding) w/ `code_rank = 1` * `source_code_system` → [`condition_code_coding.system`](/medical-api/handling-data/schema-v100/condition/code_coding) w/ `code_rank = 1` * `source_category_code` → [`condition_category_coding.code`](/medical-api/handling-data/schema-v100/condition/category_coding) w/ `code_rank = 1` * `source_category_display` → [`condition_category_coding.display`](/medical-api/handling-data/schema-v100/condition/category_coding) w/ `code_rank = 1` * `source_category_system` → [`condition_category_coding.system`](/medical-api/handling-data/schema-v100/condition/category_coding) w/ `code_rank = 1`