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

route strengthrte_str

The concentration or potency of a medication associated with a specific administration route, expressed in units such as mg, mcg, or mg/mL. Used in pharmacy records to ensure accurate dosing calculations and verify that drug strength aligns with the prescribed delivery pathway.

route subtotalrte_subtot

A partial aggregated value representing a subset of medication administrations or dosing events associated with a specific route. Used in pharmacy analytics and clinical reporting to summarize route-level activity within a defined segment of a patient encounter or time period.

route surgery daterte_surg_dt

The date on which a surgical procedure is associated with a specific medication administration route. Used in perioperative clinical records to correlate route assignments, such as epidural or IV, with operative events and support post-surgical medication management tracking.

route targetrte_tgt

The intended anatomical site, physiological system, or therapeutic destination for a medication administration route. Used in clinical and pharmacy documentation to specify where drug delivery is directed, such as systemic circulation, a specific organ, or a localized treatment area.

route taxonomy coderte_tax_cd

A standardized classification code that categorizes a medication administration route within a recognized coding system. Used in pharmacy and clinical data systems to consistently identify and distinguish route types, supporting interoperability, reporting, and formulary management across healthcare platforms.

route temperaturerte_temp

The temperature value associated with a medication administration route, either the required storage temperature for a drug prior to delivery or the patient's body temperature at the time of administration. Used in pharmacy and clinical records to ensure safe drug handling and patient monitoring compliance.

route termination daterte_term_dt

The calendar date on which a medication administration route was discontinued or expired for a patient. Recorded in pharmacy and clinical systems to mark the end of a specific delivery pathway and support medication reconciliation, therapy transitions, and historical treatment documentation.

route timerte_tm

The recorded time of day associated with a medication administration route event. Used in pharmacy and clinical documentation to capture when a specific delivery pathway was active, administered, or modified, supporting dosing schedules, compliance tracking, and clinical audit requirements.

route timestamprte_ts

The combined date and time value marking a specific event related to a medication administration route, such as creation, modification, or administration. Used in pharmacy and clinical systems to maintain precise chronological audit trails for drug delivery pathway activity across patient encounters.

route titlerte_ttl

The formal descriptive name assigned to a medication administration route, such as Intravenous Infusion or Oral Tablet. Used in pharmacy and clinical documentation to clearly identify the delivery pathway in patient records, prescriptions, medication orders, and clinical reporting workflows.

route totalrte_tot

The cumulative aggregated value representing all medication administrations or dosing events associated with a specific route across a defined period or encounter. Used in pharmacy analytics and clinical reporting to quantify total route-level drug delivery activity for a patient or population.

route total countrte_tot_cnt

The total number of distinct medication administration events or occurrences associated with a specific route within a defined time period or patient encounter. Used in pharmacy and clinical analytics to measure route utilization frequency and support medication management reporting.

route typerte_typ

The classification category of a medication administration route, distinguishing pathways such as enteral, parenteral, topical, inhalation, or transdermal. Used in pharmacy and clinical systems to standardize route categorization across medication orders, drug utilization reporting, and treatment protocol documentation.

route updated daterte_upd_dt

The most recent calendar date on which a medication administration route record was modified or revised. Tracked in pharmacy and clinical systems to maintain accurate data lineage, support audit compliance, and identify when changes to a patient's drug delivery pathway were last recorded.

route urgencyrte_urg

The time-sensitivity classification assigned to a medication administration route, indicating how quickly the drug must be delivered via the specified pathway, such as STAT, urgent, or routine. Used in pharmacy and clinical systems to prioritize drug preparation, dispensing, and delivery workflows.

route versionrte_ver

The sequential version number assigned to a medication administration route record, incremented each time the record is modified or updated. Used in pharmacy and clinical data systems to track the revision history of a route definition, supporting audit trails, data integrity, and change management processes.

route ziprte_zip

The postal code associated with a medication or treatment administration route location, such as a pharmacy, infusion center, or clinical site. Used in pharmacy and clinical operations to identify the geographic location where a specific administration pathway is based or managed.

sample active indicatorsmpl_actv_ind

A binary flag indicating whether a collected biological specimen, such as blood, urine, or tissue, is currently active and available for laboratory processing or analysis. Inactive samples may be expired, exhausted, rejected, or otherwise removed from the testing workflow in the laboratory information system.

sample active statussmpl_actv_sts

A status code describing the current lifecycle state of a collected biological specimen within the laboratory workflow. Common values include active, inactive, pending, rejected, or archived, reflecting whether the sample is available for testing, under analysis, or no longer viable for laboratory use.

sample admission datesmpl_admn_dt

The date on which the patient associated with a collected biological specimen was admitted to a hospital or clinical facility. Used in laboratory and clinical data systems to correlate specimen collection timing with the patient's inpatient encounter for diagnostic and reporting purposes.

PreviousPage 596 of 806Next