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 counttx_cnt

The total number of discrete treatment encounters, sessions, or service units delivered to a patient within a defined period or care episode. Used in utilization management, population health analytics, and claims reporting to measure treatment frequency and monitor adherence to care protocols.

treatment countrytx_ctry

The name or standardized code of the country where a treatment was administered or where the patient is domiciled at the time of the treatment encounter. Used in international claims processing, coordination of benefits, and geographic reporting to support cross-border care and regulatory compliance workflows.

treatment created bytx_crtd_by

Identifies the user, clinician, or system that entered the treatment record into the clinical system. Used in audit trails and clinical workflows to track authorship of therapeutic interventions such as medication orders, procedures, or care plans within EHR environments.

treatment created datetx_crtd_dt

The calendar date on which a treatment record was originally entered into the clinical system. Used in audit and compliance tracking to establish when a therapeutic intervention such as a medication regimen, procedure order, or care plan was first documented in the health record.

treatment created timetx_crtd_tm

The timestamp indicating when a treatment record was first entered into the clinical system. Combined with the created date, this supports precise audit trail documentation of therapeutic interventions including medication orders, care plan entries, and procedure authorizations in clinical workflows.

treatment creatininetx_cr

Records the serum or urine creatinine lab value associated with a patient's treatment episode. Used to assess renal function before, during, or after therapeutic interventions such as nephrotoxic drug administration, dialysis, or chemotherapy where kidney function monitoring is clinically required.

treatment datetx_dt

The calendar date on which a therapeutic intervention was administered or performed. Used across clinical and claims systems to record when a patient received a specific treatment such as a surgical procedure, infusion therapy, physical therapy session, or prescribed medication administration.

treatment datetimetx_dttm

The combined date and time at which a therapeutic intervention was administered or documented. Provides precise temporal tracking for time-sensitive treatments such as intravenous medication infusions, emergency procedures, or surgical interventions recorded in clinical or hospital information systems.

treatment dea numbertx_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance prescriber involved in a treatment record. Used in pharmacy and clinical systems to validate prescribing authority for Schedule II-V medications and ensure regulatory compliance with federal controlled substance laws.

treatment death datetx_death_dt

The recorded date of patient death as it relates to an active or concluded treatment episode. Used in clinical registries, case management systems, and outcomes reporting to track mortality events in relation to therapeutic interventions such as oncology treatment, chronic disease management, or end-of-life care.

treatment deductible amounttx_ded_amt

The dollar amount applied toward a patient's insurance deductible in connection with a specific treatment or therapeutic service. Used in claims adjudication and member cost-sharing calculations to determine patient financial liability before insurance coverage begins for the treatment rendered.

treatment deleted datetx_del_dt

The calendar date on which a treatment record was marked as deleted or voided within the clinical or administrative system. Used in audit trail management to track when a therapeutic intervention entry was removed, retracted, or deactivated, supporting data integrity and compliance review processes.

treatment deleted indicatortx_del_ind

A flag denoting whether a treatment record has been logically deleted or voided in the system without physical removal. Used in clinical data management to exclude retracted therapeutic intervention records from active reporting while preserving the original entry for audit, compliance, and historical reference purposes.

treatment descriptiontx_desc

A human-readable text narrative that describes the nature, type, or purpose of a therapeutic intervention. Used in clinical documentation and reporting to convey the clinical intent of a treatment such as a surgical procedure, medication therapy, rehabilitation program, or diagnostic intervention in plain language.

treatment detailtx_dtl

Granular clinical or administrative information describing specific components of a therapeutic intervention, such as dosage parameters, procedure steps, site of service, or clinical rationale. Supports detailed documentation needs in EHR systems, clinical decision support, and treatment plan management workflows.

treatment discharge datetx_dsch_dt

The date on which a patient was formally discharged from an inpatient or facility-based treatment episode. Used in hospital and claims systems to calculate length of stay, trigger post-discharge care coordination, and support billing for inpatient, skilled nursing, or rehabilitation treatment encounters.

treatment due datetx_due_dt

The scheduled or anticipated date by which a treatment, follow-up intervention, or associated clinical action must be completed or initiated. Used in care management and clinical workflow systems to track pending therapeutic interventions, recurring treatment schedules, and patient adherence to prescribed care plans.

treatment durationtx_dur

The total length of time over which a therapeutic intervention is administered or intended to be maintained. Used in clinical documentation, care planning, and pharmacy systems to define treatment course length for medication regimens, radiation therapy cycles, physical rehabilitation programs, or chronic disease management protocols.

treatment effective datetx_eff_dt

The date on which a therapeutic intervention becomes clinically active or authorized for administration. Used in care plan management, medication order tracking, and clinical workflows to establish when a prescribed treatment such as a drug therapy, procedure authorization, or care protocol is considered valid and actionable.

treatment emailtx_eml

The electronic mail address associated with a treatment-related communication record, such as a care coordinator, referring provider, or patient contact linked to a therapeutic intervention. Used in care coordination and clinical communication workflows to route treatment notifications, referral confirmations, or follow-up instructions.

PreviousPage 752 of 806Next