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 active indicatorrte_actv_ind

A binary flag indicating whether a specific drug administration route, such as oral, intravenous, or subcutaneous, is currently active and available for use in clinical ordering systems. Used in pharmacy and medication management systems to control which routes appear in prescriber order entry workflows.

route active statusrte_actv_sts

The current operational state of a drug administration route within a pharmacy or medication management system, indicating whether the route is available, suspended, or retired. Governs route visibility in clinical ordering interfaces and ensures prescribers select only valid, approved administration pathways.

route admission daterte_admn_dt

The date a patient was admitted to a care setting in the context of a specific medication administration route record. Used in pharmacy and inpatient medication management systems to align drug route assignments with the patient's active admission episode and ensure appropriate route-based therapy.

route agerte_age

The patient's age recorded in association with a specific drug administration route order or event. Used in pharmacy systems to support age-based clinical decision rules, ensure route appropriateness for pediatric or geriatric patients, and flag contraindicated administration methods by age group.

route allowed amountrte_alwd_amt

The maximum reimbursable dollar amount approved by a payer for services delivered via a specific drug administration route, such as intravenous infusion. Used in claims adjudication and pharmacy billing to determine payment caps and assess provider reimbursement against contracted rate schedules.

route amountrte_amt

The monetary value associated with a drug administration route transaction, reflecting charges for supplies, nursing time, or infusion services tied to a specific route such as IV or intramuscular. Used in pharmacy billing and revenue cycle systems to support itemized claim line reporting.

route approved byrte_appr_by

The identifier or name of the clinician or pharmacist who authorized a specific drug administration route for a patient order. Used in medication management and pharmacy systems to maintain an approval audit trail, supporting regulatory compliance and clinical accountability for route-based prescribing decisions.

route arrival timerte_arrv_tm

The time at which a patient arrived at a care setting in association with a medication route administration record. Used in pharmacy and nursing workflow systems to calculate time-to-first-dose metrics, assess medication administration timeliness, and support quality reporting for route-specific drug delivery.

route arrived daterte_arrv_dt

The date a patient arrived at a care setting as recorded within a medication administration route record. Used in pharmacy and inpatient systems to establish the start of a medication episode, align route assignments to the patient encounter, and support longitudinal drug administration reporting.

route assessmentrte_asmt

The clinical evaluation or narrative documentation associated with determining or reviewing a patient's appropriate drug administration route, such as assessing vascular access for IV therapy. Captured in pharmacy and nursing records to support route selection decisions and document clinical rationale for route changes.

route balancerte_bal

The outstanding financial amount remaining on a billing account associated with a specific drug administration route charge, such as an unpaid infusion service fee. Used in pharmacy revenue cycle systems to track patient or payer balances and support accounts receivable management for route-based service charges.

route billed amountrte_bill_amt

The total dollar amount invoiced to a payer or patient for services rendered via a specific drug administration route, such as intravenous or intramuscular delivery. Used in pharmacy billing and claims systems to record gross charges submitted on a claim line before adjudication and contractual adjustments.

route birth daterte_birth_dt

The date of birth of the patient associated with a drug administration route record. Used in pharmacy and medication management systems to validate age-appropriate route selection, apply pediatric dosing rules, and ensure clinical decision support alerts are correctly triggered based on patient age and route combination.

route blood pressurerte_bp

The blood pressure measurement recorded in association with a specific drug administration route event, used to assess hemodynamic status before or after route-dependent medications such as antihypertensives or vasopressors. Supports clinical monitoring documentation and medication safety checks in inpatient pharmacy records.

route cancelled daterte_cncl_dt

The date on which a specific drug administration route order was cancelled for a patient. Used in pharmacy and medication management systems to record discontinuation events, support audit trails for route changes, and calculate active therapy duration for reporting and clinical review purposes.

route categoryrte_cat

The classification grouping assigned to a drug administration route, such as enteral, parenteral, or topical. Used in pharmacy formulary management and clinical decision support systems to organize available routes, apply category-level policies, and filter route options presented to prescribers during medication order entry.

route chief complaintrte_cc

The primary symptom or clinical reason documented at the time a medication administration route was established. Captures the presenting condition that influenced the selection of delivery pathway, such as oral, intravenous, or topical, in clinical and pharmacy records.

route childrte_chld

Identifies a subordinate administration route linked to a parent route in a hierarchical medication delivery classification structure. Used in pharmacy and clinical systems to represent branching pathways, such as a specific subcutaneous site nested under a broader parenteral route category.

route cityrte_city

The municipality associated with the location where a specific medication administration route is utilized or dispensed. Relevant in pharmacy benefit management and claims processing when geographic context is required for formulary compliance, distribution tracking, or site-of-care adjudication.

route classrte_cls

The categorical classification assigned to a medication administration route, grouping pathways such as enteral, parenteral, or topical into standardized tiers. Used in pharmacy systems and clinical data warehouses to organize formulary rules, dosing protocols, and drug utilization reporting.

PreviousPage 590 of 806Next