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 arrived datestr_arrv_dt

Records the date a patient arrived at a care facility associated with a drug strength record, linking the concentration value to the encounter start. Used in pharmacy and clinical systems to establish the temporal context for medication orders initiated at admission.

strength assessmentstr_asmt

Contains the clinical evaluation narrative or structured assessment text associated with a drug strength record in a medication management workflow. Captures clinician notes regarding the appropriateness of a specific concentration value for a patient's current condition or treatment plan.

strength balancestr_bal

Represents the outstanding financial amount remaining after payments or adjustments have been applied to a drug strength transaction in pharmacy billing systems. Used to track unpaid balances on claims or invoices associated with specific drug concentration values.

strength billed amountstr_bill_amt

The total dollar amount submitted to a payer on a pharmacy or medical claim for a specific drug strength. Represents the gross charge before adjudication, adjustments, or contractual discounts are applied to the concentration-specific medication transaction.

strength birth datestr_birth_dt

Records the patient date of birth linked to a drug strength record, used to validate age-based dosing eligibility in pharmacy systems. Ensures the prescribed drug concentration aligns with pediatric, adult, or geriatric dosing parameters established in clinical guidelines.

strength blood pressurestr_bp

Captures the patient blood pressure reading associated with a drug strength record, used to validate concentration appropriateness for antihypertensives, vasopressors, or other cardiovascular medications. Supports clinical decision rules that trigger dosing adjustments based on vital sign values.

strength cancelled datestr_cncl_dt

Records the date a specific drug strength entry was cancelled or withdrawn from a formulary, prescription, or medication order. Used in pharmacy systems to maintain a historical record of discontinued concentration values and support audit trails for medication management changes.

strength categorystr_cat

Classifies a drug strength into a defined grouping within the pharmacy formulary or drug catalog, such as low-dose, standard, or high-potency tiers. Used to organize concentration values for formulary management, utilization reporting, and clinical decision support rule configuration.

strength chief complaintstr_cc

Records the primary symptom or clinical reason documented at the time a drug strength was ordered or prescribed. Used to contextualize medication concentration decisions within the clinical encounter, supporting retrospective analysis of prescribing patterns relative to presenting diagnoses.

strength childstr_chld

Identifies a subordinate drug strength record linked to a parent concentration in a hierarchical drug catalog or formulary structure. Used in pharmacy data systems to manage variant formulations derived from a primary strength, such as split-dose or compounded concentration alternatives.

strength citystr_city

Records the municipality associated with a drug strength record, typically reflecting the dispensing pharmacy location or the patient address linked to a pharmacy claim. Used in geographic analysis of drug utilization patterns and regional formulary compliance reporting by concentration.

strength classstr_cls

Identifies the pharmacological or formulary classification tier assigned to a drug strength, such as therapeutic class, schedule class, or benefit tier grouping. Used in pharmacy benefit management systems to apply appropriate cost-sharing rules and coverage policies to specific concentration values.

strength codestr_cd

A standardized alphanumeric identifier assigned to a specific drug concentration value within a pharmacy catalog, formulary system, or drug database such as RxNorm or NDC. Used as the primary reference key to uniquely identify and cross-reference strength records across pharmacy, claims, and clinical systems.

strength commentstr_cmt

Free text annotation field capturing supplementary notes about a drug's concentration or potency value in pharmacy and medication management systems. Used to document exceptions, clarifications, or special handling instructions related to the recorded strength of a pharmaceutical product.

strength completed datestr_cmpl_dt

The date on which processing or validation of a drug concentration value was finalized in the pharmacy or medication management system. Tracks when strength-related data entry, verification, or review workflows were completed for a specific pharmaceutical record.

strength confidential indicatorstr_conf_ind

A flag designating whether a drug concentration value is subject to restricted access or privacy controls within pharmacy and medication management systems. Governs visibility of strength data across clinical and administrative workflows based on sensitivity classification of the pharmaceutical record.

strength countstr_cnt

A numeric value representing the total number of occurrences or instances associated with a specific drug concentration in pharmacy reference or formulary databases. Used to quantify how many records, products, or configurations share a particular pharmaceutical strength value.

strength countrystr_ctry

Identifies the nation of origin or regulatory jurisdiction associated with a drug concentration value in pharmaceutical reference databases. Used to differentiate strength specifications and measurement standards for medications approved or manufactured in different international markets.

strength created bystr_crtd_by

The user identifier or system account responsible for initially entering a drug concentration value into the pharmacy or medication management system. Provides an audit trail linking the strength record to the specific user who originated the pharmaceutical data entry.

strength created datestr_crtd_dt

The calendar date on which a drug concentration record was first entered into the pharmacy or medication management system. Establishes the origin point for audit trail purposes and supports longitudinal tracking of pharmaceutical strength data across formulary or drug reference systems.

PreviousPage 668 of 806Next