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

transfer temperaturexfer_temp

The patient's recorded body temperature at the time of or during a transfer between care units or facilities, serving as a vital sign data point in the clinical handoff record. Used to assess patient stability, flag potential infection or hypothermia, and support continuity of care at the receiving unit.

transfer termination datexfer_term_dt

The date on which a patient transfer episode officially ends, marking the conclusion of the transitional care period between the sending and receiving units or facilities. Used in utilization management, length-of-stay analysis, and claims adjudication to define the boundaries of the transfer encounter.

transfer timexfer_tm

The time-of-day value, typically in HH:MM or HH:MM:SS format, recording when a patient transfer event occurred or was initiated. Used in ADT and EHR systems alongside transfer dates to construct precise timestamps for episode duration calculations, transport billing, and regulatory compliance reporting for emergency transfers.

transfer timestampxfer_ts

A combined date and time value capturing the exact moment a patient transfer event was recorded or executed in the source system. Used in ADT, EHR, and HIE platforms for precise event sequencing, inter-system latency measurement, SLA compliance auditing, and longitudinal care timeline reconstruction across multi-facility encounters.

transfer titlexfer_ttl

The formal name or label assigned to a specific type of patient transfer event or transfer record, used to categorize and identify transfers within clinical documentation and data systems. Supports reporting, workflow routing, and consistent classification of transfer activities across inpatient and emergency care settings.

transfer totalxfer_tot

The aggregated sum of financial charges, units, or counts associated with a patient transfer between facilities, including transport fees and ancillary services. Used in claims, billing, and revenue cycle management systems to calculate total transfer-related costs, validate remittance, and support cost-of-care analysis in value-based payment models.

transfer total countxfer_tot_cnt

The aggregate number of transfer events recorded for a patient, unit, or facility within a defined reporting period. Used in hospital operations and quality reporting to measure patient flow volume, evaluate capacity management efficiency, and identify trends in inter-unit or inter-facility transfer activity.

transfer typexfer_typ

A coded classification identifying the category of a patient transfer between facilities, such as emergent, elective, inter-facility, or level-of-care upgrade. Captured in ADT and claims systems to drive workflow routing, apply appropriate reimbursement rules, and segment transfer populations for quality reporting and utilization management analysis.

transfer updated datexfer_upd_dt

The most recent date on which a patient transfer record was modified, reflecting updates to clinical details, administrative information, or status changes. Used in audit trails, data governance workflows, and care coordination systems to ensure transfer documentation reflects the latest accurate information.

transfer urgencyxfer_urg

A coded or descriptive indicator of the clinical time-sensitivity associated with a patient transfer, such as emergent, urgent, or elective. Used by clinical staff and care coordinators to prioritize transfer logistics, allocate receiving resources, and ensure timely intervention based on the patient's acuity level.

transfer valuexfer_val

A discrete measured data point associated with a patient transfer event, such as a clinical observation, financial amount, or acuity score captured at time of movement. Used in EHR, claims, and analytics platforms to populate transfer-related metrics, validate data completeness, and support risk stratification in care transition programs.

transfer versionxfer_ver

A sequential version number assigned to a patient transfer record to track revisions over time, enabling data lineage and change management within clinical and administrative systems. Used in data warehouses and EHR audit functions to distinguish current from historical transfer record states.

transfer zipxfer_zip

The five-digit or ZIP+4 postal code associated with the sending or receiving location of a patient transfer event. Used in geographic analysis, care coordination, and regulatory reporting to identify service area coverage, transport distances, and population-level transfer patterns across healthcare facilities.

trauma active indicatortrma_actv_ind

A binary flag indicating whether a trauma case is currently active and under clinical management within the trauma registry or care system. Used in trauma program reporting and quality improvement workflows to distinguish open, ongoing cases from closed or resolved trauma encounters in the patient record.

trauma active statustrma_actv_sts

A coded value representing the current lifecycle state of a trauma case, such as active, pending, closed, or transferred. Used in trauma registries and clinical data systems to manage case workflows, support outcomes tracking, and ensure accurate reporting to state and national trauma registries.

trauma admission datetrma_admn_dt

The calendar date on which a trauma patient was formally admitted to the hospital following an acute injury event. Used in trauma registry data collection, injury outcome analysis, and length-of-stay calculations to anchor the clinical timeline from point of injury through the full course of inpatient care.

trauma agetrma_age

The patient's age at the time of the traumatic injury event, recorded in years or as a calculated value from date of birth. A critical demographic variable in trauma registries used for injury severity stratification, outcome benchmarking, pediatric versus adult care pathway assignment, and population-level injury epidemiology reporting.

trauma allowed amounttrma_alwd_amt

The maximum dollar amount a payer has approved for reimbursement of trauma-related services based on contract terms and fee schedules. Used in trauma billing and claims adjudication to calculate provider payment, patient cost-sharing responsibility, and financial performance metrics for trauma program operations.

trauma amounttrma_amt

The total monetary value associated with charges or payments for trauma care services rendered during an injury-related encounter. Used in hospital finance and trauma program reporting to capture gross charges, reimbursement totals, or cost allocations tied to specific traumatic injury cases and service episodes.

trauma approved bytrma_appr_by

The identifier of the clinical or administrative user who authorized or approved a trauma-related action, record entry, or care decision within the trauma registry or clinical information system. Used in audit logging, compliance tracking, and quality assurance workflows to maintain accountability for trauma case documentation and approvals.

PreviousPage 743 of 806Next