mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

comorbidity creatininecomor_cr

Serum creatinine lab value associated with a patient's coexisting medical condition, used to assess renal function as a secondary diagnosis factor. Critical for risk stratification and treatment planning when kidney impairment is a documented comorbid condition alongside a primary diagnosis.

comorbidity datecomor_dt

Calendar date on which a coexisting medical condition was diagnosed, documented, or became clinically relevant. Used in longitudinal clinical records to establish disease timelines, measure condition duration, and support comorbidity burden analysis across patient populations.

comorbidity datetimecomor_dttm

Combined date and time value marking when a coexisting medical condition was diagnosed or recorded in the clinical system. Enables precise temporal sequencing of comorbid diagnoses relative to primary conditions, procedures, and clinical interventions within a patient encounter.

comorbidity dea numbercomor_dea_nbr

Drug Enforcement Administration registration number associated with a comorbid condition record, typically linking a prescribing clinician to controlled substance orders issued in the context of managing a patient's coexisting medical condition requiring scheduled medication therapy.

comorbidity death datecomor_death_dt

Date on which a patient with a documented coexisting medical condition was recorded as deceased. Used in outcomes analysis, mortality studies, and comorbidity impact assessments to determine the clinical contribution of secondary diagnoses to patient mortality events.

comorbidity deleted datecomor_del_dt

Date on which a coexisting medical condition record was removed or voided from the active clinical dataset. Used in audit logging and data governance workflows to track when erroneous, duplicate, or resolved comorbidity entries were administratively retired from the patient record.

comorbidity deleted indicatorcomor_del_ind

Boolean flag identifying whether a coexisting medical condition record has been marked for logical deletion in the clinical data system. Allows historical comorbidity data to be retained for audit and reporting purposes while excluding voided records from active clinical workflows and patient summaries.

comorbidity descriptioncomor_desc

Free-text or standardized narrative label describing a patient's coexisting medical condition. Provides clinicians and data analysts with a human-readable representation of the comorbid diagnosis, supplementing structured diagnosis codes used in clinical documentation and claims processing.

comorbidity detailcomor_dtl

Supplementary clinical information capturing granular specifics about a patient's coexisting medical condition, such as disease severity, laterality, or progression stage. Enriches the primary comorbidity record with context that supports care coordination, risk scoring, and clinical decision-making.

comorbidity discharge datecomor_dsch_dt

Date on which a patient was released from an inpatient or facility setting where a coexisting medical condition was actively managed or documented. Used to calculate length of stay and assess the impact of comorbid diagnoses on inpatient resource utilization and discharge planning.

comorbidity due datecomor_due_dt

Target date by which a clinical action, follow-up assessment, or care milestone related to a patient's coexisting medical condition is expected to occur. Used in chronic disease management workflows to schedule monitoring visits, lab reviews, and treatment plan updates for comorbid diagnoses.

comorbidity durationcomor_dur

Calculated or recorded length of time a patient has been diagnosed with or actively managed for a coexisting medical condition. Used in risk stratification, chronic disease management, and population health analytics to assess the clinical burden and progression of long-standing comorbidities.

comorbidity emailcomor_eml

Electronic mail address associated with a clinician, care team member, or patient contact linked to the management of a documented coexisting medical condition. Used for care coordination communications, referral notifications, and follow-up correspondence related to comorbidity treatment plans.

comorbidity emergency indicatorcomor_emerg_ind

Flag identifying whether a patient's coexisting medical condition required or contributed to an emergency-level clinical intervention. Used in acuity scoring, triage documentation, and outcomes reporting to distinguish comorbidities that escalated to urgent or emergent care situations during a treatment episode.

comorbidity end datecomor_end_dt

Date marking the resolution, remission, or clinical closure of a patient's coexisting medical condition. Used in longitudinal health records to define the active period of a comorbid diagnosis, support disease burden calculations, and update problem list status in clinical documentation systems.

comorbidity end timecomor_end_tm

Precise time at which a coexisting medical condition episode was clinically closed, resolved, or documented as inactive. Used alongside comorbidity end date to provide exact temporal boundaries for condition episodes, supporting high-resolution clinical event sequencing and encounter-level reporting.

comorbidity entered bycomor_ent_by

Identifier of the clinician, coder, or data entry staff member who documented a coexisting medical condition in the clinical system. Used in audit trails to establish accountability for comorbidity records, support data quality reviews, and trace documentation back to its originating user for compliance purposes.

comorbidity ethnicitycomor_ethn

Ethnic background of a patient in the context of a documented coexisting medical condition. Used in population health analytics and health disparity research to identify differential prevalence rates, clinical outcomes, and treatment patterns across ethnic groups with specific comorbid diagnoses.

comorbidity expiration datecomor_exp_dt

Date after which a documented coexisting medical condition record is no longer considered clinically valid or active within the patient record. Used to manage time-limited diagnoses, support problem list maintenance, and ensure that expired comorbidity data is excluded from active clinical decision support rules.

comorbidity external identifiercomor_ext_id

Cross-system reference ID that links a documented comorbid condition to its corresponding record in an external clinical or administrative system, enabling consistent tracking of concurrent diagnoses across EHRs, registries, and payer platforms without duplication or misidentification.

PreviousPage 102 of 806Next