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 emergency indicatortx_emerg_ind

A flag identifying whether a therapeutic intervention was rendered or initiated under emergency conditions. Used in clinical and claims systems to distinguish emergent treatments from elective or routine care, supporting appropriate claims adjudication, triage documentation, and compliance with emergency treatment regulatory requirements.

treatment end datetx_end_dt

The date on which a therapeutic intervention concluded, was discontinued, or reached its prescribed completion point. Used in clinical records and care management systems to close treatment episodes, assess adherence to prescribed regimens, and support outcomes analysis for medication therapies, procedures, and ongoing clinical programs.

treatment end timetx_end_tm

The exact clock time a therapeutic intervention was completed or discontinued. Captured in clinical documentation to calculate treatment duration, support care coordination, and establish precise timelines for procedures, infusions, or therapy sessions in EHR encounter records.

treatment enrollment statustx_enrl_sts

Indicates whether a patient is currently active, pending, withdrawn, or completed within a specific treatment program or protocol. Used in disease management, clinical trials, and specialty care programs to track patient participation and trigger appropriate care management workflows.

treatment entered bytx_ent_by

Identifies the clinician, staff member, or system user who recorded the treatment order or documentation in the health information system. Supports audit trail requirements, accountability tracking, and clinical workflow oversight in EHR and care management platforms.

treatment ethnicitytx_ethn

Records the patient's ethnic background as it relates to treatment context, supporting analysis of health disparities, culturally appropriate care planning, and population health reporting. Used in clinical registries and quality measure stratification across diverse patient populations.

treatment expiration datetx_exp_dt

The date after which a prescribed treatment, authorization, or therapeutic plan is no longer valid or active. Critical for medication management, prior authorization tracking, and care plan renewals to prevent gaps in therapy or lapses in coverage within clinical and claims systems.

treatment external identifiertx_ext_id

A reference code assigned by an external system, partner organization, or interoperability exchange to uniquely identify a treatment record. Enables cross-system data matching, HIE transactions, and reconciliation between disparate clinical platforms, registries, or referral management systems.

treatment faxtx_fax

The facsimile number associated with the facility, provider, or program delivering a specific treatment. Used in clinical communication workflows to transmit treatment orders, referral documentation, or care summaries to receiving care sites or specialists.

treatment feetx_fee

The charge amount billed or assessed for a specific therapeutic intervention, reflecting the cost of services rendered. Used in revenue cycle management, claims adjudication, and patient billing workflows to support reimbursement processing and financial reporting.

treatment first nametx_first_nm

The given or first name component of a patient or contact associated with a treatment record. Used in clinical and administrative systems to support patient identification, personalized communication, and accurate record matching during care coordination workflows.

treatment flagtx_flg

A binary or coded indicator applied to a treatment record to signal a specific clinical condition, administrative action, or system status requiring attention. Used to trigger alerts, filter records for review, or denote exceptions such as high-risk therapies or pending authorizations.

treatment frequencytx_freq

Specifies how often a therapeutic intervention is to be administered, such as daily, weekly, or per session. Essential for medication administration records, care plan documentation, and clinical scheduling systems to ensure proper dosing intervals and adherence monitoring.

treatment full nametx_full_nm

The complete, unabbreviated name of the therapeutic intervention or associated patient, combining all name components into a single displayable value. Used in clinical documentation, patient-facing communications, and reporting interfaces to ensure clear, unambiguous identification.

treatment gendertx_gndr

Records the patient's gender as documented in the context of a treatment encounter. Used to support sex-specific clinical decision support, eligibility screening for gender-sensitive therapies, and population health stratification across clinical and administrative datasets.

treatment glucosetx_gluc

The blood glucose measurement recorded in association with a treatment encounter, used to monitor glycemic control in patients receiving diabetes management, parenteral nutrition, or corticosteroid therapy. Informs clinical decisions on insulin dosing and metabolic monitoring protocols.

treatment group numbertx_grp_nbr

A numeric identifier linking a treatment record to a specific insurance group plan or cohort. Used in claims processing, eligibility verification, and benefit coordination to associate treatment costs with the correct group coverage and facilitate accurate reimbursement.

treatment hemoglobintx_hgb

The hemoglobin concentration measured in relation to a treatment episode, used to assess anemia, transfusion thresholds, or response to therapies such as erythropoiesis-stimulating agents in dialysis or oncology. Supports clinical decision-making and lab result trending in chronic disease management.

treatment history present illnesstx_hpi

A narrative description of the patient's current symptoms, onset, and progression that prompted the therapeutic intervention. Documented by clinicians to provide clinical context for the treatment plan, support coding accuracy, and establish medical necessity in the health record.

treatment identifiertx_id

The primary unique key assigned to a treatment record within a clinical or administrative system. Used to reference, retrieve, and link treatment data across encounters, claims, care plans, and interoperability exchanges, ensuring consistent tracking throughout the patient's care continuum.

PreviousPage 753 of 806Next