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

dosage active indicatordos_actv_ind

A binary flag indicating whether a medication dosage record is currently active and in use within a patient's medication regimen. Used in pharmacy systems and EHR medication management to distinguish current prescriptions from discontinued, completed, or historical dosage entries during clinical review.

dosage active statusdos_actv_sts

The current operational state of a medication dosage record, with values such as active, suspended, completed, or cancelled. Used in pharmacy and EHR systems to manage the medication administration lifecycle, support medication reconciliation workflows, and ensure accurate real-time visibility into a patient's drug therapy.

dosage addressdos_addr

The physical location text associated with a medication dosage record, typically referencing the prescribing facility, dispensing pharmacy, or patient delivery address in pharmacy and PBM systems. Used by data engineers to support medication fulfillment tracking, geographic analysis, and fraud detection workflows.

dosage adjustment amountdos_adj_amt

The numeric value representing a modification applied to an original medication dosage, such as a dose reduction due to renal impairment or a titration increase during therapy. Captured in clinical and pharmacy systems to document intentional therapeutic changes and support pharmacist and prescriber review.

dosage admission datedos_admn_dt

The hospital or facility admission date linked to a specific medication dosage record in EHR and claims systems. Used by data engineers to align inpatient medication administration timelines, validate claims adjudication logic, and support episode-of-care grouping in clinical analytics platforms.

dosage agedos_age

The patient's age at the time a medication dosage was prescribed or administered, used to verify age-appropriate dosing thresholds. Critical in pediatric and geriatric pharmacy systems where weight- and age-based dosing calculations are required to ensure therapeutic safety and avoid over- or under-dosing.

dosage allowed amountdos_alwd_amt

The maximum reimbursable dollar amount a payer will cover for a specific medication dosage under the patient's pharmacy benefit plan. Used in pharmacy claims adjudication to determine plan liability, calculate member cost-sharing obligations, and flag dosage quantities that exceed covered benefit limits.

dosage amountdos_amt

The monetary or numeric quantity value associated with a medication dosage record in pharmacy, PBM, or claims systems, representing either the prescribed dose quantity or the financial cost of the dispensed medication. Used by data engineers for drug cost analysis, formulary validation, and claims reconciliation.

dosage approval statusdos_appr_sts

Indicates the current authorization state of a prescribed medication dosage within clinical workflows. Tracks whether the dosage has been pending review, approved, rejected, or requires modification by an authorized clinical staff member before dispensing or administration.

dosage approved bydos_appr_by

Identifies the clinician, pharmacist, or authorized healthcare user who reviewed and approved a prescribed medication dosage. Captured in pharmacy and medication management systems to maintain an audit trail of dosage authorization and clinical accountability for patient safety.

dosage arrival timedos_arrv_tm

Records the time at which a medication dosage physically arrived at the dispensing location, such as a pharmacy, nursing unit, or infusion center. Used in medication management workflows to track delivery timelines and ensure timely administration to patients.

dosage arrived datedos_arrv_dt

Records the calendar date on which a medication dosage was received at the dispensing or administration location. Used in pharmacy and clinical medication tracking systems to monitor supply chain delivery, restocking timelines, and dosage availability for patient care.

dosage assessmentdos_asmt

Contains the clinical evaluation narrative completed by a prescriber or pharmacist when reviewing a medication dosage. Documents findings such as appropriateness of dose, patient tolerance, therapeutic response, and any clinical rationale supporting dosage adjustments or continuation.

dosage balancedos_bal

The remaining outstanding quantity or financial amount associated with a medication dosage record in PBM and pharmacy management systems, such as remaining days supply or unpaid cost-sharing balance. Used by data engineers to monitor prescription fulfillment gaps and member liability in adherence analytics.

dosage billed amountdos_bill_amt

Represents the total dollar amount invoiced to a payer or patient for a specific medication dosage on a pharmacy or medical claim. Used in revenue cycle and claims processing systems to reconcile medication charges against reimbursement and contractual payment rates.

dosage birth datedos_birth_dt

The patient date of birth associated with a medication dosage record in pharmacy, PBM, and EHR systems. Used by data engineers as a key matching attribute for member identity resolution, pediatric dosage validation, age-band stratification, and cross-system medication record deduplication.

dosage blood pressuredos_bp

Captures the patient's blood pressure reading recorded at the time of medication dosage administration or prescribing. Used in clinical medication management to monitor hemodynamic response, assess dosage safety, and support dosage titration decisions for cardiovascular or antihypertensive therapies.

dosage cancelled datedos_cncl_dt

Records the calendar date on which a previously ordered medication dosage was cancelled prior to dispensing or administration. Used in pharmacy and clinical systems to document discontinuation events, support medication reconciliation, and maintain accurate active medication records.

dosage categorydos_cat

The grouping classification applied to a medication dosage record in pharmacy and PBM systems, such as acute, chronic, specialty, or preventive drug categories. Used by data engineers to segment medication data for formulary analysis, therapeutic class reporting, and population health stratification workflows.

dosage charge amountdos_chrg_amt

Represents the gross charge applied to a medication dosage before insurance adjustments, discounts, or contractual write-offs. Captured in pharmacy billing and revenue cycle systems to establish the starting financial value for claims adjudication and reimbursement calculations.

PreviousPage 199 of 806Next