Skip to main content
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: 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
ColumnData TypeDescription
condition_idvarcharUnique identifier for the condition
patient_idvarcharUnique identifier for the patient
recordeddatedatetimeDate when the condition was recorded (FHIR-compliant name)
onsetdatetimedatetimeOnset date/time if provided directly
onsetperiod_startdatetimeStart of onset period
onset_date†datetimeCoalesced onset date (onsetdatetime or onsetperiod_start)
onsetperiod_enddatetimeEnd of onset period
onsetage_valuevarcharOnset age value
onsetage_unitvarcharUnit for onset age (e.g. a for years)
code_textvarcharFree-text description of the condition
code_icd_10_cm_code†varcharICD-10-CM code for the condition
code_icd_10_cm_display†varcharHuman-readable description of ICD-10-CM code
code_snomed_code†varcharSNOMED CT code for the condition
code_snomed_display†varcharHuman-readable description of SNOMED CT code
code_icd_9_cm_code†varcharICD-9-CM code for the condition
code_icd_9_cm_display†varcharHuman-readable description of ICD-9-CM code
code_ccsr_code†varcharAHRQ CCSR (Clinical Classifications Software Refined) code
code_ccsr_display†varcharHuman-readable description of the AHRQ CCSR code
clinicalstatus_textvarcharFree-text clinical status of the condition
clinicalstatus_hl7_code†varcharHL7 clinical status code (condition-clinical)
clinicalstatus_hl7_display†varcharHuman-readable description of clinical status
verificationstatus_textvarcharVerification status text (e.g. confirmed, unconfirmed)
verificationstatus_hl7_code†varcharHL7 verification status code (condition-ver-status)
verificationstatus_hl7_display†varcharHuman-readable description of verification status
category_hl7_code†varcharHL7 category code (condition-category, extensible binding)
category_hl7_display†varcharHuman-readable description of HL7 category
note_text†varcharAdditional notes about the condition (first note)
chronicity_codevarcharChronicity code indicating if the condition is acute or chronic
hcc_codevarcharCMS HCC (Hierarchical Condition Category) code for risk adjustment
meta_sourcevarcharSource document filename from FHIR meta.source
data_source_ext†varcharIntegration source of the data, derived from FHIR extension
Related Tables: Parent: 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