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 durationrte_dur

The total length of time over which a medication is administered via a specific route, such as the infusion period for an intravenous drug. Used in pharmacy and clinical documentation systems to define treatment timelines, support dosing calculations, and ensure appropriate therapeutic exposure.

route emailrte_eml

The electronic mail address associated with the clinical entity or contact responsible for managing or coordinating a specific medication administration route. Used in healthcare communication systems to facilitate notifications, alerts, and coordination related to medication administration workflows and pharmacy operations.

route emergency indicatorrte_emerg_ind

A flag identifying whether a medication administration route is designated for emergency or urgent clinical use, such as emergency IV push protocols. Used in pharmacy and clinical decision support systems to trigger priority handling, override standard workflows, and ensure rapid medication delivery in critical care situations.

route end daterte_end_dt

The date on which a prescribed medication administration route is scheduled to conclude or was actually discontinued. Used in pharmacy and medication management systems to track the completion of treatment courses, support medication reconciliation, and identify when a specific administration pathway is no longer active.

route end timerte_end_tm

The specific time at which a medication administration via a defined route was completed or is scheduled to conclude. Used in pharmacy and nursing documentation systems to record precise administration timelines, support medication reconciliation, and ensure accurate clinical records for time-sensitive drug therapies.

route entered byrte_ent_by

The identifier of the user or clinician who recorded the medication administration route information in the clinical or pharmacy system. Used for audit trail and data integrity purposes in medication management systems to track data entry accountability and support compliance with medication safety and documentation standards.

route ethnicityrte_ethn

The ethnicity classification associated with a patient receiving medication via a specific administration route. Used in clinical research, population health analytics, and pharmacy data systems to identify disparities in medication administration practices, support diversity reporting, and inform culturally responsive care delivery.

route expiration daterte_exp_dt

The date after which a specific medication administration route designation, protocol, or associated order is no longer valid for clinical use. Used in pharmacy and clinical data systems to enforce protocol compliance, prevent use of outdated administration methods, and support medication safety governance and formulary management.

route external identifierrte_ext_id

A unique reference code assigned by an external system, such as a national drug database or interoperability platform, to identify a specific medication administration route. Used to facilitate data exchange between pharmacy systems, EHR platforms, and clinical data warehouses while maintaining consistent cross-system route identification.

route faxrte_fax

The facsimile number associated with the clinical entity or pharmacy responsible for processing or communicating a specific medication administration route. Used in healthcare communication workflows to transmit medication orders, prescription information, and administration instructions between prescribers, pharmacies, and care facilities.

route feerte_fee

The charge associated with administering a medication via a specific route, such as an intravenous infusion or intramuscular injection. Used in healthcare billing and claims processing systems to capture administration costs, support accurate reimbursement coding, and account for procedure-related fees in pharmacy and clinical financial records.

route first namerte_first_nm

The given name of the patient or clinician associated with a medication administration route record. Used in pharmacy and clinical documentation systems to identify the individual linked to a specific administration pathway, ensuring accurate patient matching and supporting safe medication administration practices.

route flagrte_flg

A binary or coded indicator used to mark a specific status or condition associated with a medication administration route, such as whether it is active, restricted, or requires special handling. Used in pharmacy and clinical decision support systems to trigger workflow rules, safety checks, or alerts during medication ordering and dispensing.

route frequencyrte_freq

The prescribed schedule or interval at which a medication is to be administered via a specific route, such as twice daily oral dosing or continuous IV infusion. Used in pharmacy and medication management systems to drive administration scheduling, support clinical decision making, and ensure accurate execution of medication orders.

route full namerte_full_nm

The complete standardized name describing the method by which a medication is administered, combining route type and any qualifying details into a single display value. Used in pharmacy systems, medication order interfaces, and clinical documentation to provide an unambiguous, human-readable label for each administration pathway.

route genderrte_gndr

The biological sex or gender identity of a patient associated with a specific medication administration route record. Used in clinical and pharmacy data systems to support gender-specific dosing protocols, demographic reporting, health disparity analyses, and compliance with population health and medication safety documentation requirements.

route glucoserte_gluc

Blood glucose measurement recorded in association with a specific drug administration route, such as oral or intravenous. Used in clinical documentation to monitor glycemic response and guide dosing decisions for medications affecting blood sugar levels.

route hemoglobinrte_hgb

Hemoglobin measurement recorded in association with a specific drug administration route, such as intravenous or intramuscular. Used in clinical documentation to assess patient baseline or response when administering medications that may affect red blood cell counts or oxygen-carrying capacity.

route history present illnessrte_hpi

Narrative description of a patient's presenting condition as it relates to the selected drug administration route. Captures clinician documentation of symptoms, onset, and relevant clinical context that informed the choice of administration pathway during medication ordering or clinical assessment.

route identifierrte_id

System-generated or standardized unique identifier assigned to a specific drug administration route record, such as oral, intravenous, or subcutaneous. Used to consistently reference and link route data across pharmacy, clinical, and claims systems throughout the medication management workflow.

PreviousPage 592 of 806Next