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

dose indexdose_idx

The sequential position number of a medication dose within a series or course of treatment, such as the third dose in a five-dose regimen. Used in clinical and pharmacy systems to track treatment progression, schedule subsequent doses, and support protocol adherence monitoring.

dose indicatordose_ind

A coded or boolean field that signals a specific attribute of a medication dose record, such as whether the dose was administered, refused, held, or wasted. Supports medication administration record accuracy, nursing workflow documentation, and compliance reporting requirements.

dose instructiondose_instr

The administration guidance text associated with a prescribed medication dose, including directions such as take with food, inject subcutaneously, or avoid grapefruit. Transmitted from prescriber to pharmacist and patient to ensure safe, effective, and accurate medication use.

dose keydose_key

Unique surrogate identifier assigned to a specific medication dose record in pharmacy or clinical systems. Used as the primary lookup reference to link dose configurations across drug formularies, prescription orders, medication administration records, and clinical decision support tables.

dose labeldose_lbl

Human-readable display text describing a specific medication dose, such as '500mg twice daily' or '10mcg/mL'. Rendered on prescription labels, medication administration records, patient instructions, and clinical documentation to communicate dosing details clearly to clinicians and patients.

dose languagedose_lang

Indicates the language in which dose instructions and labeling are communicated to the patient or caregiver. Used in pharmacy dispensing and medication management systems to ensure prescription instructions, warning labels, and patient education materials are provided in the preferred language.

dose last namedose_last_nm

Appears to be a data quality artifact where a patient or prescriber surname field has been incorrectly mapped to a dose record. In valid pharmacy or clinical contexts, this may capture the last name of the prescribing clinician or dispensing pharmacist associated with the dose order.

dose legal namedose_legal_nm

The official regulatory or formulary name assigned to a medication dose as recognized by governing bodies such as the FDA or USP. Used in pharmacy dispensing, drug formulary management, and clinical documentation to ensure the dose is referenced under its formally approved nomenclature.

dose leveldose_lvl

Indicates the tier or hierarchy position of a medication dose within a structured dosing regimen or clinical protocol. Used in pharmacy benefit management and clinical decision support to classify doses as loading, maintenance, titration, or tapering levels within a treatment plan.

dose license numberdose_lic_nbr

Appears to be a data quality artifact where a professional license field has been incorrectly mapped to a dose record. In valid pharmacy contexts, this may reference the DEA or state pharmacy license number of the prescriber or dispensing pharmacist associated with the controlled substance dose.

dose marital statusdose_mar_sts

Appears to be a data quality artifact where a demographic field has been incorrectly mapped to a dose record. In valid clinical contexts, this field may be misused to capture a status code indicating the current state of a dose order, such as active, discontinued, held, or completed.

dose master identifierdose_mstr_id

Enterprise-wide master identifier that uniquely and persistently identifies a medication dose record across all integrated clinical and pharmacy systems. Used to reconcile dose records across EHR platforms, pharmacy dispensing systems, and clinical data warehouses during patient medication reconciliation and reporting.

dose maximumdose_max

The highest allowable quantity of a medication that can be safely administered within a defined time period, such as per dose, per day, or per course. Used in pharmacy order entry and clinical decision support systems to enforce dosing limits and trigger safety alerts for overdose prevention.

dose middle namedose_mid_nm

Appears to be a data quality artifact where a person name field has been incorrectly mapped to a dose record. In valid pharmacy contexts, this may capture the middle name or initial of a prescribing clinician or patient associated with the medication order for identity verification purposes.

dose minimumdose_min

The lowest effective quantity of a medication required to produce a therapeutic response within a defined time period. Used in pharmacy order entry and clinical decision support systems to establish therapeutic floor thresholds and alert clinicians when prescribed amounts fall below clinically effective ranges.

dose mobiledose_mob

Appears to be a data quality artifact where a contact information field has been incorrectly mapped to a dose record. In valid clinical contexts, this may reference a mobile contact number for the prescribing clinician or patient to support outreach related to medication order clarification or pharmacy callbacks.

dose modified bydose_mod_by

Captures the user identifier or system account responsible for the most recent update to a medication dose record. Used in pharmacy and clinical audit trails to maintain accountability and traceability of dose adjustments, order modifications, and clinical documentation changes in compliance with regulatory requirements.

dose modified datedose_mod_dt

Records the calendar date on which a medication dose record was most recently updated or amended. Used in pharmacy systems and clinical data warehouses to support audit trails, medication reconciliation, regulatory compliance reporting, and chronological tracking of dose order changes throughout a patient's treatment timeline.

dose modified timedose_mod_tm

Records the exact time at which a medication dose record was most recently updated or amended. Used alongside the modified date in pharmacy and clinical audit logs to provide precise timestamps for dose order changes, supporting medication safety reviews, regulatory compliance, and clinical documentation integrity.

dose namedose_nm

The descriptive label identifying a specific medication dose configuration, typically combining drug name, strength, and form such as 'Metformin 500mg Tablet'. Used in pharmacy dispensing systems, formulary management, medication administration records, and clinical documentation to consistently identify and communicate the dose to clinicians and patients.

PreviousPage 210 of 806Next