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 indexrte_idx

Numeric position or sequence value assigned to a drug administration route within an ordered list or dataset. Used in pharmacy and clinical systems to maintain consistent ordering of route options, support display logic, and enable programmatic navigation across route reference tables.

route indicatorrte_ind

Boolean or coded flag that signals a specific condition or status associated with a drug administration route, such as whether a route is active, preferred, or restricted for a given medication. Used in pharmacy and clinical decision support systems to control route availability during medication ordering.

route instructionrte_instr

Textual guidance associated with a specific drug administration route, detailing how the medication should be prepared, delivered, or monitored. Used in pharmacy dispensing and nursing administration workflows to ensure safe and accurate execution of the prescribed administration pathway.

route keyrte_key

Reference key value used to link a drug administration route record to related tables or systems, such as medication formularies, clinical protocols, or order sets. Supports relational data integrity across pharmacy, clinical documentation, and healthcare information systems.

route labelrte_lbl

Human-readable display text representing a drug administration route, such as 'Oral,' 'Intravenous,' or 'Topical.' Used in pharmacy and clinical interfaces to present route options clearly to prescribers, pharmacists, and nursing staff during medication ordering and administration documentation.

route languagerte_lang

Language code or designation associated with the display text or instructions for a drug administration route. Used in multilingual pharmacy and clinical systems to present route labels and guidance in the appropriate language for clinical staff or patient-facing medication documentation.

route last namerte_last_nm

Family surname of the clinician, pharmacist, or staff member associated with a drug administration route record or modification event. Used in audit trail and clinical documentation contexts to attribute route-related entries to the responsible individual within the healthcare system.

route legal namerte_legal_nm

Officially registered full name of the clinician or staff member associated with a drug administration route record or authorization event. Used in credentialing, audit, and clinical documentation systems to ensure route entries are attributed to a verified, legally recognized individual.

route levelrte_lvl

Hierarchical tier assigned to a drug administration route within a clinical or formulary classification structure. Used in pharmacy and clinical systems to organize routes by complexity, invasiveness, or care setting, supporting tiered access controls and clinical decision support rule configurations.

route license numberrte_lic_nbr

Professional license identifier of the clinician or pharmacist associated with authorizing or documenting a drug administration route. Used in clinical and pharmacy systems to verify credentials and maintain regulatory compliance when linking route selections to licensed healthcare practitioners.

route marital statusrte_mar_sts

Marital status of a patient or individual associated with a drug administration route record, typically captured when route selection is documented as part of a broader clinical encounter. Used in population health and analytics contexts to support demographic stratification of medication administration data.

route master identifierrte_mstr_id

Enterprise-level master identifier that uniquely represents a drug administration route across all systems within a healthcare organization. Used to reconcile route records during data integration, system migrations, and cross-platform reporting, ensuring consistent reference to the same route definition enterprise-wide.

route maximumrte_max

Upper limit value defined for a drug administration route, such as the maximum allowable dose volume or infusion rate for a given pathway. Used in pharmacy and clinical decision support systems to enforce safety thresholds and trigger alerts when medication orders exceed route-specific constraints.

route middle namerte_mid_nm

Middle name or initial of the clinician, pharmacist, or staff member associated with a drug administration route record or documentation event. Used in audit trail and clinical attribution contexts to disambiguate individuals with similar names when linking route entries to responsible personnel.

route minimumrte_min

Lower limit value defined for a drug administration route, such as the minimum dose volume or infusion rate considered clinically appropriate for a given pathway. Used in pharmacy and clinical decision support systems to flag orders that fall below the effective threshold for the selected administration route.

route mobilerte_mob

Mobile phone number of the clinician, pharmacist, or staff member associated with a drug administration route record or clinical workflow event. Used in care coordination and notification systems to enable direct contact with the responsible individual regarding route-related medication orders or administration updates.

route modified byrte_mod_by

Identifies the user or system that last updated a drug administration route record in pharmacy or clinical systems. Captures the username or ID of the individual who modified route details such as description, status, or associated clinical parameters, supporting audit trail requirements.

route modified daterte_mod_dt

Records the calendar date when a drug administration route record was last updated in pharmacy or clinical information systems. Used in audit trails to track when route definitions, descriptions, or clinical parameters were changed, supporting data governance and version control workflows.

route modified timerte_mod_tm

Records the specific time of day when a drug administration route record was last updated in pharmacy or clinical information systems. Combined with route modified date, provides a precise timestamp for audit trail purposes, supporting data governance and change tracking requirements.

route namerte_nm

The human-readable label assigned to a drug administration route, such as oral, intravenous, subcutaneous, or topical. Used in pharmacy systems, medication order entry, and clinical documentation to clearly communicate the intended pathway for drug delivery to clinicians and pharmacists.

PreviousPage 593 of 806Next