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

medication scoremed_scr

A calculated numeric rating assigned to a pharmaceutical substance in EHR, PBM, or clinical decision support systems. Used to rank drug appropriateness, adherence risk, or formulary priority. Supports medication management workflows and quality reporting pipelines.

medication sequencemed_seq

An ordered numeric identifier assigned to a pharmaceutical substance within a medication regimen or claim record. Used in PBM, EHR, and pharmacy systems to distinguish multiple medications in a series, ensuring accurate processing and data lineage tracking.

medication service datemed_svc_dt

The calendar date on which a pharmaceutical substance was dispensed, administered, or prescribed within pharmacy, PBM, or EHR systems. Critical for claims adjudication, medication adherence calculations, and longitudinal patient timeline analysis in healthcare data pipelines.

medication severitymed_sev

A coded or numeric indicator of the clinical seriousness associated with a pharmaceutical substance, such as high-alert drug classification or adverse event risk level. Used in EHR and pharmacy safety systems to trigger clinical alerts and risk stratification workflows.

medication sexmed_sex

The patient's biological sex recorded in association with a medication record. Used in clinical and pharmacy data systems to support sex-specific dosing calculations, evaluate differential drug metabolism, identify contraindications, and meet regulatory requirements for demographic reporting in pharmacovigilance and outcomes research.

medication sourcemed_src

The originating system, database, or prescriber entity from which a pharmaceutical substance record was derived. Tracked in EHR, PBM, and data integration pipelines to support data provenance, deduplication, and master drug reference reconciliation across healthcare platforms.

medication start datemed_start_dt

The date on which a patient began a prescribed pharmaceutical regimen, as recorded in EHR, pharmacy, or member health management systems. Used to calculate therapy duration, measure adherence windows, and align medication timelines with clinical encounter data.

medication start timemed_start_tm

The exact time at which a medication administration, infusion, or drug therapy episode began. Recorded in clinical and pharmacy systems to document treatment duration, support precise interval dosing, establish administration timelines for time-sensitive drugs, and enable accurate medication reconciliation across care settings.

medication statemed_st

The U.S. state or territory associated with a medication record, typically linked to a dispensing pharmacy, prescriber license jurisdiction, or patient address. Used in pharmacy data systems to support state-specific controlled substance reporting, prescription drug monitoring program compliance, and geographic analysis of drug utilization.

medication statusmed_sts

A coded field indicating the current state of a pharmaceutical substance record, such as active, discontinued, on-hold, or expired. Used in EHR, PBM, and member health systems to manage medication lists, trigger refill alerts, and support clinical decision support logic.

medication street addressmed_st_addr

The physical street address associated with a medication record, typically reflecting the dispensing pharmacy, prescribing location, or patient delivery address. Used in pharmacy management and prescription fulfillment systems to coordinate drug delivery, verify dispensing site information, and support regulatory and geographic reporting requirements.

medication strengthmed_str

The concentration or potency of an active drug ingredient within a medication formulation, expressed in units such as mg, mcg, or mg/mL. Recorded in pharmacy dispensing and clinical documentation systems to ensure accurate dosing, support clinical decision making, and maintain compliance with prescriber orders and safety protocols.

medication subtotalmed_subtot

The partial sum of costs or quantities for a medication record, typically representing a line-item accumulation before taxes, dispensing fees, or other charges are applied in pharmacy billing, claims adjudication, or medication reconciliation workflows.

medication surgery datemed_surg_dt

The date on which a surgical procedure was performed that is directly associated with a specific medication order or administration, used to correlate perioperative drug therapy with operative events in clinical and claims records.

medication system identifiermed_sys_id

The unique system-generated key assigned to a medication record within a pharmacy, EHR, or claims platform, enabling consistent cross-system tracking of drug orders, dispensing events, and medication history across the care continuum.

medication targetmed_tgt

The intended biological, anatomical, or therapeutic destination of a pharmaceutical substance, such as a receptor, organ system, or condition. Captured in clinical and PBM datasets to support drug utilization review, formulary management, and therapeutic outcome analysis.

medication taxonomy codemed_tax_cd

The classification code used to categorize a medication within a standardized drug taxonomy hierarchy, such as therapeutic class or pharmacological category, supporting formulary management, utilization reporting, and pharmacy benefit analysis.

medication temperaturemed_temp

The required storage or administration temperature for a medication, used in pharmacy operations and supply chain management to ensure drug stability, cold chain compliance, and safe dispensing of temperature-sensitive biologics or specialty drugs.

medication termination datemed_term_dt

The date on which a medication order, prescription, or therapy was discontinued, expired, or ended, used in pharmacy records and clinical systems to establish the active treatment window and support medication reconciliation and adherence analysis.

medication timemed_tm

The specific time of day at which a pharmaceutical substance is scheduled or recorded as administered, as stored in EHR medication administration records (MAR) and pharmacy systems. Used in clinical workflows to enforce dosing schedules and support pharmacokinetic analysis.

PreviousPage 385 of 806Next