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

mortality onset datemort_onset_dt

The date on which symptoms, conditions, or clinical events began that ultimately contributed to a patient's death. Used in clinical outcomes analysis to calculate disease progression timelines, survival intervals, and cause-of-death attribution in mortality surveillance and epidemiological reporting systems.

mortality oxygen saturationmort_o2sat

The recorded blood oxygen saturation level (SpO2 or SaO2) measured at or near the time of a patient's death. Used in clinical mortality analysis to document terminal physiological status, support cause-of-death determination, and inform quality metrics around respiratory failure and end-of-life care.

mortality paid amountmort_pd_amt

The total dollar amount paid by a payer for claims associated with a patient's terminal episode of care. Used in claims analysis to quantify end-of-life expenditures, benchmark mortality-related costs, and support actuarial and population health cost modeling across member populations.

mortality paid datemort_pd_dt

The date on which a claim or claims associated with a patient's terminal episode of care were adjudicated and paid by the health plan. Used in claims processing and financial reporting to reconcile mortality-related expenditures and measure the lag between death event and final claim settlement.

mortality parentmort_prnt

The hierarchical parent entity or record to which a mortality record is linked, such as a parent encounter, episode of care, or reporting group. Used in clinical data warehouses to support hierarchical mortality reporting, aggregate death events, and maintain relational integrity across nested data structures.

mortality percentagemort_pct

The calculated proportion of deaths relative to a defined population or patient cohort, expressed as a percentage. Used in population health, quality reporting, and public health surveillance to benchmark mortality outcomes across care settings, diagnoses, demographic groups, and time periods.

mortality periodmort_prd

The defined time interval over which mortality events are measured, aggregated, or reported, such as a calendar year, fiscal quarter, or clinical reporting cycle. Used in outcomes analysis and quality programs to establish consistent measurement windows for comparing death rates across populations and facilities.

mortality phonemort_ph

The telephone contact number associated with an entity linked to a mortality record, such as a reporting facility, medical examiner's office, or next-of-kin contact. Used in mortality case management and vital statistics workflows to facilitate follow-up, verification, and death certificate processing.

mortality preferred namemort_pref_nm

The standardized or preferred human-readable label assigned to a mortality measure, classification, or reporting category. Used in dashboards, quality reports, and clinical analytics to ensure consistent, user-friendly display of mortality metrics across reporting tools and data visualization platforms.

mortality pricemort_prc

The billed or contracted cost associated with services rendered during a patient's terminal episode of care. Used in financial and actuarial analysis to evaluate end-of-life care expenditures, assess pricing relative to mortality outcomes, and support cost-effectiveness studies in clinical and claims data environments.

mortality primary indicatormort_prim_ind

A flag designating whether a recorded death represents the primary mortality event in cases where multiple mortality records exist for a patient or reporting group. Used in clinical data warehouses to prevent duplicate counting of deaths and ensure accurate mortality statistics in outcomes and quality reporting.

mortality prioritymort_prty

A ranking or classification indicating the urgency or precedence assigned to a mortality case within clinical review, quality improvement, or public health investigation workflows. Used to triage mortality reviews, allocate audit resources, and prioritize follow-up actions in patient safety and mortality surveillance programs.

mortality procedure datemort_proc_dt

The date on which a clinical procedure was performed that is associated with or preceded a patient's death. Used in mortality case review and claims analysis to establish temporal relationships between interventions and death events, supporting root cause analysis and surgical or procedural mortality reporting.

mortality pulsemort_pulse

The recorded heart rate measurement captured at or near the time of a patient's death. Used in clinical mortality documentation to establish physiological status at end of life, support cause-of-death determination, and provide vital sign data for terminal episode review in clinical outcomes analysis.

mortality quantitymort_qty

The total count of death events recorded within a defined population, time period, facility, or clinical grouping. Used in mortality surveillance, quality measurement, and population health reporting to quantify the volume of deaths and support rate calculations, trending, and benchmarking across cohorts.

mortality racemort_race

The self-reported or administratively recorded racial classification of a deceased individual. Used in public health surveillance, health equity analysis, and epidemiological reporting to identify disparities in mortality rates across racial groups and inform targeted interventions and population health strategies.

mortality rangemort_rng

The defined minimum and maximum boundary values for a mortality rate or measure within a specific population, risk group, or reporting benchmark. Used in quality analytics and outcomes reporting to establish acceptable performance thresholds and flag statistical outliers in mortality surveillance programs.

mortality ratemort_rt

The calculated frequency of death events within a defined population over a specified time period, typically expressed as deaths per 1,000 or 100,000 individuals. Used in epidemiological surveillance, quality measurement, and actuarial analysis to assess population health outcomes and compare performance across facilities or cohorts.

mortality ratingmort_rtg

A scored or categorical assessment assigned to a mortality event, facility, or population based on defined clinical, quality, or risk criteria. Used in accreditation, quality improvement programs, and risk stratification models to evaluate and compare mortality outcomes and identify areas requiring clinical performance intervention.

mortality ratiomort_ratio

The calculated proportional relationship between observed and expected deaths within a defined patient population or cohort. Used in quality reporting and population health analytics to benchmark actual mortality against predicted rates based on clinical risk factors and case mix.

PreviousPage 399 of 806Next