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 paid datexfer_pd_dt

Date on which payment was issued or posted for claims associated with a patient transfer between care units. Used in hospital revenue cycle management to track reimbursement timelines and reconcile accounts receivable for transfer-related billing.

transfer parentxfer_prnt

A relational field in EHR and ADT systems linking a child transfer record to its originating or parent encounter, facility, or transfer episode. Used by data engineers to navigate hierarchical transfer relationships, reconstruct multi-leg transfer pathways, and correctly attribute costs and outcomes across related inpatient episodes.

transfer percentagexfer_pct

A calculated ratio in analytics and population health platforms representing the proportion of encounters, costs, or members involving inter-facility transfers within a defined population or time period. Used by data engineers to benchmark transfer rates, monitor care network efficiency, and support value-based care performance reporting.

transfer periodxfer_prd

The defined time span encompassing an inter-facility patient transfer episode in EHR, ADT, and utilization management systems, from transfer initiation to completion. Used by data engineers to calculate transfer duration metrics, align transfer events with claims billing periods, and assess transport timeliness in quality reporting.

transfer phonexfer_ph

The telephone number associated with the receiving facility, transport coordinator, or clinical contact for an inter-facility patient transfer, stored in EHR and care management systems. Used by data engineers to validate contact data completeness, support care coordination workflows, and enrich provider directory datasets during ETL processing.

transfer preferred namexfer_pref_nm

Patient's chosen or preferred name as recorded at the time of transfer between care units. Supports respectful, person-centered care during handoffs and ensures receiving unit staff address the patient correctly in clinical communications and documentation.

transfer pricexfer_prc

Billed or contracted cost amount associated with the patient transfer between care units. Used in hospital finance systems to capture the charge or negotiated rate for transfer-related services, supporting cost accounting and payer contract compliance.

transfer primary indicatorxfer_prim_ind

Flag identifying whether the transfer record is the primary or principal transfer event in a series of inpatient movements. Used to distinguish the main transfer encounter from secondary or ancillary movements when a patient undergoes multiple unit transfers during a single admission.

transfer priorityxfer_prty

A ranked or coded field in EHR, ADT, and care management systems indicating the urgency level of an inter-facility patient transfer, such as emergent, urgent, or routine. Used by data engineers to segment transfer populations by acuity, drive transport resource allocation logic, and support time-to-transfer quality metric calculations.

transfer procedure datexfer_proc_dt

Date on which a clinical procedure was performed in association with the patient's transfer between care units. Used to sequence procedural events relative to the transfer timeline and supports accurate coding and billing of transfer-related interventions.

transfer pulsexfer_pulse

Heart rate in beats per minute recorded at the time of patient transfer between care units. Documents cardiovascular status during clinical handoff and supports acuity scoring, triage decision-making, and clinical continuity at the receiving unit.

transfer quantityxfer_qty

The numeric count or volume of items, medications, records, or patients involved in a facility-to-facility movement event. Used in ADT, EHR, and claims systems to validate transfer completeness, reconcile pharmacy dispensing during care transitions, and support inter-facility billing audits.

transfer racexfer_race

Patient's self-reported racial identity as captured at the time of transfer between care units. Used in health equity reporting, population health analytics, and compliance with federal data collection requirements including OMB and CMS race and ethnicity standards.

transfer rangexfer_rng

The minimum and maximum value span defining acceptable limits for a patient transfer event, such as allowable transfer distance, acuity range, or transport duration. Used in EHR and care coordination platforms to enforce transfer eligibility rules and network compliance for managed care contracts.

transfer ratexfer_rt

The unit price or reimbursement rate applied to a patient transfer between facilities, including ambulance transport or inter-facility care fees. Used in claims and billing systems to calculate expected payment, validate remittance advice, and audit transfer-related charges against contracted payer rates.

transfer ratingxfer_rtg

Numeric or categorical score assigned to the patient or transfer event at the time of unit-to-unit movement, such as an acuity rating or quality score. Supports clinical prioritization, workload assignment, and performance benchmarking across transfer events.

transfer ratioxfer_ratio

Calculated proportional value associated with a patient transfer event, such as a nurse-to-patient ratio or resource utilization ratio at time of transfer. Used in staffing analytics and capacity management to evaluate unit conditions during inpatient transfers.

transfer reasonxfer_rsn

The coded or free-text clinical or administrative explanation for why a patient was moved between facilities, such as higher level of care needed or specialist availability. Captured in ADT and EHR systems and used for quality reporting, utilization management, and case mix analysis across care settings.

transfer received datexfer_rcvd_dt

Date on which the receiving care unit formally accepted or received the transferred patient. Marks the completion of the transfer handoff process and is used in inpatient flow analytics to calculate transfer duration and measure handoff efficiency between units.

transfer referencexfer_ref

An external identifier or pointer linking a patient transfer event to a related record in another system, such as a referring facility's encounter ID or a transport vendor's tracking number. Used in ADT, HIE, and claims platforms to enable cross-system reconciliation and longitudinal patient tracking across facilities.

PreviousPage 741 of 806Next