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 timestampstr_ts

The combined date and time value recording when a drug concentration entry was created, modified, or captured in a pharmacy or clinical data system. Supports auditing, chronological tracking of medication strength changes, and time-based pharmacokinetic or therapeutic drug monitoring workflows.

strength titlestr_ttl

The formal descriptive label assigned to a drug concentration record within a pharmacy or drug reference system. Provides a standardized name or heading identifying the strength entry, supporting drug compendium organization, formulary displays, medication order descriptions, and clinical documentation.

strength totalstr_tot

The complete aggregate sum of all drug concentration values calculated across components or measurements in a pharmaceutical record. Used in pharmacy data systems to represent the final combined strength of a formulation, supporting compounding calculations, dispensing verification, and medication management reporting.

strength total countstr_tot_cnt

The total number of discrete drug concentration occurrences or entries recorded within a pharmacy or medication data system. Used to quantify how many strength values are associated with a drug record, supporting formulary analysis, drug utilization reporting, and pharmaceutical data quality management.

strength typestr_typ

A classification designating the category or nature of a drug concentration value, such as active ingredient strength, total strength, or base equivalent. Used in pharmacy and drug reference systems to distinguish between different strength representations within formulations, supporting accurate dispensing and clinical decision support.

strength updated datestr_upd_dt

The most recent date on which a drug concentration record was modified or revised within a pharmacy or formulary data system. Used to track changes to medication strength values over time, supporting data governance, formulary maintenance audits, and version control of pharmaceutical reference information.

strength urgencystr_urg

A classification indicating the time sensitivity or clinical priority level associated with a drug concentration value or related medication event. Used in pharmacy and clinical data systems to flag situations requiring expedited processing, such as urgent compounding requests or critical therapeutic drug monitoring results.

strength versionstr_ver

The sequential version number assigned to a drug concentration record to track revisions over its lifecycle in a pharmacy or drug reference system. Enables identification of the most current strength specification while preserving historical values, supporting formulary change management and regulatory documentation requirements.

strength zipstr_zip

The postal code associated with a drug concentration record, typically referencing the geographic location of a pharmacy, compounding facility, or dispensing site. Used in pharmacy data systems to link strength records to specific locations for distribution tracking, regulatory compliance, and regional formulary management.

study active indicatorstdy_actv_ind

A binary flag indicating whether a diagnostic imaging study is currently active and accessible within a radiology or clinical data system. Used to distinguish active examinations from cancelled, archived, or superseded studies, supporting worklist management, PACS integration, and radiology workflow prioritization.

study active statusstdy_actv_sts

A status value representing the current operational state of a diagnostic imaging examination within a radiology information or clinical data system. Indicates whether the study is in progress, completed, on hold, or inactive, supporting imaging workflow management, reporting queues, and PACS record maintenance.

study admission datestdy_admn_dt

The date a patient was admitted to a healthcare facility in relation to a diagnostic imaging study, linking the examination to an inpatient encounter. Used in radiology and clinical data systems to associate imaging orders with hospital stays, supporting episode-of-care analysis and inpatient utilization reporting.

study agestdy_age

The patient's age at the time a diagnostic imaging study was performed, typically expressed in years. Captured in radiology and clinical data systems to support age-appropriate protocol selection, pediatric versus adult imaging distinctions, population health analysis, and epidemiological research based on imaging data.

study allowed amountstdy_alwd_amt

The maximum reimbursable amount for a diagnostic imaging examination as determined by the payer contract or fee schedule. Represents the contracted rate ceiling used in radiology billing reconciliation, distinguishing between what was billed and what the payer will reimburse.

study amountstdy_amt

The total monetary value associated with a diagnostic imaging examination, capturing the gross charge before adjustments, discounts, or payer reductions. Used in radiology revenue cycle management to track financial transactions at the individual study level.

study approved bystdy_appr_by

Identifies the credentialed user, typically a radiologist or supervising clinician, who authorized the diagnostic imaging examination. Used in radiology workflow audit trails to maintain accountability and regulatory compliance for study authorization and sign-off processes.

study arrival timestdy_arrv_tm

The recorded timestamp indicating when the patient physically arrived at the imaging facility or radiology department for their scheduled examination. Used in radiology operations to measure patient throughput, wait times, and scheduling efficiency metrics.

study arrived datestdy_arrv_dt

The calendar date on which the patient presented to the imaging facility for their diagnostic examination. Used in radiology scheduling and operations reporting to track appointment adherence, no-show patterns, and patient flow across imaging departments.

study assessmentstdy_asmt

The radiologist's or interpreting clinician's structured clinical evaluation narrative for a diagnostic imaging examination. Captures findings, impressions, and conclusions derived from image interpretation, forming the core of the diagnostic radiology report.

study balancestdy_bal

The remaining unpaid financial obligation for a diagnostic imaging examination after insurance payments, adjustments, and partial payments have been applied. Used in radiology revenue cycle management to track outstanding patient or payer liability per individual study.

PreviousPage 674 of 806Next