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 for full details. Previous version: condition Tables in this resource:

condition – Main condition record (this page)
condition_clinicalstatus_coding
condition_verificationstatus_coding
condition_category – Backbone for category; codings in condition_category_coding
condition_category_coding
condition_code_coding
condition_extension
condition_extension_vcc_coding
condition_references – Normalized references to patient, encounter, recorder; see 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. Primary Keys:

condition_id

Foreign Keys:

patient_id – links to the patient 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

Child:

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 w/ code_rank = 1
source_clinical_status_display → condition_clinicalstatus_coding.display w/ code_rank = 1
source_clinical_status_system → condition_clinicalstatus_coding.system w/ code_rank = 1
source_code_code → condition_code_coding.code w/ code_rank = 1
source_code_display → condition_code_coding.display w/ code_rank = 1
source_code_system → condition_code_coding.system w/ code_rank = 1
source_category_code → condition_category_coding.code w/ code_rank = 1
source_category_display → condition_category_coding.display w/ code_rank = 1
source_category_system → condition_category_coding.system w/ code_rank = 1

Getting Started

API Reference

Handling Data

FHIR

API Tools

More Info

Legacy API Reference

Version diff

​Version diff

Version diff