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 nametx_nm

Standardized display label identifying a therapeutic intervention within clinical documentation, care plans, and reporting systems. Provides a consistent human-readable reference used across EHR interfaces, care management platforms, and clinical data warehouses to describe the treatment being administered.

treatment notetx_nt

Free-text or structured annotation associated with a therapeutic intervention, capturing clinician observations, patient responses, care plan modifications, or administrative comments. Stored in clinical documentation systems to provide context that supplements structured treatment data fields.

treatment numbertx_nbr

Unique numeric or alphanumeric identifier assigned to a specific treatment episode or intervention in clinical and administrative systems. Used to link related clinical events, claims, and care records across encounters, enabling longitudinal tracking of a patient's treatment history.

treatment onset datetx_onset_dt

The calendar date on which symptoms, a condition, or a treatment protocol first began for the patient. Used in clinical documentation and claims processing to establish medical necessity timelines, measure treatment duration, and support retrospective analysis of care outcomes and disease progression.

treatment oxygen saturationtx_o2sat

The measured peripheral blood oxygen saturation level, expressed as a percentage, recorded during or in association with a clinical treatment. Captured as a vital sign in clinical documentation to assess respiratory status, monitor patient response to therapy, and inform treatment adjustments in acute and chronic care settings.

treatment paid amounttx_pd_amt

The actual dollar amount reimbursed by a payer or remitted for a specific treatment after adjudication, including contractual adjustments and applied benefits. Used in claims financial reconciliation, cost analysis, and provider payment reporting across medical and facility billing workflows.

treatment paid datetx_pd_dt

The calendar date on which payment was issued or posted for a treatment claim by the payer. Used in claims adjudication tracking, accounts receivable aging analysis, and financial reporting to reconcile remittances and measure payer turnaround times from date of service to payment.

treatment parenttx_prnt

A reference to the higher-level treatment record or encounter to which a subordinate treatment is associated in a hierarchical data model. Used in clinical data systems to link component procedures, sub-treatments, or follow-up interventions back to the originating treatment plan or episode of care.

treatment percentagetx_pct

A proportional value expressed as a percentage representing a specific measure related to a treatment, such as benefit coverage rate, coinsurance obligation, protocol completion, or dosage adjustment. Used in claims adjudication, care management, and clinical outcome calculations across healthcare data systems.

treatment periodtx_prd

The defined span of time during which a treatment protocol, therapy course, or clinical intervention is administered or authorized. Used in care management, utilization review, and claims processing to validate service dates, authorize continued treatment, and evaluate adherence to prescribed clinical timelines.

treatment phonetx_ph

The telephone contact number associated with the facility, clinic, or point of care where a treatment is administered. Used in clinical and administrative workflows to facilitate coordination of care, appointment scheduling, referral follow-up, and patient communications related to a specific treatment location.

treatment plantx_pln

Structured clinical document in EHR systems detailing prescribed interventions, therapies, medications, and goals for a patient's condition. Used in care management platforms to coordinate multidisciplinary services, track adherence, and measure outcomes against defined benchmarks.

treatment policy numbertx_pol_nbr

The insurance policy identifier associated with the coverage under which a treatment is authorized and billed. Used in claims processing and eligibility verification to link treatment records to the correct member insurance contract, ensuring accurate benefits application and payer routing during adjudication.

treatment preferred nametx_pref_nm

The clinician-designated or system-configured display name used to identify a treatment protocol or intervention in clinical interfaces and patient-facing documentation. Supports readability in care plans, clinical notes, and patient communication materials where standardized codes alone are insufficient for clear identification.

treatment pricetx_prc

The billed or established unit cost of a treatment before payer adjustments, discounts, or contractual allowances are applied. Used in healthcare financial systems to calculate expected reimbursement, support charge capture processes, and benchmark costs across service lines in both fee-for-service and value-based payment models.

treatment primary indicatortx_prim_ind

A flag or boolean indicator designating whether a treatment is the principal or primary intervention in a multi-treatment encounter or care episode. Used in clinical documentation and claims to distinguish the main treatment from secondary or adjunct therapies when multiple interventions are recorded for the same encounter.

treatment prioritytx_prty

A ranked or coded value indicating the clinical urgency or scheduling precedence assigned to a treatment relative to other interventions. Used in care management, surgical scheduling, and utilization management workflows to triage treatment needs, allocate resources, and sequence care delivery based on medical acuity or clinical guidelines.

treatment procedure datetx_proc_dt

The calendar date on which a clinical procedure or treatment intervention was physically performed on the patient. Used in claims submission, clinical documentation, and quality measurement to establish the date of service, validate timely filing, and support episode-of-care analytics and outcome assessments.

treatment pulsetx_pulse

The patient's heart rate in beats per minute recorded during or in association with a clinical treatment. Captured as a vital sign in clinical documentation to assess cardiovascular status, monitor patient stability throughout a procedure or therapy session, and inform clinical decision-making during treatment delivery.

treatment quantitytx_qty

The numeric count, volume, or units of a treatment administered or dispensed, such as number of sessions, dosage units, or service units billed. Used in clinical documentation, pharmacy dispensing records, and claims processing to validate billing accuracy, calculate totals, and support utilization review and cost analysis.

PreviousPage 755 of 806Next