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

Quality

HEDIS, Stars ratings, measures, outcomes and accreditation

1,621 quality terms

metric commentmtr_cmt

Contains free-text narrative notes entered by clinical or administrative users in relation to a performance metric record. Used to document context, exceptions, clarifications, or follow-up actions that cannot be captured in structured fields within healthcare quality reporting workflows.

metric completed datemtr_cmpl_dt

Records the calendar date on which a clinical service, care intervention, or operational task associated with a performance metric was fully completed. Used to measure compliance with care timelines, calculate cycle times, and support time-to-completion quality benchmarks.

metric confidential indicatormtr_conf_ind

A flag denoting whether a performance metric record contains sensitive or restricted information requiring heightened privacy controls, such as behavioral health or substance use data. Governs access permissions and disclosure rules in compliance with HIPAA and applicable state regulations.

metric countmtr_cnt

Represents the total number of occurrences, events, or units associated with a performance metric, such as the number of eligible patients, completed screenings, or qualifying encounters. Used as the numerator or denominator in rate-based quality measure calculations and reporting.

metric countrymtr_ctry

Stores the country associated with a patient, provider, or service location referenced within a performance metric record. Used to support international geographic segmentation, cross-border care coordination tracking, and country-level quality benchmarking in healthcare analytics systems.

metric created bymtr_crtd_by

Identifies the user account or system process responsible for initially creating a performance metric record in the healthcare data system. Supports audit trail integrity, data stewardship accountability, and change management tracking within clinical and operational reporting environments.

metric created datemtr_crtd_dt

Records the calendar date on which a performance metric record was first entered or generated in the healthcare data system. Used to establish record provenance, support audit trail documentation, and track the timeline of metric data capture in quality reporting workflows.

metric created timemtr_crtd_tm

Records the exact timestamp at which a performance metric record was first created in the healthcare data system. Used alongside the created date to establish precise record provenance, support real-time audit logging, and enable chronological sequencing in clinical data warehouses.

metric creatininemtr_cr

Serum or urine creatinine value captured as a clinical metric used to assess kidney function. Recorded in clinical data systems to monitor renal health, track disease progression, and evaluate treatment response in patients with chronic kidney disease or acute renal conditions.

metric datemtr_dt

The calendar date on which a specific healthcare metric was recorded, observed, or calculated. Used in clinical and operational data systems to establish the temporal context of performance measures, quality indicators, or clinical observations for trending and longitudinal analysis.

metric datetimemtr_dttm

The precise date and time at which a healthcare metric was captured, calculated, or recorded. Enables accurate sequencing of clinical observations and performance measurements in data systems where time-stamped precision is required for patient safety, auditing, or real-time monitoring.

metric dea numbermtr_dea_nbr

The Drug Enforcement Administration registration number associated with a metric record, typically linked to a prescriber or dispensing entity. Used in pharmacy and controlled substance tracking systems to ensure regulatory compliance and support audit trails for Schedule II-V drug-related metrics.

metric death datemtr_death_dt

The recorded date of patient death associated with a clinical or operational metric. Used in population health, quality reporting, and outcomes analysis systems to close longitudinal patient records, calculate survival metrics, and satisfy regulatory mortality reporting requirements.

metric deleted datemtr_del_dt

The date on which a metric record was marked as deleted or logically removed from the active dataset. Supports data governance and audit trail requirements in clinical and operational systems by preserving a history of record lifecycle events without physically removing the underlying data.

metric deleted indicatormtr_del_ind

A Boolean or coded flag indicating whether a metric record has been logically deleted from the active dataset. Used in clinical and operational data systems to filter inactive records from reporting while retaining historical data for audit, compliance, and longitudinal analysis purposes.

metric descriptionmtr_desc

A human-readable text narrative explaining the purpose, calculation method, or clinical significance of a quantified performance metric. Used in quality reporting, dashboards, and data dictionaries to provide context that ensures consistent interpretation across clinical, operational, and analytical users.

metric detailmtr_dtl

Granular supplementary information associated with a healthcare metric, providing additional context beyond summary-level data. Used in clinical and operational reporting systems to capture notes, sub-components, or breakdowns that support root cause analysis, quality improvement, and detailed performance review.

metric due datemtr_due_dt

The target or deadline date by which a specific healthcare metric must be collected, reported, or an associated clinical action must be completed. Used in care management, quality program tracking, and regulatory reporting systems to monitor compliance with timelines for screenings, interventions, or submissions.

metric emailmtr_eml

The electronic mail address associated with a metric record, typically linked to a responsible clinician, analyst, or reporting contact. Used in healthcare data systems to route metric-related notifications, threshold alerts, or quality reporting communications to the appropriate individual or team.

metric end datemtr_end_dt

The date on which measurement, observation, or applicability of a healthcare metric concludes. Used in clinical quality programs, care management, and operational reporting to define the close of a measurement window, contract period, or monitoring interval for performance evaluation and trend analysis.

PreviousPage 37 of 82Next