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 arrived datetx_arrv_dt

The calendar date on which a patient arrived at a healthcare facility or clinic to begin or receive a treatment episode. Used in clinical operations and scheduling systems to establish care timelines, calculate wait times from referral to treatment, and support reporting on access-to-care metrics and appointment adherence rates.

treatment assessmenttx_asmt

A structured or narrative clinical evaluation documenting a patient's condition, progress, and response to a therapeutic intervention at a specific point in care. Used in EHR clinical documentation workflows to inform treatment plan adjustments, support interdisciplinary care team communication, and provide evidence for medical necessity and quality reporting purposes.

treatment balancetx_bal

The remaining unpaid amount owed by a patient or payer after payments and adjustments have been applied to a treatment encounter. Tracked in billing and revenue cycle systems to manage accounts receivable and outstanding patient financial obligations.

treatment billed amounttx_bill_amt

The total gross charges submitted to a payer or patient for a specific treatment or clinical service rendered. Represents the provider's standard fee before insurance adjustments, contractual discounts, or patient payments are applied in the revenue cycle.

treatment birth datetx_birth_dt

The patient's date of birth as recorded at the time of a treatment encounter. Used to verify patient identity, confirm eligibility, calculate age-based clinical thresholds, and validate demographic consistency across medical records and insurance claims.

treatment blood pressuretx_bp

The systolic and diastolic arterial pressure measurements recorded during a patient's treatment encounter, typically expressed in mmHg. Captured as a clinical vital sign to monitor cardiovascular status, guide treatment decisions, and track patient response to therapy over time.

treatment cancelled datetx_cncl_dt

The calendar date on which a scheduled or in-progress treatment was formally cancelled. Used in scheduling, utilization management, and revenue cycle systems to track cancellation patterns, rebook appointments, void associated charges, and analyze care continuity gaps.

treatment categorytx_cat

A structured classification grouping that organizes treatment encounters by clinical type, care setting, or service line such as preventive, acute, chronic, surgical, or rehabilitative. Used in reporting, utilization analysis, and population health management to segment and compare treatment patterns.

treatment charge amounttx_chrg_amt

The specific fee assessed for a treatment service prior to any insurance adjudication, negotiated rate reductions, or patient payments. Recorded in billing systems as the initial financial obligation tied to a procedure code or service rendered during a clinical encounter.

treatment chief complainttx_cc

The primary symptom, condition, or reason for seeking care as reported by the patient at the time of a treatment visit. Documented in clinical records to guide the diagnostic workup, establish medical necessity, support coding accuracy, and track presenting conditions across encounters.

treatment childtx_chld

A subordinate treatment record linked hierarchically to a parent treatment encounter, used to represent component services, split billing lines, or dependent procedures within a multi-step care plan. Supports relational data models in clinical and billing systems for complex treatment workflows.

treatment citytx_city

The name of the municipality where a treatment was delivered or where the patient resides at the time of the treatment encounter. Used in care coordination, geographic utilization analysis, network adequacy assessments, and claims processing to validate service location demographics.

treatment classtx_cls

A tiered classification assigned to a treatment that distinguishes its level of care intensity, service type, or clinical protocol category such as inpatient, outpatient, emergent, or elective. Used to apply appropriate reimbursement rules, utilization criteria, and reporting groupings across healthcare systems.

treatment codetx_cd

A standardized alphanumeric identifier such as a CPT, HCPCS, ICD procedure, or internal system code that uniquely represents a specific treatment or clinical service. Used across clinical, billing, and analytics systems to classify services, process claims, and support interoperability.

treatment coinsurance amounttx_coins_amt

The portion of a treatment's allowed amount that a patient is responsible for paying after the deductible has been met, calculated as a percentage defined by the member's health plan benefit structure. Tracked in claims adjudication and patient billing systems to determine member cost-sharing obligations.

treatment commenttx_cmt

An unstructured free-text field capturing supplementary notes, clinical observations, administrative remarks, or contextual details related to a treatment encounter. Used by clinicians or staff to document information that does not fit into structured data fields within clinical or billing records.

treatment completed datetx_cmpl_dt

The calendar date on which a treatment episode or clinical service was fully rendered and concluded. Recorded in clinical and billing systems to close the treatment record, trigger claim submission, measure treatment duration, and support outcome tracking and quality reporting workflows.

treatment confidential indicatortx_conf_ind

A flag designating that a treatment record contains sensitive clinical information subject to enhanced privacy protections, such as behavioral health, substance use, or reproductive services. Controls access permissions in clinical systems to ensure compliance with HIPAA and applicable state confidentiality regulations.

treatment copay amounttx_cpay_amt

The fixed dollar amount a member is required to pay out-of-pocket at the time a treatment service is rendered, as defined by their health plan benefit design. Collected at point of service and recorded in billing and claims systems to reconcile patient payments against adjudicated cost-sharing obligations.

treatment costtx_cst

The total direct and indirect expenses incurred in delivering a specific treatment, including clinical labor, supplies, facility overhead, and ancillary services. Used in cost accounting, value-based care analytics, and financial modeling to assess treatment efficiency and compare actual costs against reimbursement.

PreviousPage 751 of 806Next