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

strength levelstr_lvl

A numeric or coded value representing the hierarchical position of a drug concentration within a tiered formulary or dosing structure. Used in pharmacy benefit management to organize strength variants of the same drug, supporting tier-based pricing, clinical dose escalation protocols, and drug utilization review.

strength license numberstr_lic_nbr

A professional or regulatory license identifier associated with a compounded or specially prepared drug concentration, linking the strength record to a licensed pharmacy or pharmacist. Used in specialty pharmacy and compounding management systems to ensure regulatory compliance and dispensing accountability.

strength marital statusstr_mar_sts

A misapplied demographic field incorrectly mapped to a drug concentration record. In pharmacy data systems, this field has no valid clinical meaning for drug strength and likely represents a data modeling error requiring remediation to maintain data integrity in medication management workflows.

strength master identifierstr_mstr_id

The enterprise-level master record identifier uniquely linking a drug concentration value across multiple pharmacy, clinical, and claims systems. Used in master data management frameworks to consolidate duplicate strength records and maintain a single authoritative drug concentration reference across the healthcare enterprise.

strength maximumstr_max

The upper boundary value of a drug concentration range, defining the highest permissible dose or concentration for a medication in clinical or formulary guidelines. Used in clinical decision support systems and pharmacy benefit management to enforce dosing limits and trigger safety alerts during prescription adjudication.

strength middle namestr_mid_nm

A misapplied demographic field incorrectly associated with a drug concentration record. In pharmacy data contexts, this field holds no clinical relevance to drug strength and likely represents a structural data error requiring correction to prevent misclassification in medication management and formulary systems.

strength minimumstr_min

The lower boundary value of a drug concentration range, defining the lowest acceptable dose or concentration for a medication according to clinical or formulary guidelines. Used in pharmacy benefit management and clinical decision support to ensure prescribed doses meet therapeutic thresholds during drug utilization review.

strength mobilestr_mob

A misapplied contact field incorrectly mapped to a drug concentration record. In valid pharmacy data systems, mobile phone numbers have no clinical association with drug strength values, and this field likely represents a data modeling error requiring remediation in pharmacy and medication management databases.

strength modified bystr_mod_by

The user identifier of the individual who last updated a drug concentration record, capturing the pharmacist, analyst, or system process responsible for changes. Used in pharmacy formulary and drug reference management systems to maintain audit trails and support data governance accountability for medication strength records.

strength modified datestr_mod_dt

The calendar date on which a drug concentration record was last updated within the pharmacy or formulary management system. Used to track the currency of drug strength data, support audit compliance, and identify records requiring review following formulary updates, regulatory changes, or drug repackaging events.

strength modified timestr_mod_tm

The timestamp indicating the exact time a drug concentration record was last updated in the pharmacy or formulary management system. Used alongside the modified date to provide precise audit trail documentation for drug strength changes, supporting data governance and regulatory compliance in medication management systems.

strength namestr_nm

The descriptive display label for a drug concentration value, such as the combination of drug name and dosage amount (e.g., 'Amoxicillin 250mg'). Used in pharmacy dispensing, formulary listings, and prescription claims systems to clearly identify medication strength in both clinical documentation and patient-facing communications.

strength notestr_nt

Free-text annotation associated with a drug concentration record, capturing supplementary clinical, compounding, or administrative details not accommodated by structured fields. Used in pharmacy formulary management and medication order systems to document special handling requirements, clinical exceptions, or pharmacist observations about a specific drug strength.

strength numberstr_nbr

A unique numeric identifier assigned to a specific drug concentration value within pharmacy and medication management systems. Used to reference and track a particular strength across formularies, drug databases, prescription records, and clinical data repositories to ensure consistent identification.

strength onset datestr_onset_dt

The date on which a specific drug concentration or strength value became effective or was first applied in pharmacy or medication management records. Used to track the temporal validity of a drug strength entry within formulary management, drug databases, and clinical systems.

strength oxygen saturationstr_o2sat

A blood oxygen saturation measurement associated with a drug concentration record, typically captured to assess clinical context or patient response at the time a specific medication strength was administered or evaluated within clinical documentation systems.

strength paid amountstr_pd_amt

The dollar amount reimbursed or paid for a medication at a specific drug concentration or strength level. Used in pharmacy claims and adjudication systems to capture the financial transaction associated with dispensing a particular drug strength to a member or patient.

strength paid datestr_pd_dt

The date on which payment was processed or remitted for a medication claim associated with a specific drug strength. Used in pharmacy claims and financial reconciliation systems to track reimbursement timing for dispensed medications at a particular concentration level.

strength parentstr_prnt

A reference to the parent entity or higher-level record to which a specific drug strength value belongs within a hierarchical drug database or formulary structure. Used to establish relationships between drug concentrations and their parent drug product, ingredient, or classification records.

strength percentagestr_pct

The concentration of an active ingredient expressed as a percentage within a drug formulation. Used in pharmacy and clinical systems to quantify drug potency, particularly for topical preparations, solutions, and compounded medications where concentration is expressed proportionally rather than in absolute units.

PreviousPage 671 of 806Next