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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

transfer effective datexfer_eff_dt

The date on which a patient transfer between facilities or care units becomes active, as recorded in EHR and ADT systems. Populated via HL7 ADT A02 messages. Data engineers use this field to calculate length of stay segments, track transitions of care timelines, and support readmission risk analytics.

transfer scheduled datexfer_sched_dt

The planned calendar date on which a patient is scheduled to be transferred between care units, facilities, or levels of care, such as ICU to step-down or acute care to skilled nursing. Used in care coordination and bed management systems to facilitate safe patient transitions and resource planning.

transfer scheduled timexfer_sched_tm

The planned clock time when a patient is scheduled to be moved between care units, facilities, or levels of care. Used in hospital ADT systems to coordinate bed management, transport resources, and receiving unit preparation for inpatient transfers.

transfer street addressxfer_st_addr

The street-level address of the destination facility or unit to which a patient is being transferred. Captured in hospital ADT and care coordination systems to document the physical location receiving the patient during an inter-facility or intra-facility transfer event.

transfer type codetrnsfr_type_cd

A code identifying the specific type of patient transfer event, such as intrafacility transfer between units, interfacility transfer to another hospital, transfer to skilled nursing facility, transfer to rehabilitation, or transfer to home with services. Transfer type codes are used in patient flow analytics, care continuum tracking, and post-acute care network performance measurement.

transfer unitxfer_unt

The measurement unit associated with a patient transfer event between facilities or care units in EHR and ADT data systems. Used to quantify transfer activity for operational reporting, staffing analytics, and network utilization tracking. Critical for data engineers building care transition and post-acute referral pipelines.

trauma addresstrma_addr

The physical location address associated with a trauma case or trauma center involved in a patient's care. Used in trauma registry and emergency clinical systems to document facility or scene location details relevant to the traumatic injury encounter.

trauma approval statustrma_appr_sts

The current authorization or review state of a trauma case, indicating whether the case has been approved, pending review, or rejected within trauma registry or clinical documentation workflows. Supports quality review and trauma registry submission compliance processes.

trauma charge amounttrma_chrg_amt

The billable charge value associated with trauma care services rendered during a traumatic injury encounter. Captured in hospital billing and trauma registry systems to support cost accounting, claims submission, and financial reporting for trauma service lines.

trauma effective datetrma_eff_dt

The date on which a trauma case record, authorization, or associated clinical episode becomes active or takes effect. Used in trauma registry and clinical data systems to establish the start of a trauma-related care episode for tracking, reporting, and audit purposes.

trauma group numbertrma_grp_nbr

The insurance group identifier associated with the patient's health coverage at the time of a traumatic injury encounter. Used in trauma billing and clinical systems to link the trauma case to the correct insurance group for claims processing and reimbursement workflows.

trauma medical record numbertrma_mrn

The unique medical record number assigned to a patient within the context of a trauma encounter. Used in trauma registry and hospital clinical systems to link trauma case data to the patient's broader medical record for continuity of care and outcome tracking.

trauma scheduled datetrma_sched_dt

The calendar date on which a trauma-related procedure, follow-up, or care event is planned to occur. Used in trauma registry and surgical scheduling systems to track planned interventions following traumatic injury, supporting care coordination and outcomes reporting.

trauma scheduled timetrma_sched_tm

The planned clock time at which a trauma-related procedure, intervention, or follow-up care event is scheduled to take place. Used in trauma registry and hospital scheduling systems to coordinate clinical resources and track timeliness of care for traumatic injury cases.

trauma street addresstrma_st_addr

The street-level address associated with a trauma case, typically representing the trauma center, care facility, or incident scene location. Recorded in trauma registry and emergency clinical systems to document geographic details relevant to the traumatic injury encounter and transport logistics.

trauma unittrma_unt

The unit of measure or quantity associated with a trauma care service, procedure, or billable item. Used in trauma billing and registry systems to quantify services rendered during a traumatic injury encounter for accurate charge capture and claims submission.

triage addresstriage_addr

The physical location address where a patient triage assessment was conducted, typically an emergency department or urgent care site. Recorded in emergency clinical and ADT systems to document where initial patient priority evaluation occurred during an acute care encounter.

triage approval statustriage_appr_sts

The authorization or review state assigned to a triage assessment record, indicating whether the triage documentation has been approved, is pending clinical review, or requires correction. Supports quality assurance workflows and compliance auditing within emergency department clinical systems.

triage charge amounttriage_chrg_amt

The billable charge associated with performing a triage assessment in an emergency or urgent care setting. Captured in hospital billing systems to support revenue cycle management, claims submission, and financial reporting for emergency department triage service levels.

triage effective datetriage_eff_dt

The date on which a triage assessment, protocol, or associated record becomes active within clinical or administrative systems. Used in emergency department data systems to establish the start date of a triage episode for tracking patient flow, care timeliness, and regulatory reporting.

PreviousPage 280 of 325Next