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 strengthdose_str

The concentration or potency of the active ingredient in a specific medication dose, expressed in units such as mg, mcg, or mg/mL. Used in pharmacy dispensing and medication administration records to ensure the correct drug concentration is prepared and delivered relative to the prescribed therapeutic target.

dose subtotaldose_subtot

A partial cumulative sum of medication dose quantities within a defined subset of a treatment regimen, such as daily or weekly totals within a longer course. Used in oncology, anticoagulation, and clinical trial systems to monitor cumulative exposure and enforce safety thresholds for maximum allowable dosing.

dose surgery datedose_surg_dt

The date of a surgical procedure associated with a specific medication dose, used to link perioperative drug administration to the corresponding operative event. Used in surgical and anesthesia records to track preoperative, intraoperative, and postoperative medications relative to the procedure timeline.

dose targetdose_tgt

Identifies the intended therapeutic target or clinical objective for a prescribed medication dose, such as a specific anatomical site, physiological parameter, or treatment goal. Used in medication management systems to link dosing instructions to clinical outcomes tracking.

dose taxonomy codedose_tax_cd

Standardized classification code that categorizes a medication dose within a structured clinical terminology hierarchy, such as RxNorm or NDF-RT. Used in pharmacy and medication management systems to enable consistent cross-system identification and reporting of dose types.

dose temperaturedose_temp

Records the required storage or administration temperature for a medication dose, expressed in Celsius or Fahrenheit. Critical in pharmacy and medication management workflows for cold-chain medications such as biologics, vaccines, and insulin that require controlled temperature conditions.

dose termination datedose_term_dt

The date on which a prescribed medication dose regimen is discontinued or expires, either as planned at time of prescribing or updated due to clinical decision. Used in medication management and EHR systems to define the end boundary of an active medication order or treatment course.

dose timedose_tm

The specific time of day at which a medication dose is scheduled to be administered or was actually given to a patient. Used in medication administration records and clinical workflows to support accurate scheduling, adherence tracking, and adverse event investigation.

dose timestampdose_ts

The precise date and time at which a medication dose event occurred, such as when it was ordered, dispensed, or administered. Used in pharmacy and medication administration records to establish an exact chronological reference for auditing, clinical review, and safety reporting.

dose titledose_ttl

The formal descriptive label assigned to a medication dose record, typically including drug name, strength, and form. Used in clinical documentation systems to provide a human-readable identifier that distinguishes dose records within a patient's medication history or treatment plan.

dose totaldose_tot

The cumulative medication amount delivered to a patient across a defined period or treatment episode, calculated by aggregating individual dose quantities. Used in pharmacy and clinical systems to monitor total drug exposure, assess adherence to prescribed regimens, and support safety threshold evaluations.

dose total countdose_tot_cnt

The total number of individual dose administrations or dispensing events recorded for a medication within a specified timeframe or treatment episode. Used in pharmacy dispensing and medication management systems to monitor prescription fills, track adherence, and support utilization reporting.

dose typedose_typ

Classifies a medication dose by its clinical or operational category, such as loading dose, maintenance dose, booster, or rescue dose. Used in medication management and prescribing systems to differentiate dosing intent and ensure appropriate clinical decision support rules are applied.

dose updated datedose_upd_dt

The most recent date on which a medication dose record was modified, reflecting changes to dose strength, frequency, route, or other clinical parameters. Used in medication management systems to maintain an accurate audit trail and identify when prescribing or dispensing instructions were last revised.

dose urgencydose_urg

Indicates the clinical priority or time-sensitivity level assigned to a medication dose order, such as routine, urgent, or STAT. Used in medication management and order entry systems to drive workflow prioritization, pharmacy dispensing sequencing, and nursing administration scheduling.

dose versiondose_ver

Tracks the iteration number of a medication dose record, incrementing each time the dose order is modified or reissued. Used in medication management and clinical data systems to preserve historical dosing information, support audit requirements, and distinguish the current active dose from prior versions.

dose zipdose_zip

The postal ZIP code associated with the location where a medication dose was dispensed, administered, or prescribed, such as a pharmacy or clinical site address. Used in pharmacy and medication management systems for geographic reporting, network analysis, and site-of-care tracking.

drug balancedrg_bal

The outstanding amount for a therapeutic chemical compound. The calculated quantity of a medication that should be present in a ward or department at any given time.

duration active indicatordur_actv_ind

A binary flag indicating whether a treatment duration record is currently active and in use within clinical or administrative systems. Used in care management and utilization tracking systems to filter active treatment episodes from historical or inactive records during reporting and clinical decision support.

duration active statusdur_actv_sts

Describes the current lifecycle state of a treatment duration record, using defined status values such as active, suspended, completed, or cancelled. Used in care management and clinical data systems to support workflow routing, reporting filters, and accurate representation of ongoing versus concluded treatment periods.

PreviousPage 213 of 806Next