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

metric admission datemtr_admn_dt

Records the inpatient admission date associated with a specific healthcare performance metric, linking the metric to a hospital encounter. Used in quality measurement and utilization analytics to contextualize metrics within an episode of care for outcomes reporting.

metric assessmentmtr_asmt

Captures the clinical or analytical evaluation tied to a specific healthcare performance metric, documenting the interpretation or findings associated with the measured value. Used in quality reporting, care management, and population health programs to support clinical decision-making.

metric discharge datemtr_dsch_dt

Records the inpatient discharge date associated with a specific healthcare performance metric, anchoring the metric to the end of a hospital encounter. Used in quality measurement, length-of-stay analytics, and outcomes reporting to evaluate post-discharge performance indicators.

metric durationmtr_dur

Represents the elapsed time interval over which a specific healthcare performance metric is measured or remains applicable. Used in quality reporting, chronic disease management, and utilization analytics to define the measurement window for evaluating clinical or operational outcomes.

metric emergency indicatormtr_emerg_ind

A flag denoting whether a specific healthcare performance metric is associated with an emergency or urgent care encounter. Used in quality reporting and utilization analytics to differentiate emergency-driven metric results from elective or routine care, enabling appropriate risk stratification.

metric history present illnessmtr_hpi

Stores the clinical narrative describing the history of present illness associated with a specific healthcare performance metric. Used in quality management and care coordination programs to provide contextual clinical background that informs the interpretation of measured performance values.

metric instructionmtr_instr

Contains guidance or directional text associated with collecting, calculating, or applying a specific healthcare performance metric. Used in quality programs, clinical data warehouses, and analytics platforms to standardize how metrics are measured, reported, and acted upon by clinical or operational teams.

metric labelmtr_lbl

The human-readable display name assigned to a specific healthcare performance metric for use in dashboards, reports, and quality scorecards. Provides a standardized, user-friendly identifier that distinguishes the metric across clinical analytics, population health, and operational reporting systems.

metric notemtr_nt

Free-text annotation associated with a specific healthcare performance metric, capturing supplemental context, exceptions, or observations relevant to the metric value. Used in quality reporting and clinical analytics to document caveats or explanations that affect the interpretation of measured outcomes.

metric procedure datemtr_proc_dt

Records the date on which a clinical procedure associated with a specific healthcare performance metric was performed. Used in quality measurement and outcomes analytics to align metric values with procedure timing, supporting accurate episode-based reporting and care pathway analysis.

metric rangemtr_rng

Defines the minimum and maximum acceptable or expected values for a specific healthcare performance metric. Used in clinical analytics, quality scorecards, and alerting systems to determine whether a measured metric value falls within normal, target, or out-of-bounds thresholds for clinical or operational review.

metric resultmtr_rslt

Stores the actual measured or calculated outcome value for a specific healthcare performance metric. Used in quality reporting, population health management, and clinical analytics to record the quantified finding that is compared against benchmarks, targets, or acceptable ranges for performance evaluation.

metric routemtr_rte

Specifies the administration pathway associated with a medication or treatment metric, such as oral, intravenous, or topical delivery. Used in pharmacy analytics, medication management systems, and clinical quality reporting to ensure metric values are interpreted within the correct treatment delivery context.

metric strengthmtr_str

Records the drug concentration or dosage strength associated with a medication-related healthcare performance metric. Used in pharmacy analytics and clinical quality programs to capture the potency of a prescribed or administered medication, supporting appropriate dosing compliance and safety metric reporting.

metric surgery datemtr_surg_dt

Records the date on which a surgical procedure associated with a specific healthcare performance metric was performed. Used in surgical quality reporting, outcomes analytics, and episode-of-care measurement to align metric values with operative timing for perioperative and post-surgical performance evaluation.

microbiology admission datemicro_admn_dt

Records the inpatient admission date associated with a microbiology specimen or laboratory test, linking the microbiological study to a specific hospital encounter. Used in infection control reporting and clinical analytics to track organism identification relative to the timing of patient admission.

microbiology discharge datemicro_dsch_dt

Records the inpatient discharge date associated with a microbiology specimen or laboratory test, anchoring the microbiological study to the end of a hospital encounter. Used in infection surveillance and clinical outcomes analytics to evaluate organism findings relative to discharge timing and care transitions.

microbiology labelmicro_lbl

The human-readable display name assigned to a microbiology specimen, culture, or test result for use in laboratory information systems and clinical reports. Provides a standardized identifier that distinguishes specific microbiological studies across infection control, antimicrobial stewardship, and clinical analytics platforms.

microbiology procedure datemicro_proc_dt

Records the date on which a microbiology specimen collection or laboratory procedure was performed. Used in infection surveillance, antimicrobial stewardship programs, and clinical analytics to associate culture results and organism findings with precise procedural timing for accurate diagnosis and treatment tracking.

microbiology surgery datemicro_surg_dt

The date on which a surgical procedure was performed in conjunction with a microbiology study, such as culture collection during an operative case. Used in clinical lab and surgical records to correlate specimen timing with procedural events for infection tracking and reporting.

PreviousPage 387 of 806Next