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

implant resultimpl_rslt

The clinical outcome or measurement recorded following a medical implant procedure or device assessment, such as post-operative function scores, device performance readings, or complication status. Captured in surgical and clinical systems to evaluate implant effectiveness and support longitudinal follow-up care.

implant surgery dateimpl_surg_dt

The date on which the surgical procedure to place, revise, or remove a medical implant was performed in an operative setting. Used in surgical data systems and implant registries to anchor the device lifecycle, calculate implant longevity, and coordinate post-surgical follow-up schedules.

indicator active indicatorind_actv_ind

A flag denoting whether a clinical quality or performance indicator is currently active and in use for measurement, reporting, or decision support. Used in quality management systems to control which indicators are applied in clinical workflows, dashboards, and regulatory reporting submissions.

indicator active statusind_actv_sts

Indicates whether a clinical quality measurement indicator is currently active or inactive within the measurement system. Controls whether the indicator is included in quality reporting calculations, dashboards, and performance tracking workflows for compliance and accreditation purposes.

indicator admission dateind_admn_dt

Records the inpatient admission date associated with a specific clinical quality indicator event. Used in quality measurement reporting to calculate metrics such as length of stay, readmission rates, and care timeline compliance against established clinical benchmarks and regulatory standards.

indicator assessmentind_asmt

Captures the structured clinical evaluation text associated with a quality measurement indicator, documenting the clinician's findings relevant to the measured care element. Used in quality reporting workflows to support evidence-based reviews, audits, and accreditation documentation requirements.

indicator discharge dateind_dsch_dt

Records the inpatient discharge date associated with a clinical quality indicator event. Used in quality measurement calculations to determine episode duration, evaluate care transitions, and assess compliance with discharge planning standards in hospital quality reporting programs.

indicator durationind_dur

Captures the elapsed time span associated with a clinical quality measurement indicator, such as the length of a treatment episode, symptom duration, or monitoring period. Used in quality metrics to evaluate care timeliness, treatment adherence, and clinical outcome measurement across reporting periods.

indicator emergency indicatorind_emerg_ind

A flag identifying whether a clinical quality indicator event originated from or is associated with an emergency care encounter. Used in quality measurement reporting to stratify metrics by care setting, adjust risk scores, and ensure accurate benchmarking against peer institutions for emergency versus elective care.

indicator history present illnessind_hpi

Stores the narrative description of the patient's current condition as it relates to a specific clinical quality measurement indicator. Provides contextual clinical history used in quality reviews, care gap analysis, and documentation audits to validate indicator compliance and support clinical decision-making.

indicator instructionind_instr

Contains the guidance text associated with a clinical quality measurement indicator, specifying how the indicator should be applied, documented, or acted upon by clinical staff. Used to standardize care processes, ensure consistent data capture, and support compliance with quality program specifications.

indicator labelind_lbl

The human-readable display name or short descriptor assigned to a clinical quality measurement indicator for presentation in reporting dashboards, user interfaces, and printed quality reports. Ensures consistent identification of indicators across systems and supports clear communication in quality improvement workflows.

indicator noteind_nt

Free-text annotation field associated with a clinical quality measurement indicator, used to capture supplemental clinical observations, exceptions, or contextual details that support quality review processes. Commonly referenced during audits, care gap investigations, and indicator validation workflows in quality management systems.

indicator procedure dateind_proc_dt

Records the date on which a clinical procedure relevant to a quality measurement indicator was performed. Used in quality reporting to assess care timeliness, measure adherence to clinical protocols, and evaluate compliance with procedure-based quality metrics across reporting periods and accreditation reviews.

indicator rangeind_rng

Defines the acceptable minimum and maximum value boundaries for a clinical quality measurement indicator. Used to determine whether a measured result falls within expected clinical parameters, trigger alerts for out-of-range values, and support threshold-based quality metric calculations in reporting systems.

indicator resultind_rslt

Stores the measured outcome value for a clinical quality indicator, representing the actual finding or score against the defined measurement criteria. Used in quality reporting to assess performance against benchmarks, identify care gaps, and generate compliance metrics for regulatory submissions and accreditation reviews.

indicator routeind_rte

Specifies the administration pathway relevant to a clinical quality measurement indicator, such as oral, intravenous, or topical delivery. Used in medication-related quality metrics to evaluate prescribing appropriateness, monitor adherence to clinical guidelines, and support pharmacy-related quality reporting requirements.

indicator strengthind_str

Records the drug concentration or dosage strength associated with a medication-related clinical quality measurement indicator. Used in pharmacy quality metrics to evaluate prescribing patterns, assess therapeutic appropriateness, and monitor compliance with evidence-based dosing guidelines in quality reporting programs.

indicator surgery dateind_surg_dt

Captures the date of a surgical procedure associated with a clinical quality measurement indicator. Used in surgical quality reporting to calculate time-to-procedure metrics, assess care timeliness, evaluate compliance with pre- and post-operative care standards, and support outcomes measurement in accreditation programs.

infectious disease account numberid_acct_nbr

A unique identifier assigned to a patient's account record within an infectious disease specialty department or clinic. Used to link clinical encounters, laboratory results, treatment records, and public health reporting data across healthcare systems for disease surveillance and care coordination purposes.

PreviousPage 324 of 806Next