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 noterte_nt

Free-text annotation associated with a drug administration route record in pharmacy or clinical systems. Captures supplemental instructions, clinical caveats, or special handling requirements not conveyed by structured fields, supporting accurate medication administration and pharmacist review workflows.

route numberrte_nbr

A unique numeric identifier assigned to a drug administration route within pharmacy or clinical information systems. Used to reference and track specific routes such as oral, intravenous, or intramuscular across medication order entry, pharmacy dispensing, and clinical documentation workflows.

route onset daterte_onset_dt

Records the calendar date when a specific drug administration route became clinically relevant or was initiated for a patient in clinical documentation systems. Captures the start of route-specific therapy or the date a route-related clinical condition or observation was first noted in the patient record.

route oxygen saturationrte_o2sat

Documents the peripheral oxygen saturation measurement recorded in association with a drug administration route event in clinical systems. Used to monitor patient respiratory status during or following administration of medications delivered via routes such as inhalation or intravenous infusion, supporting clinical safety workflows.

route paid amountrte_pd_amt

Records the dollar amount reimbursed or paid in association with a drug administration route on a pharmacy or medical claim. Used in claims adjudication and financial reconciliation to capture route-specific reimbursement values, supporting revenue cycle management and cost analysis reporting.

route paid daterte_pd_dt

Records the calendar date on which payment was issued for a claim or transaction associated with a specific drug administration route. Used in pharmacy claims and revenue cycle systems to track reimbursement timing, supporting financial reconciliation and accounts receivable management workflows.

route parentrte_prnt

Identifies the higher-level classification or parent record to which a drug administration route belongs within a hierarchical taxonomy in pharmacy or clinical systems. Supports grouping of related routes, such as linking specific injection routes under a broader parenteral administration category, enabling reporting and order set management.

route percentagerte_pct

Captures a proportional value associated with a drug administration route in pharmacy or clinical systems, such as the percentage of a dose delivered via a specific pathway in split-route therapies. Used in compounding, infusion management, or financial allocation contexts to quantify route-specific contributions.

route periodrte_prd

Defines the duration or time interval during which a specific drug administration route is active or applicable for a patient or medication order in pharmacy and clinical systems. Used to establish the valid timeframe for route-specific dosing schedules, clinical protocols, or formulary configurations.

route phonerte_ph

Stores a telephone contact number associated with a drug administration route record or its managing clinical unit in healthcare information systems. Used to facilitate communication with the pharmacy, nursing station, or clinical department responsible for administering medications via a specific route.

route preferred namerte_pref_nm

The standardized or preferred display label for a drug administration route used in clinical and pharmacy systems when multiple naming conventions exist. Ensures consistent presentation of route names such as intravenous or sublingual across medication order entry, patient documentation, and clinical reporting interfaces.

route pricerte_prc

Captures the monetary cost associated with a drug administration route in pharmacy or claims systems, reflecting supply, labor, or procedure costs tied to the delivery pathway such as intravenous infusion setup or inhalation therapy. Used in financial analysis, billing, and cost-of-care reporting workflows.

route primary indicatorrte_prim_ind

A flag indicating whether a specific drug administration route is designated as the primary pathway for a given medication order or treatment protocol in pharmacy or clinical systems. Used to distinguish the principal route from alternative or secondary routes when multiple administration options are documented.

route priorityrte_prty

Indicates the relative importance or preferred ordering sequence of a drug administration route within pharmacy or clinical decision support systems. Used when multiple routes are available for a medication, guiding clinicians and pharmacists toward the most clinically appropriate or formulary-preferred delivery pathway.

route procedure daterte_proc_dt

Records the calendar date on which a clinical procedure associated with a specific drug administration route was performed, such as central line placement for intravenous therapy or port access. Used in clinical documentation and medical claims to establish the service date for route-specific interventions.

route pulserte_pulse

Documents the patient heart rate measurement recorded in association with a drug administration route event in clinical systems. Used to monitor hemodynamic response during or following medication administration via routes such as intravenous infusion or inhalation, supporting patient safety and medication monitoring protocols.

route quantityrte_qty

The numeric count or volume associated with a specific drug administration route in pharmacy or medication order records. Captures the amount of medication to be delivered via a defined pathway such as oral, intravenous, or topical, supporting dispensing and clinical reconciliation workflows.

route racerte_race

The racial or ethnic classification of the patient associated with a specific drug administration route record. Used in pharmacy and clinical data analysis to identify disparities in medication delivery pathways, supporting population health equity reporting and outcomes stratification across demographic groups.

route rangerte_rng

The minimum and maximum acceptable value boundaries associated with a drug administration route, such as allowable dosage or infusion rate limits. Used in clinical decision support and pharmacy systems to validate that medication orders fall within safe and therapeutically effective parameters for a given delivery pathway.

route raterte_rt

The speed or frequency at which a medication is administered via a specific delivery pathway, such as milliliters per hour for an intravenous infusion. Captured in pharmacy and clinical documentation systems to ensure safe, accurate medication delivery and support charge capture and billing for infusion services.

PreviousPage 594 of 806Next