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

trauma titletrma_ttl

Formal name or descriptive label assigned to a trauma case, protocol, or record type within the clinical or registry system. Used in trauma data management to provide human-readable identification of trauma episodes, standardize record naming conventions, and facilitate retrieval and reporting across trauma registry and hospital information systems.

trauma totaltrma_tot

Aggregate sum of all charges, costs, or scored values associated with a complete trauma episode of care. Used in hospital billing systems and trauma registries to represent the total financial liability or cumulative clinical score for a trauma encounter, supporting reimbursement processing, cost benchmarking, and trauma program financial reporting.

trauma total counttrma_tot_cnt

The aggregate number of trauma incidents recorded for a patient or encounter within a clinical data system. Used in trauma registries and hospital reporting to measure injury burden, support outcome analysis, and benchmark care delivery across trauma centers and service periods.

trauma typetrma_typ

Classifies the nature of a traumatic injury using standardized categories such as blunt force, penetrating, thermal, or blast injury. Used in trauma registries and emergency care systems to guide clinical protocols, resource allocation, and injury surveillance reporting at the facility or regional level.

trauma updated datetrma_upd_dt

The most recent date on which a trauma record was modified within the clinical data system. Used in trauma registries and EHR audit workflows to track data corrections, late-entry documentation, and registry submission compliance for quality reporting and accreditation purposes.

trauma urgencytrma_urg

Indicates the acuity level assigned to a traumatic injury, reflecting the time-sensitivity of required medical intervention. Used in emergency triage systems and trauma registries to prioritize patient care, allocate trauma team resources, and measure response time compliance against clinical benchmarks.

trauma versiontrma_ver

A sequential number identifying the iteration of a trauma record within the clinical data system. Used in trauma registries and data warehouses to maintain audit trails, reconcile data corrections, and ensure the most current and accurate version of a trauma encounter is used for reporting and analysis.

trauma ziptrma_zip

The postal ZIP code associated with the location where a traumatic injury occurred or the patient's residence at time of trauma. Used in trauma registries and public health surveillance to analyze geographic injury patterns, identify high-risk areas, and support regional trauma system planning.

treatment account numbertx_acct_nbr

A unique identifier assigned to link a patient's treatment episode to a billing or financial account within healthcare revenue cycle systems. Used to track treatment-related charges, insurance claims adjudication, and payment reconciliation across clinical and administrative data platforms.

treatment active indicatortx_actv_ind

A binary flag denoting whether a patient's treatment plan or episode is currently active within the clinical system. Used in care management and EHR workflows to filter relevant treatment records, support clinical decision-making, and prevent outdated treatment protocols from being applied to ongoing patient care.

treatment active statustx_actv_sts

Describes the current lifecycle state of a patient's treatment, such as active, suspended, completed, or discontinued. Used in care coordination and clinical data systems to monitor treatment progress, trigger follow-up workflows, and ensure accurate reporting of ongoing versus resolved therapeutic interventions.

treatment addresstx_addr

The physical location where a patient's treatment is administered, such as a clinic, hospital, or outpatient facility address. Used in care coordination systems and claims processing to verify service delivery location, support network adequacy assessments, and ensure accurate provider and facility billing submissions.

treatment adjustment amounttx_adj_amt

The monetary value applied to modify an original treatment charge during claims processing, reflecting contractual write-offs, payer discounts, or billing corrections. Used in revenue cycle management to reconcile billed charges against allowed amounts and ensure accurate net reimbursement reporting for treatment services.

treatment admission datetx_admn_dt

The calendar date on which a patient was formally admitted for inpatient or structured outpatient treatment. Used in clinical and claims systems to establish the treatment episode start, calculate length of stay, apply correct benefit period rules, and support DRG-based reimbursement and utilization management workflows.

treatment agetx_age

The patient's age in years at the time a treatment was initiated or documented. Used in clinical analytics, quality reporting, and care management workflows to stratify outcomes by age cohort, apply age-specific clinical guidelines, and ensure appropriate treatment protocols are followed for pediatric, adult, and geriatric populations.

treatment allowed amounttx_alwd_amt

The maximum dollar amount a payer will reimburse for a specific treatment service based on contracted fee schedules or benefit plan terms. Used in claims adjudication and revenue cycle systems to calculate patient cost-sharing responsibilities, provider payment amounts, and identify any balance billing discrepancies.

treatment amounttx_amt

The total monetary value associated with a treatment service, representing either the billed charge or the net cost of delivering a therapeutic intervention. Used in healthcare financial systems and claims processing to support cost accounting, payer billing, reimbursement reconciliation, and treatment cost trend analysis across patient populations.

treatment approval statustx_appr_sts

Indicates whether a proposed treatment has received authorization from the payer, utilization management team, or clinical reviewer. Used in prior authorization workflows and care management platforms to ensure treatments meet medical necessity criteria before services are rendered, reducing claim denials and supporting compliance with payer authorization requirements.

treatment approved bytx_appr_by

Identifies the clinician, administrator, or system user who granted authorization for a treatment plan or service. Used in utilization management and clinical governance workflows to maintain accountability, support audit trails, and ensure that treatment approvals comply with organizational policies and payer prior authorization requirements.

treatment arrival timetx_arrv_tm

The recorded time at which a patient arrived at a care setting to receive a scheduled or unscheduled treatment. Used in emergency department and outpatient clinical systems to measure door-to-treatment intervals, evaluate care timeliness against quality benchmarks, and support operational reporting on patient flow and throughput efficiency.

PreviousPage 750 of 806Next