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 severitytx_sev

A graded assessment of how serious or intense a patient's condition is in relation to the treatment being administered. Used to classify disease burden, guide treatment intensity decisions, support ICD diagnosis coding specificity, and stratify patients in risk adjustment models and quality reporting programs.

treatment sextx_sex

The patient's biological sex as documented in the context of a specific therapeutic intervention, used to ensure sex-appropriate treatment protocols, dosing parameters, and eligibility criteria are applied. Relevant in pharmacy management, clinical trials data, and gender-specific preventive care guidelines.

treatment sourcetx_src

Identifies the originating system, facility, care setting, or data feed from which a treatment record was derived or initiated. Used in data integration and interoperability workflows to establish provenance of clinical information, support audit trails, and reconcile treatment data across disparate healthcare information systems.

treatment start datetx_start_dt

The calendar date on which a prescribed therapeutic intervention was initiated for a patient, such as chemotherapy, physical therapy, or medication regimen. Used in clinical and claims data to calculate treatment duration, monitor adherence, and coordinate care across providers and episodes.

treatment start timetx_start_tm

The clock time at which a therapeutic intervention was initiated during a clinical encounter or inpatient stay. Captured in procedure and encounter records to support scheduling accuracy, clinical documentation, billing, and time-sensitive treatment protocols such as infusion therapy or surgical procedures.

treatment statetx_st

The U.S. state or territory where a therapeutic intervention was administered or where the treating facility is located. Used in clinical and claims data for geographic reporting, licensure verification, regulatory compliance, and cross-state care coordination tracking.

treatment statustx_sts

Indicates the current phase or standing of a therapeutic intervention, such as active, completed, discontinued, or on hold. Used in clinical records and care management systems to track patient progress, trigger follow-up actions, and support population health reporting across treatment episodes.

treatment street addresstx_st_addr

The physical street address of the facility or location where a therapeutic intervention is being administered. Captured in clinical and claims data to support site-of-care tracking, facility credentialing, geographic access analysis, and patient care coordination across treatment settings.

treatment strengthtx_str

The concentration or dose amount of a medication or therapeutic agent administered during a treatment intervention, such as 500mg or 10mg/mL. Recorded in pharmacy and clinical records to ensure accurate dispensing, dosage verification, and adherence to prescribing guidelines and safety thresholds.

treatment subtotaltx_subtot

A partial sum of charges or units associated with a therapeutic intervention before final adjustments, taxes, or additional fees are applied. Used in claims and billing workflows to itemize service costs, support remittance reconciliation, and validate payment accuracy across treatment line items.

treatment surgery datetx_surg_dt

The calendar date on which a surgical procedure was performed as part of a therapeutic intervention. Captured in operative reports and claims data to track procedural timelines, coordinate post-surgical care, measure recovery outcomes, and support prior authorization and reimbursement workflows.

treatment system identifiertx_sys_id

A system-generated unique identifier assigned to a therapeutic intervention record within a clinical or administrative data platform. Used to link treatment data across EHR, claims, and care management systems, enabling accurate record matching, longitudinal tracking, and audit trail maintenance.

treatment targettx_tgt

The specific clinical objective, anatomical site, or measurable outcome that a therapeutic intervention is designed to address, such as a tumor site, HbA1c reduction, or blood pressure threshold. Used in oncology, chronic disease management, and care planning to monitor treatment effectiveness and goal attainment.

treatment taxonomy codetx_tax_cd

The standardized National Uniform Claim Committee taxonomy code identifying the clinical specialty or provider type associated with delivering a therapeutic intervention. Used in claims processing and credentialing to route services correctly, validate scope of practice, and support specialty-based reimbursement determinations.

treatment temperaturetx_temp

The recorded body temperature measurement taken in association with a therapeutic intervention, used as a vital sign to assess patient condition, monitor treatment response, or detect adverse reactions. Captured in clinical documentation to support clinical decision-making, triage protocols, and longitudinal vital sign trending.

treatment termination datetx_term_dt

The calendar date on which a therapeutic intervention was formally ended, whether due to completion, discontinuation, or patient withdrawal. Used in clinical and claims records to calculate total treatment duration, trigger care transitions, assess outcomes, and support authorization and billing closure workflows.

treatment timetx_tm

The specific time of day at which a therapeutic intervention was delivered or documented during a clinical encounter. Recorded in clinical and procedural records to support scheduling workflows, verify service delivery timelines, and ensure accurate documentation for billing and quality reporting purposes.

treatment timestamptx_ts

The combined date and time value marking when a therapeutic intervention was recorded, initiated, or updated in a clinical data system. Used to establish precise event sequencing in EHR and claims workflows, support audit trails, and enable time-based analysis of treatment delivery and clinical outcomes.

treatment titletx_ttl

The formal name or label assigned to a therapeutic intervention, such as a protocol name, regimen title, or procedure designation. Used in clinical documentation and care management systems to standardize treatment references, facilitate communication across care teams, and support reporting and quality measurement workflows.

treatment totaltx_tot

The aggregate sum of all charges, units, or services associated with a complete therapeutic intervention after all applicable line items are included. Used in claims and billing workflows to calculate final reimbursement amounts, validate payment accuracy, and support cost reporting and financial reconciliation processes.

PreviousPage 757 of 806Next