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 admission datemort_admn_dt

Records the inpatient admission date for a patient who subsequently died during a hospital stay. Used in clinical quality measures and outcomes reporting to calculate length of stay prior to death, identify in-hospital mortality patterns, and support risk-adjusted mortality benchmarking across facilities.

mortality agemort_age

Captures the patient's age at time of death, typically in years, for use in mortality analytics and population health reporting. Enables stratification of death rates by age cohort, supporting epidemiological studies, actuarial analysis, and clinical quality improvement initiatives targeting age-specific mortality risks.

mortality allowed amountmort_alwd_amt

Represents the maximum reimbursable amount approved by a payer for services rendered to a patient who subsequently died. Used in claims-based mortality studies to analyze healthcare expenditures associated with end-of-life care and assess cost patterns among decedent populations across payer types.

mortality amountmort_amt

Records a monetary value associated with a mortality-related transaction, such as a claim or encounter for a deceased patient. Used in financial and actuarial analyses to quantify total healthcare spending associated with patient deaths, supporting cost-of-care studies and end-of-life resource utilization reviews.

mortality approved bymort_appr_by

Identifies the clinician, administrator, or system user who authorized or validated a mortality record within a clinical data system. Supports audit trail requirements, data governance compliance, and quality review workflows where mortality determinations require formal sign-off before inclusion in outcomes reporting.

mortality arrival timemort_arrv_tm

Records the exact time a patient arrived at a care facility prior to or at the time of death. Used in emergency department and inpatient mortality analyses to calculate time-to-event metrics, assess door-to-death intervals, and evaluate timeliness of care for patients who did not survive their encounter.

mortality arrived datemort_arrv_dt

Captures the calendar date on which a patient arrived at a healthcare facility for the encounter that resulted in death. Used alongside admission and death date fields to calculate care timelines, support mortality surveillance, and enable retrospective analysis of clinical events leading to patient death.

mortality assessmentmort_asmt

Contains the clinical evaluation narrative or structured findings documented for a patient at risk of or having experienced death. Used in mortality review committees, morbidity and mortality conferences, and quality improvement programs to document clinician judgments about cause, preventability, and circumstances of patient death.

mortality balancemort_bal

Represents the outstanding financial balance remaining on accounts associated with a deceased patient's care episode. Used in revenue cycle management to track unpaid amounts for decedent claims, coordinate estate billing processes, and report on unresolved financial obligations following patient death.

mortality billed amountmort_bill_amt

Records the total charges submitted by a healthcare facility or clinician on claims associated with a patient who died. Used in claims-based mortality research to quantify end-of-life care costs, compare billed versus allowed amounts for decedent populations, and support actuarial and health economics analyses.

mortality birth datemort_birth_dt

Stores the patient's date of birth linked to a mortality record, enabling calculation of age at death and lifespan metrics. Used in demographic mortality analyses, life expectancy reporting, epidemiological studies, and actuarial modeling to stratify death rates across birth cohorts and demographic populations.

mortality blood pressuremort_bp

Records the systolic and diastolic arterial pressure measurements documented for a patient at or near the time of death. Used in clinical mortality reviews to assess hemodynamic status during terminal events, identify cardiovascular contributors to death, and support cause-of-death determinations in inpatient quality reporting.

mortality cancelled datemort_cncl_dt

Captures the date on which a mortality record, review, or associated event was cancelled or voided within a clinical data system. Used in data governance and audit workflows to track record corrections, withdrawn mortality determinations, or cancelled mortality review proceedings that affect outcomes reporting accuracy.

mortality categorymort_cat

Classifies a patient death into a defined grouping such as in-hospital, post-discharge, preventable, or disease-specific mortality. Used in population health management, quality measurement, and public health reporting to segment death events for trend analysis, benchmarking, and targeted clinical intervention program development.

mortality chief complaintmort_cc

Documents the primary symptom or presenting condition reported by or on behalf of a patient who subsequently died. Used in mortality cause analysis and emergency care quality reviews to identify presenting complaints associated with fatal outcomes and evaluate diagnostic accuracy relative to ultimate cause of death.

mortality childmort_chld

Identifies a subordinate or child-level record linked to a parent mortality case within a hierarchical clinical data structure. Used in mortality surveillance systems to associate detailed sub-events, diagnoses, or encounters with a primary death record, enabling comprehensive multi-level analysis of factors contributing to patient death.

mortality citymort_city

Records the municipality of residence or care facility location associated with a patient's death record. Used in geographic mortality analyses, public health surveillance, and population health reporting to identify regional death rate variations, support health equity assessments, and guide community-level intervention planning.

mortality classmort_cls

Designates the classification tier assigned to a mortality event, such as expected versus unexpected death or inpatient versus outpatient mortality. Used in clinical quality programs and accreditation reporting to stratify death events by severity and context, enabling risk-adjusted benchmarking and targeted mortality reduction initiatives.

mortality codemort_cd

Stores the standardized code, such as an ICD cause-of-death code or internal mortality classification value, assigned to a patient death record. Used across clinical, claims, and public health systems to categorize cause of death, enable mortality rate calculations, and support cross-system death data linkage and outcomes reporting.

mortality commentmort_cmt

Free text narrative field capturing supplemental notes or observations related to a patient death event or mortality measure. Used in clinical data warehouses and quality reporting systems to document circumstances, caveats, or contextual details that cannot be captured in structured mortality fields.

PreviousPage 395 of 806Next