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 ratingrte_rtg

An assessed or calculated value reflecting the clinical suitability, effectiveness, or preference ranking of a specific drug administration route for a patient or condition. Used in pharmacy and clinical protocol systems to guide prescribing decisions and standardize medication delivery pathway selection across care settings.

route ratiorte_ratio

The proportional relationship between medication components or delivery parameters associated with a specific administration route, such as a concentration ratio for compounded IV solutions. Used in pharmacy data systems to ensure accurate drug preparation and delivery consistency across medication orders and clinical protocols.

route reasonrte_rsn

The clinical justification or explanatory text documenting why a specific drug administration route was selected for a medication order. Captured in pharmacy and prescribing systems to support clinical decision-making, regulatory compliance, and retrospective review of medication delivery pathway choices for a given patient encounter.

route received daterte_rcvd_dt

The calendar date on which a medication order or drug delivery instruction specifying a particular administration route was received by the pharmacy or clinical team. Used to track order intake timing, support turnaround time analysis, and ensure timely medication preparation and dispensing within care workflows.

route referencerte_ref

An external identifier or pointer linking a drug administration route record to a source system, clinical guideline, formulary entry, or standardized code set such as SNOMED or RxNorm. Used in pharmacy and medication management systems to ensure interoperability and traceability of route definitions across healthcare data platforms.

route resolution daterte_resol_dt

The date on which a medication administration route was discontinued, completed, or formally closed in the clinical or pharmacy record. Used to track the full lifecycle of medication orders, support treatment episode analysis, and ensure accurate medication history reporting in patient care and claims data systems.

route respirationrte_resp

The patient's respiratory rate or breathing status recorded in association with a specific drug administration route, particularly relevant for inhaled or respiratory medications. Captured in clinical documentation systems to monitor patient response to route-specific therapies such as nebulization or mechanical ventilation drug delivery.

route resultrte_rslt

The clinical outcome or measurement recorded following medication administration via a specific delivery pathway. Used in pharmacy and clinical data systems to assess therapeutic effectiveness, document patient response, and support quality reporting and comparative effectiveness analysis across different drug administration routes.

route revisionrte_rev

The version or iteration number reflecting updates made to a drug administration route specification within a medication order or clinical protocol. Tracked in pharmacy and EHR systems to maintain an accurate change history, support audit trails, and ensure clinical staff are acting on the most current medication delivery instructions.

route riskrte_rsk

A clinical risk level or danger assessment associated with using a specific drug administration route for a patient, such as elevated risk of infection for intravenous access or aspiration risk for oral medications. Used in pharmacy and care management systems to flag high-risk delivery pathways and trigger appropriate clinical safety interventions.

route routerte_rte

The standardized code or description identifying the specific pathway by which a medication is delivered into the patient's body, such as oral, intravenous, subcutaneous, or topical. A foundational pharmacy data element used across medication ordering, dispensing, administration records, and claims to define and communicate the intended delivery method.

route scorerte_scr

A calculated numeric value representing the clinical appropriateness, safety profile, or patient suitability rating for a specific drug administration route. Used in pharmacy decision support and clinical analytics systems to rank or prioritize delivery pathway options based on patient condition, medication properties, and evidence-based prescribing guidelines.

route sequencerte_seq

The ordered position number assigned to a drug administration route within a multi-step medication regimen or clinical protocol. Used in pharmacy and medication management systems to ensure correct scheduling and delivery order when multiple routes are prescribed, supporting safe and coordinated medication administration across care episodes.

route severityrte_sev

The seriousness classification assigned to a clinical condition or adverse event associated with a specific drug administration route, such as severity of an infusion reaction or injection site complication. Used in pharmacy safety reporting and clinical quality systems to prioritize interventions and document route-related adverse event outcomes.

route sexrte_sex

The biological sex of the patient linked to a specific drug administration route record. Used in pharmacy and clinical analytics to examine sex-based differences in medication delivery effectiveness, dosing requirements, and adverse event rates across administration pathways, supporting pharmacovigilance and population health research reporting.

route sourcerte_src

The originating system, prescriber, facility, or data feed from which a drug administration route record was generated or transmitted. Used in pharmacy and medication management data systems to track data provenance, support reconciliation across platforms, and ensure accuracy and accountability in medication order and dispensing workflows.

route start daterte_start_dt

The calendar date on which a medication administration route becomes active for a patient. Used in pharmacy and clinical documentation to establish when a specific delivery pathway, such as oral, intravenous, or subcutaneous, was initiated during a course of treatment.

route start timerte_start_tm

The specific time of day at which a medication administration route was initiated for a patient. Captured in pharmacy and clinical systems to support precise medication management, dosing interval calculations, and audit trails for route-based drug delivery protocols.

route staterte_st

The geographic state or province associated with a medication administration route record. Used in clinical and pharmacy data systems to support regional compliance, licensure verification, and jurisdiction-specific drug administration regulations tied to care delivery location.

route statusrte_sts

The current operational state of a medication administration route, such as active, discontinued, on-hold, or completed. Tracked in pharmacy and clinical systems to reflect real-time changes in a patient's drug delivery pathway and support safe medication management workflows.

PreviousPage 595 of 806Next