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

treatment racetx_race

The patient's self-reported or documented racial classification recorded in association with a treatment encounter. Used in population health analytics, health equity reporting, and clinical research to identify disparities in treatment access, outcomes, and utilization patterns across demographic groups in compliance with regulatory reporting requirements.

treatment rangetx_rng

The defined minimum and maximum acceptable values for a clinical measurement, dosage, or parameter associated with a treatment protocol. Used in clinical decision support, quality monitoring, and lab or vital sign interpretation to flag out-of-range results, guide dosage adjustments, and ensure treatment remains within evidence-based therapeutic boundaries.

treatment ratetx_rt

The unit-based pricing or reimbursement rate applied to a treatment, representing the agreed-upon or standard charge per service unit between a payer and a billing entity. Used in claims adjudication, contract management, and financial modeling to calculate expected payment amounts and evaluate cost-effectiveness of care delivery.

treatment ratingtx_rtg

A scored or ranked assessment of a therapeutic intervention's effectiveness, quality, or appropriateness. Used in clinical outcome tracking to evaluate how well a treatment performed against expected benchmarks, supporting care plan adjustments and population health analytics.

treatment ratiotx_ratio

A calculated proportional value comparing treatment-related metrics, such as dose-to-response ratios or treatment frequency relative to expected protocols. Used in clinical analytics and pharmacy management to assess dosing adequacy, therapeutic efficiency, or comparative treatment utilization across patient populations.

treatment reasontx_rsn

The clinical justification or indication documented for initiating a specific therapeutic intervention. Captures the diagnosis, symptom, or clinical finding that prompted the treatment decision, supporting medical necessity documentation in claims processing and clinical record integrity.

treatment received datetx_rcvd_dt

The actual calendar date on which a patient received a specific therapeutic intervention. Distinct from scheduled or ordered dates, this field is critical for claims adjudication, care timeline reconstruction, and measuring gaps between treatment authorization and delivery in clinical workflows.

treatment referencetx_ref

An identifier or pointer linking a therapeutic intervention record to an external source, such as a clinical guideline, prior authorization number, referral, or related encounter. Used in care coordination and claims processing to establish traceability between treatment records and supporting documentation.

treatment resolution datetx_resol_dt

The calendar date on which the condition being treated was resolved, stabilized, or the treatment course was concluded. Used in chronic disease management and episode-of-care analytics to measure treatment duration, recovery timelines, and closure of active problem list items in clinical records.

treatment respirationtx_resp

The patient's respiration rate or respiratory status documented in the context of a specific therapeutic intervention. Captured as a vital sign component during treatment encounters, this value supports clinical monitoring, anesthesia records, emergency care documentation, and inpatient treatment tracking.

treatment resulttx_rslt

The documented clinical outcome or measured response following a therapeutic intervention. Records whether treatment achieved intended goals, such as symptom improvement, lab value normalization, or procedural success, and informs subsequent care planning, quality reporting, and outcomes-based reimbursement programs.

treatment review systemstx_ros

Documents which body systems were reviewed during clinical assessment of a therapeutic intervention, such as cardiovascular, respiratory, or neurological systems. Captured in clinical notes to support medical necessity determinations and care coordination across treatment episodes.

treatment revisiontx_rev

A versioned iteration number indicating that a treatment plan or order has been modified from its original form. Tracks amendments to dosing, frequency, approach, or clinical rationale, maintaining an audit trail of changes that supports care continuity, compliance review, and clinical documentation integrity.

treatment risktx_rsk

A clinician-assigned or algorithmically derived assessment of the potential harm, complication likelihood, or contraindication level associated with a specific therapeutic intervention. Used in clinical decision support, informed consent documentation, and care management programs to stratify patients by treatment-related safety concerns.

treatment routetx_rte

The anatomical or physiological pathway by which a therapeutic agent or intervention is administered, such as oral, intravenous, intramuscular, or topical. Documented in pharmacy dispensing records, medication administration logs, and clinical orders to ensure safe delivery and accurate claims coding.

treatment scheduled datetx_sched_dt

The calendar date on which a therapeutic intervention is planned to be administered or performed. Used in appointment scheduling systems, prior authorization workflows, and care coordination to manage resource allocation, patient notifications, and adherence tracking relative to actual treatment delivery dates.

treatment scheduled timetx_sched_tm

The specific time of day at which a therapeutic intervention is planned to occur. Used in clinical scheduling, inpatient care coordination, and medication administration timing to sequence care delivery, allocate clinical staff, and monitor adherence to time-sensitive treatment protocols.

treatment scoretx_scr

A quantitative value derived from a standardized clinical assessment tool or scoring algorithm applied to evaluate a patient's treatment status, response, or eligibility. Examples include pain scales, depression inventories, or disease activity scores used in care management, quality measurement, and outcomes reporting.

treatment sequencetx_seq

A numeric value indicating the ordered position of a therapeutic intervention within a multi-step treatment plan or care protocol. Used in oncology regimens, surgical care pathways, and chronic disease management to ensure treatments are administered in the correct clinical order and to track protocol adherence.

treatment service datetx_svc_dt

The date on which a clinical service or therapeutic intervention was rendered to the patient. A critical field in medical claims processing, this date anchors billing transactions, determines benefits eligibility, and establishes the timeline for episode-of-care analysis and coordination of benefits adjudication.

PreviousPage 756 of 806Next