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 indextx_idx

A sequential or ranked numeric value assigned to a treatment within a series, protocol, or encounter record. Used to order multiple treatments chronologically or by priority within care plans, chemotherapy cycles, or longitudinal therapy sequences in clinical data systems.

treatment indicatortx_ind

A coded or boolean value signifying the presence, absence, or specific classification of a treatment condition or attribute. Used in clinical analytics, quality reporting, and care management workflows to filter patient populations, trigger interventions, or denote protocol compliance status.

treatment instructiontx_instr

Narrative guidance text associated with a specific therapeutic intervention, detailing administration steps, precautions, or care protocols. Captured in clinical documentation to ensure consistent delivery of treatment across care settings and provider handoffs.

treatment keytx_key

System-generated or standardized lookup reference value that uniquely identifies a therapeutic intervention within clinical data systems. Used to join treatment records across EHR, care management, and clinical data warehouse tables for reporting and analytics.

treatment labeltx_lbl

Human-readable display text associated with a therapeutic intervention, used in clinical interfaces, patient-facing documentation, and reporting outputs. Provides a standardized name for the treatment as it appears across care management and clinical workflow systems.

treatment languagetx_lang

Indicates the language in which treatment instructions, patient education materials, or care plan documentation are provided. Used in clinical settings to ensure patient comprehension and support language-concordant care delivery for diverse patient populations.

treatment last nametx_last_nm

Family surname of the patient or clinician associated with a treatment record. Typically captured to link the treatment episode to a specific individual within EHR or care management systems where person-level identification is required for clinical documentation.

treatment legal nametx_legal_nm

Officially registered name associated with a therapeutic intervention or linked individual, as recognized by licensing or regulatory bodies. Used in clinical and administrative records to ensure compliance with documentation standards and accurate identity matching.

treatment leveltx_lvl

Designates the hierarchy or intensity tier of a therapeutic intervention within a structured care pathway or treatment protocol. Used in clinical decision support and utilization management to differentiate step-therapy stages, acuity levels, or authorization requirements.

treatment license numbertx_lic_nbr

Professional license identifier associated with the clinician authorized to prescribe or administer a therapeutic intervention. Captured in clinical and claims records to support credentialing validation, regulatory compliance, and audit trail requirements.

treatment marital statustx_mar_sts

Marital status of the patient associated with a treatment record, captured during clinical intake or enrollment. Used in population health analytics and social determinants of health assessments to contextualize care needs and support care coordination planning.

treatment master identifiertx_mstr_id

Enterprise master identifier that uniquely resolves a therapeutic intervention record across multiple clinical and administrative systems. Supports patient matching, data deduplication, and longitudinal treatment tracking within health information exchange and data warehouse environments.

treatment maximumtx_max

Upper boundary value defined for a therapeutic intervention, such as maximum allowable dose, duration, frequency, or authorized units. Used in clinical decision support, utilization management, and pharmacy benefit systems to enforce safety thresholds and coverage limits.

treatment medical record numbertx_mrn

Facility-assigned medical record number linking a therapeutic intervention to a specific patient encounter within a clinical system. Used to associate treatment episodes with the correct patient record for longitudinal care tracking, reporting, and clinical documentation integrity.

treatment middle nametx_mid_nm

Middle name or initial of the patient or clinician associated with a treatment record. Captured in clinical systems to improve identity resolution accuracy and reduce duplicate record creation when matching individuals across EHR and health information exchange platforms.

treatment minimumtx_min

Lower boundary value defined for a therapeutic intervention, such as minimum effective dose, session frequency, or required duration. Referenced in clinical protocols and utilization management systems to establish baseline thresholds for treatment authorization and safety compliance.

treatment mobiletx_mob

Mobile phone number associated with the patient or caregiver linked to a treatment record. Used in care coordination and patient engagement workflows to facilitate appointment reminders, treatment adherence outreach, and follow-up communications related to active therapeutic interventions.

treatment modified bytx_mod_by

User identifier of the clinician, administrator, or system process that last updated a treatment record. Captured as part of the audit trail in clinical data systems to support accountability, change tracking, and compliance review of therapeutic intervention documentation.

treatment modified datetx_mod_dt

Calendar date on which a treatment record was most recently updated in the clinical or administrative system. Captured as part of the audit trail to track changes to therapeutic intervention data, support version control, and enable longitudinal analysis of treatment modifications.

treatment modified timetx_mod_tm

Timestamp indicating the exact time a treatment record was last updated within the clinical or administrative system. Used in conjunction with the modified date to provide a precise audit trail for therapeutic intervention changes, supporting data governance and compliance reviews.

PreviousPage 754 of 806Next