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

morbidity codemorb_cd

Standardized alphanumeric identifier assigned to a specific disease condition or illness category within population health and epidemiological tracking systems. Maps to classification schemas such as ICD-10 to enable consistent cross-system identification, trending, and reporting of disease rates across member populations.

morbidity commentmorb_cmt

Free-text annotation field capturing supplemental clinical or administrative notes associated with a morbidity record. Used by clinicians or health data analysts to document contextual observations, exceptions, or clarifications that cannot be captured through structured coded fields in population health or disease management systems.

morbidity completed datemorb_cmpl_dt

Date on which a morbidity-related clinical assessment, treatment episode, or disease management intervention was formally completed. Used in population health and care management platforms to measure time-to-completion, track program adherence, and support outcome reporting for disease management initiatives.

morbidity confidential indicatormorb_conf_ind

Boolean flag designating whether a morbidity record contains sensitive health information subject to heightened privacy protections, such as behavioral health, HIV status, or substance use disorders. Controls record visibility and access restrictions in clinical and health information systems per HIPAA and applicable state privacy regulations.

morbidity countmorb_cnt

Numeric value representing the total number of morbidity occurrences, conditions, or comorbidities recorded for a patient or population cohort within a defined period. Used in population health analytics, risk scoring, and actuarial models to quantify disease burden and support clinical decision-making and resource allocation.

morbidity countrymorb_ctry

Country of origin or geographic nation associated with a reported morbidity condition, used in epidemiological surveillance and population health tracking. Supports identification of geographically linked disease patterns, travel-related illness reporting, and international public health condition monitoring within health information systems.

morbidity created bymorb_crtd_by

User identifier or system account name of the individual or automated process that initially created the morbidity record in the health information system. Used for audit trail compliance, data stewardship accountability, and traceability of record origination in population health and clinical data management workflows.

morbidity created datemorb_crtd_dt

Calendar date on which the morbidity record was first entered into the health information system. Used to establish the record's audit history, support data lineage tracking, and enable time-based analysis of disease documentation patterns within population health management and clinical data warehouse environments.

morbidity created timemorb_crtd_tm

Timestamp indicating the precise time of day at which a morbidity record was initially created in the health information system. Combined with the created date to provide a full audit trail entry, supporting data integrity reviews, system reconciliation, and chronological sequencing of disease documentation events.

morbidity creatininemorb_cr

Serum or urine creatinine laboratory value associated with a morbidity record, used as a biomarker for assessing renal function in patients with chronic kidney disease or related comorbidities. Captured in clinical data systems to support disease staging, progression monitoring, and nephrology-related morbidity tracking and reporting.

morbidity datemorb_dt

Date on which a specific morbidity condition was identified, diagnosed, or recorded for a patient. Used in population health, epidemiological surveillance, and disease management systems to establish condition onset timelines, calculate disease duration, and support time-series analysis of illness trends across patient populations.

morbidity datetimemorb_dttm

Combined date and time value marking when a morbidity event or condition was recorded or occurred. Provides precise temporal resolution for clinical event sequencing, audit compliance, and population health analytics. Used in health information systems to support time-sensitive disease tracking and longitudinal patient record analysis.

morbidity dea numbermorb_dea_nbr

Drug Enforcement Administration registration number linked to a morbidity record, typically associated with prescribers involved in treatment of the documented condition. Used in controlled substance monitoring, prescriber tracking, and compliance reporting within clinical and pharmacy data systems managing substance-related or chronic pain morbidity conditions.

morbidity death datemorb_death_dt

Date on which a patient associated with a morbidity record was confirmed deceased. Used in mortality and morbidity analyses, outcomes research, and population health reporting to measure disease-specific mortality rates, survival intervals, and the relationship between documented conditions and patient death within health information systems.

morbidity deleted datemorb_del_dt

Date on which a morbidity record was logically removed or marked inactive within the health information system. Supports soft-delete audit trails, data reconciliation processes, and regulatory compliance by preserving a historical record of when and which morbidity entries were withdrawn from active population health reporting.

morbidity deleted indicatormorb_del_ind

Boolean flag indicating whether a morbidity record has been logically deleted or deactivated in the health information system without physical removal. Enables soft-delete functionality to preserve data history for audit and compliance purposes while excluding inactive records from active population health reporting and disease tracking queries.

morbidity descriptionmorb_desc

Human-readable text label or narrative explaining the nature of the recorded morbidity condition. Provides clinical context for coded morbidity entries and is displayed in user interfaces, clinical reports, and population health dashboards to communicate disease or condition details clearly to clinicians, analysts, and care management teams.

morbidity detailmorb_dtl

Granular clinical or administrative information associated with a morbidity record that provides additional specificity beyond the primary coded diagnosis or classification. Captures nuanced condition attributes such as severity qualifiers, anatomical location, episode characteristics, or comorbidity interactions within population health and clinical data management systems.

morbidity discharge datemorb_dsch_dt

Date on which a patient was formally discharged from an inpatient or facility-based care setting in connection with a documented morbidity condition. Used in hospital outcomes reporting, readmission analysis, and population health management to measure length of stay and post-discharge disease management continuity for specific conditions.

morbidity due datemorb_due_dt

The deadline date by which a morbidity record, report, or associated action must be completed or submitted. Used in public health surveillance and disease tracking systems to enforce timely documentation and follow-up of illness or condition data within reporting workflows.

PreviousPage 389 of 806Next