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 coderte_cd

The standardized alphanumeric identifier assigned to a specific medication administration route, such as oral, intravenous, or intramuscular. Enables consistent cross-system identification in pharmacy claims, clinical documentation, and drug utilization management platforms.

route commentrte_cmt

Free-text notation associated with a medication administration route record, capturing supplemental clinical instructions, exceptions, or contextual details not accommodated by structured fields. Used in pharmacy management systems and clinical workflows to document route-specific guidance or override rationale.

route completed daterte_cmpl_dt

The calendar date on which a medication administration route course or protocol was concluded. Recorded in clinical and pharmacy systems to mark the end of a defined delivery regimen, supporting medication reconciliation, treatment timeline analysis, and discharge documentation.

route confidential indicatorrte_conf_ind

A binary flag designating that a medication administration route record contains sensitive clinical information subject to restricted access controls. Applied in EHR and pharmacy systems to enforce privacy protections for routes associated with behavioral health, substance use, or reproductive care treatments.

route countrte_cnt

The total number of times a specific medication administration route has been recorded, ordered, or dispensed within a defined period or patient encounter. Used in pharmacy utilization analysis, clinical reporting, and formulary management to quantify route-level activity across populations.

route countryrte_ctry

The nation associated with the geographic location where a medication administration route is applied, dispensed, or regulated. Relevant in multinational pharmacy benefit management and clinical data systems where country-specific formulary rules, regulatory standards, or site-of-care designations must be tracked.

route created byrte_crtd_by

The unique identifier of the user or system process responsible for initially entering a medication administration route record into the clinical or pharmacy data system. Supports audit trail requirements, data governance accountability, and change management tracking across EHR and pharmacy platforms.

route created daterte_crtd_dt

The calendar date on which a medication administration route record was first entered into the clinical or pharmacy information system. Used for audit trail integrity, data lineage tracking, and longitudinal analysis of route assignments across patient encounters and formulary updates.

route created timerte_crtd_tm

The precise timestamp at which a medication administration route record was initially entered into the clinical or pharmacy information system. Supports audit trail requirements, workflow sequencing, and time-sensitive medication management analysis when date alone is insufficient for accurate event reconstruction.

route creatininerte_cr

The serum or urine creatinine value associated with a patient at the time a medication administration route was selected or modified. Relevant in clinical decision support systems where renal function directly influences route selection, dosing adjustments, or contraindication flags for renally cleared medications.

route daterte_dt

The calendar date associated with a medication administration route event, assignment, or status change. Used in pharmacy and clinical data systems to establish temporal context for route-specific documentation, enabling longitudinal tracking of delivery pathway changes throughout a patient's treatment history.

route datetimerte_dttm

The combined date and time value capturing when a medication administration route event or status change occurred. Provides precise temporal context in pharmacy dispensing, clinical order management, and infusion therapy systems where time-of-event accuracy is critical for medication safety and compliance reporting.

route dea numberrte_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance administration route record. Required in pharmacy and prescribing systems to validate prescriber authority when the selected delivery pathway involves Schedule II through V controlled medications subject to federal regulatory oversight.

route death daterte_death_dt

The recorded date of patient death associated with a medication administration route record. Used in clinical data systems and pharmacy management platforms to terminate active route orders, support mortality analysis, and ensure medication records are accurately closed following patient death during treatment.

route deleted daterte_del_dt

The calendar date on which a medication administration route record was marked for removal or soft-deleted within the clinical or pharmacy information system. Supports data governance, audit trail integrity, and regulatory compliance by preserving a historical record of when route data was retired from active use.

route deleted indicatorrte_del_ind

A binary flag designating that a medication administration route record has been logically removed from active use within the clinical or pharmacy system. Enables soft-delete functionality, preserving historical data integrity for audit, compliance, and longitudinal analysis while excluding the record from current operational workflows.

route descriptionrte_desc

The human-readable text label describing how a medication or treatment is administered, such as oral, intravenous, or topical. Used in pharmacy dispensing, medication orders, and clinical documentation to clearly communicate the intended administration pathway to clinicians and pharmacists.

route detailrte_dtl

Supplementary clinical information specifying the precise method or technique for a medication administration pathway, such as infusion rate, injection site, or delivery mechanism. Used in pharmacy and medication management systems to ensure accurate and safe drug delivery according to prescriber intent.

route discharge daterte_dsch_dt

The date on which a patient was discharged from an inpatient or outpatient facility in relation to a specific medication administration route. Used in clinical data systems to correlate treatment timelines with discharge events and support continuity of care planning and medication reconciliation.

route due daterte_due_dt

The scheduled date by which a specific medication administration via a defined route is expected to occur. Used in pharmacy and clinical workflow systems to manage medication scheduling, track overdue administrations, and ensure timely delivery of prescribed treatments to patients.

PreviousPage 591 of 806Next