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 history present illnessmed_hpi

A narrative description of the patient's current medical condition or presenting symptoms that prompted a specific medication order or therapy change. Used in clinical documentation systems to provide clinical context for prescribing decisions and support medication appropriateness review during care transitions.

medication identifiermed_id

A unique alphanumeric key assigned to a pharmaceutical substance in EHR, pharmacy, PBM, and claims systems, such as an NDC, RxNorm code, or internal drug master ID. Used to link drug records across formulary, adjudication, dispensing, and clinical data tables for accurate medication management and reporting.

medication indexmed_idx

A numeric position or sequence value assigned to a medication record within an ordered list or drug database in EHR, pharmacy, and PBM systems. Used to maintain sort order, support hierarchical drug classification, and enable efficient retrieval of medication records during claims adjudication and formulary lookups.

medication indicatormed_ind

A boolean or coded field in EHR, claims, and PBM systems flagging whether a specific drug-related condition, attribute, or coverage rule applies to a medication record. Used in adjudication logic, formulary management, and pharmacy benefit processing to drive automated decision-making and drug utilization reporting workflows.

medication instructionmed_instr

Structured or free-text directions associated with a drug order or prescription in EHR and pharmacy systems, including dose, route, frequency, and administration guidance. Used in pharmacy dispensing, patient engagement platforms, and medication reconciliation workflows to ensure accurate drug administration and safe patient self-management.

medication keymed_key

A unique system-generated or assigned identifier used as the primary lookup reference for a medication record within a database or clinical application. Used in EHR and pharmacy systems to link related medication data across tables, support relational queries, and maintain referential integrity in medication management workflows.

medication labelmed_lbl

The human-readable display text printed or shown on a medication container, package, or EHR medication list entry, including drug name, strength, dosage form, and administration instructions. Used in pharmacy dispensing and clinical systems to communicate accurate prescribing information to patients and care providers.

medication languagemed_lang

Records the preferred language in which medication instructions, labels, and counseling should be provided to the patient. Used in pharmacy dispensing systems and patient engagement platforms to generate multilingual prescription labels, discharge instructions, and medication guides that support safe drug use and health literacy.

medication last namemed_last_nm

The surname or family name component of a medication name, used in pharmacy and clinical systems where drug names follow a structured naming convention. Supports sorting, searching, and display of medications in prescription and dispensing workflows.

medication legal namemed_legal_nm

The officially registered name of a drug as approved by regulatory authorities such as the FDA. Used in pharmacy dispensing, prescription records, and clinical documentation to ensure the correct legally recognized drug identity is referenced in claims and clinical workflows.

medication levelmed_lvl

A hierarchical classification value in EHR, formulary, and PBM systems indicating a drug's position within a therapeutic category, formulary tier, or drug classification structure. Used in pharmacy benefit design, prior authorization logic, and formulary management to assign cost-sharing rules and coverage tiers to specific medications.

medication license numbermed_lic_nbr

The regulatory license or registration number assigned to a pharmaceutical drug by a governing authority such as the FDA or DEA. Used in pharmacy management systems to validate drug authorization status and ensure compliance with dispensing regulations.

medication marital statusmed_mar_sts

A misapplied demographic attribute in this context. When applied to medications, this field likely captures a drug combination or pairing status, such as whether a medication is used as a standalone therapy or in conjunction with another drug, relevant in clinical formulary and treatment protocol management.

medication master identifiermed_mstr_id

The enterprise-level unique identifier assigned to a medication record within a master drug database or formulary system. Used across pharmacy, clinical, and claims systems to ensure consistent identification of a drug product regardless of the source system or transaction type.

medication maximummed_max

The upper boundary value for a medication attribute such as dosage, quantity dispensed, or administration frequency. Used in pharmacy benefit management and clinical decision support systems to enforce safe prescribing limits and prevent dosage errors in treatment protocols.

medication medical record numbermed_mrn

The medical record number associated with a patient's medication record, linking a prescribed or dispensed drug to a specific patient encounter in an EHR or clinical data system. Used to trace medication history within a patient's longitudinal clinical record.

medication middle namemed_mid_nm

The middle name or initial component of a multi-part medication name, used in structured drug naming conventions within pharmacy systems. Supports precise identification of drug products in formularies, clinical documentation, and prescription records where name components are stored separately.

medication minimummed_min

The lower boundary value for a medication attribute such as dosage, quantity, or administration interval. Used in pharmacy benefit management and clinical decision support to establish minimum effective thresholds and ensure therapeutic adequacy in prescribing and dispensing workflows.

medication mobilemed_mob

A contact or communication attribute associated with a medication record in systems that support mobile-enabled pharmacy workflows. May capture a mobile reference identifier used for electronic prescription routing, patient medication alerts, or mobile pharmacy platform integration.

medication modified bymed_mod_by

The user identifier of the individual who last updated a medication record within a pharmacy or clinical information system. Used for audit trail and data governance purposes to track changes to drug formulary entries, prescription records, or medication administration documentation.

PreviousPage 382 of 806Next