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 created timestr_crtd_tm

The timestamp indicating the exact time of day when a drug concentration record was first entered into the pharmacy or medication management system. Combined with the created date, provides precise audit trail documentation for pharmaceutical strength data origination events.

strength creatininestr_cr

The measured concentration or dosing value of a drug as it relates to creatinine-based renal function assessment. Used in clinical and pharmacy systems to capture renally-adjusted medication strengths, particularly for drugs requiring dose modification based on a patient's kidney function status.

strength datestr_dt

The effective calendar date associated with a specific drug concentration value in pharmacy or formulary management systems. Indicates when a particular pharmaceutical strength became active, was recorded, or is applicable within drug reference databases or medication order records.

strength datetimestr_dttm

The combined date and time stamp associated with a drug concentration value in pharmacy or medication management systems. Provides precise temporal context for when a pharmaceutical strength record was recorded, modified, or became effective within clinical or formulary workflows.

strength dea numberstr_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance strength record in pharmacy systems. Used to link specific drug concentrations to DEA schedules, ensuring regulatory compliance and proper tracking of controlled pharmaceutical products across dispensing workflows.

strength death datestr_death_dt

The date on which a drug concentration record was retired or deactivated within a pharmacy reference or formulary management system. Marks the end of a pharmaceutical strength's active lifecycle, used to maintain historical records while preventing use of discontinued concentration values.

strength deleted datestr_del_dt

The date on which a drug concentration record was marked as deleted within the pharmacy or formulary management system. Supports soft-delete audit trail requirements by preserving the timestamp of removal while retaining the pharmaceutical strength record for historical reporting purposes.

strength deleted indicatorstr_del_ind

A flag identifying whether a drug concentration record has been logically removed from active use in the pharmacy or formulary management system. Enables soft-delete functionality, allowing deleted pharmaceutical strength records to be retained for audit and historical reporting while excluding them from active workflows.

strength descriptionstr_desc

A human-readable text field providing a standardized narrative explanation of a drug's concentration or potency value in pharmacy and formulary systems. Communicates the pharmaceutical strength in a format meaningful to clinicians, pharmacists, and medication management workflows across healthcare settings.

strength detailstr_dtl

Granular supplementary information associated with a drug concentration value in pharmacy or formulary management systems. Captures specific attributes, specifications, or contextual data that further define or qualify the pharmaceutical strength beyond what is expressed in the primary strength field.

strength discharge datestr_dsch_dt

The date a patient was discharged from a care setting in relation to a drug concentration record, used in pharmacy and medication management systems to align inpatient medication strengths with discharge medication reconciliation. Supports transitions of care documentation for pharmaceutical continuity.

strength due datestr_due_dt

The target or deadline date by which a drug concentration record must be reviewed, renewed, or acted upon within pharmacy or formulary management workflows. Used to trigger scheduled reviews of pharmaceutical strength data to ensure formulary accuracy and regulatory compliance timelines are met.

strength durationstr_dur

The length of time a specific drug concentration value remains active, effective, or applicable within pharmacy or medication management systems. Used in formulary management and prescription workflows to define how long a particular pharmaceutical strength is valid for dispensing or clinical reference purposes.

strength emailstr_eml

Email address associated with a specific drug strength record in pharmacy or formulary management systems. Used to contact manufacturers, compounding pharmacies, or regulatory contacts responsible for maintaining accurate drug concentration specifications and dosing information.

strength emergency indicatorstr_emerg_ind

Flag identifying whether a specific drug strength requires emergency handling protocols in pharmacy dispensing or clinical ordering systems. Indicates urgency status for drug concentration records, such as restricted strengths requiring expedited review, special authorization, or immediate clinical intervention workflows.

strength end datestr_end_dt

Date on which a specific drug strength record becomes inactive or is retired from formulary or pharmacy reference systems. Used to track the valid period of a drug concentration, ensuring clinical ordering systems and pharmacy benefit managers reference only currently approved strength configurations.

strength end timestr_end_tm

Timestamp marking the precise moment a drug strength record is deactivated within pharmacy or formulary management systems. Provides granular temporal tracking of drug concentration validity, supporting accurate clinical ordering, dispensing cutoffs, and audit trails in medication management workflows.

strength entered bystr_ent_by

Identifier of the user or system responsible for creating or last updating a drug strength record in a pharmacy or formulary database. Supports audit trail requirements for medication data governance, tracking which pharmacist, clinician, or automated process submitted the drug concentration entry.

strength ethnicitystr_ethn

Ethnicity classification linked to a drug strength record, used in pharmacogenomics or population health research contexts where drug concentration requirements or dosing thresholds may vary across demographic groups. Supports analysis of strength appropriateness and prescribing patterns across diverse patient populations.

strength expiration datestr_exp_dt

Date after which a specific drug strength formulation is no longer considered valid for dispensing or clinical use. Used in pharmacy inventory management and formulary systems to prevent dispensing of outdated drug concentrations and ensure compliance with medication safety and regulatory standards.

PreviousPage 669 of 806Next