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 total counttx_tot_cnt

The cumulative number of occurrences, sessions, or units recorded for a therapeutic intervention over a defined period. Used in clinical and claims analytics to assess treatment volume, monitor utilization patterns, validate authorization limits, and support population health and outcome reporting across patient cohorts.

treatment typetx_typ

A categorical classification identifying the nature of a therapeutic intervention, such as pharmacological, surgical, behavioral, or rehabilitative. Used in clinical records and claims data to organize treatment modalities, support care pathway assignment, enable comparative effectiveness analysis, and drive utilization management decisions.

treatment unittx_unt

Specifies the unit of measure for a therapeutic intervention, such as milligrams, sessions, infusions, or radiation Gray units. Used in clinical and claims data to quantify treatment dosage, frequency, or administration volume for billing, care planning, and outcomes tracking.

treatment updated datetx_upd_dt

Records the most recent date on which a treatment record was modified in the clinical or administrative system. Used in care management and clinical data warehouses to track changes to treatment plans, dosage adjustments, or protocol revisions and support audit trail requirements.

treatment urgencytx_urg

Classifies the clinical time sensitivity of a therapeutic intervention, such as emergent, urgent, or elective. Used in care management workflows to prioritize scheduling, resource allocation, and authorization decisions based on the patient's medical condition and acuity level.

treatment valuetx_val

Captures a quantitative or qualitative data point associated with a therapeutic intervention, such as a clinical score, dosage amount, or outcome measure. Used in clinical data systems to track treatment effectiveness, monitor patient response, and support quality reporting.

treatment versiontx_ver

Identifies the version number of a treatment record, capturing updates or revisions made over the course of care. Used in clinical data warehouses to differentiate record iterations, support longitudinal tracking of treatment plan changes, and maintain data lineage for audit purposes.

treatment ziptx_zip

The postal ZIP code of the location where a therapeutic intervention is administered, such as a clinic, infusion center, or hospital site. Used in population health analytics and claims data to analyze geographic access patterns, service area coverage, and regional treatment utilization.

triage active indicatortriage_actv_ind

A binary flag indicating whether a triage episode is currently active or has been closed, transferred, or resolved. Used in emergency department and urgent care data systems to filter open triage cases for real-time patient flow monitoring, staffing decisions, and capacity management.

triage active statustriage_actv_sts

Describes the current workflow state of a triage encounter, such as active, pending, transferred, or discharged. Used in emergency department systems to manage patient queues, track progress through the triage process, and support operational reporting on ED throughput and wait times.

triage admission datetriage_admn_dt

Records the calendar date on which a patient presenting through triage was formally admitted to an inpatient or observation unit. Used in ED and hospital data systems to calculate length of stay, measure time-to-admission performance, and support utilization management and regulatory reporting.

triage agetriage_age

Captures the patient's age at the time of the triage encounter, typically in years or months for pediatric cases. Used in emergency department analytics to stratify acuity levels, identify age-specific risk factors, and support clinical decision-making during the initial patient priority assessment.

triage allowed amounttriage_alwd_amt

The maximum reimbursable dollar amount approved by a payer for triage-related services under the applicable benefit plan or contract. Used in claims adjudication to determine payment limits for emergency department or urgent care triage services based on negotiated fee schedules.

triage amounttriage_amt

The total monetary value associated with a triage encounter, which may represent billed charges, allowed amounts, or collected revenue depending on context. Used in revenue cycle and claims reporting to track the financial impact of emergency department triage services across patient populations.

triage approved bytriage_appr_by

Identifies the clinician, supervisor, or system user who authorized or validated a triage assessment or related decision. Used in ED documentation and audit workflows to establish accountability, support regulatory compliance, and ensure appropriate clinical sign-off on triage acuity assignments and care escalations.

triage arrival timetriage_arrv_tm

Records the exact clock time a patient arrived and was entered into the triage workflow, typically in the emergency department or urgent care setting. Used to calculate door-to-triage intervals, measure throughput performance, and support compliance with CMS and Joint Commission wait time benchmarks.

triage arrived datetriage_arrv_dt

Records the calendar date on which a patient arrived and was registered into the triage queue at an emergency department or urgent care facility. Used alongside arrival time to calculate daily ED volume, measure patient flow trends, and support operational and quality reporting on access to emergency services.

triage assessmenttriage_asmt

Contains the narrative or structured clinical evaluation completed by a triage nurse or clinician at the point of patient arrival, documenting chief complaint, vital signs, acuity level, and initial care needs. Used in ED documentation, handoff communications, and clinical data analytics to guide treatment prioritization.

triage balancetriage_bal

Represents the remaining patient financial responsibility for a triage encounter after insurance payments, adjustments, and credits have been applied. Used in revenue cycle management to track outstanding ED balances, drive billing follow-up activities, and monitor collections performance for triage-related services.

triage billed amounttriage_bill_amt

The gross charge amount submitted to a payer or patient for triage-related emergency department services before contractual adjustments or payments are applied. Used in revenue cycle reporting to track charge capture accuracy, payer mix analysis, and financial performance of ED triage operations.

PreviousPage 758 of 806Next