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 last namexfer_last_nm

The patient's family surname recorded at the time of transfer between units or care facilities. Used to confirm patient identity during clinical handoffs, match ADT records across systems, and ensure accurate demographic data continuity throughout the intra-facility or inter-facility transfer process.

transfer legal namexfer_legal_nm

The patient's official registered legal name as documented at the time of transfer between units or facilities. Used to verify patient identity against government-issued records, ensure compliance with consent and authorization requirements, and maintain accurate demographic data during ADT transfer events.

transfer levelxfer_lvl

A coded field in EHR and utilization management systems indicating the acuity or care intensity level of an inter-facility patient transfer, such as ICU to step-down or acute to skilled nursing. Used by data engineers to classify transfer types, validate appropriate level-of-care transitions, and support case mix analysis.

transfer license numberxfer_lic_nbr

The professional license identifier of the clinician or provider responsible for or involved in a patient transfer between units or facilities. Used to attribute accountability during clinical handoffs and to satisfy regulatory documentation requirements within ADT and care transition workflows.

transfer marital statusxfer_mar_sts

The patient's marital or relationship status recorded at the time of transfer between clinical units or facilities. Used to maintain accurate demographic records during ADT events, support next-of-kin identification, and ensure continuity of administrative documentation across care settings.

transfer master identifierxfer_mstr_id

The enterprise master patient index identifier assigned to a transfer event, used to uniquely link the patient across disparate clinical and administrative systems during intra-facility or inter-facility movement. Supports record matching, ADT reconciliation, and longitudinal patient tracking across the health system.

transfer maximumxfer_max

The upper boundary value associated with a clinical measurement, parameter, or constraint recorded at the time of a patient transfer between units. Used to define acceptable clinical ranges during handoffs, supporting safe transport thresholds and alerting protocols within ADT and clinical workflows.

transfer medical record numberxfer_mrn

The unique patient medical record number associated with a transfer event between clinical units or facilities. Used to link ADT transactions to the correct patient record, ensure identity continuity during handoffs, and support accurate clinical documentation and billing across the transfer encounter.

transfer middle namexfer_mid_nm

The patient's middle name or initial recorded at the time of transfer between clinical units or facilities. Used to supplement identity verification during clinical handoffs, reduce patient matching errors in ADT workflows, and maintain complete demographic records across intra-facility and inter-facility transfer events.

transfer minimumxfer_min

The lower boundary value associated with a clinical measurement, parameter, or constraint recorded at the time of a patient transfer between units. Used to define acceptable clinical thresholds during handoffs, supporting safe transport criteria and alerting protocols within ADT and clinical decision workflows.

transfer mobilexfer_mob

The patient's mobile phone number documented at the time of transfer between clinical units or facilities. Used to maintain accurate contact information during ADT events, support post-transfer follow-up communications, and ensure reachability for care coordination and discharge planning across care settings.

transfer modified byxfer_mod_by

The username or system identifier of the user who last updated a patient transfer record. Captured for audit trail purposes within ADT and clinical information systems, supporting accountability, data governance, and change tracking across intra-facility and inter-facility patient movement workflows.

transfer modified datexfer_mod_dt

The timestamp recorded in EHR and ADT systems when a transfer record was last updated, reflecting changes to transfer details, destination, or clinical status. Used by data engineers to implement incremental data loads, audit record changes, and reconcile transfer data across source and downstream systems during ETL processing.

transfer modified timexfer_mod_tm

The timestamp recording when a patient transfer record was last updated within the clinical or administrative system. Used to establish audit trail chronology, support data reconciliation across ADT systems, and track the sequence of modifications made during intra-facility or inter-facility patient movement processing.

transfer namexfer_nm

The descriptive label assigned to a transfer type, protocol, or transfer event in EHR and care management systems, such as trauma transfer or psychiatric transfer. Used by data engineers for display purposes, transfer type classification, and filtering in operational dashboards and care coordination reporting pipelines.

transfer notexfer_nt

A free-text or structured annotation field in EHR and ADT systems capturing clinical observations, special instructions, or administrative comments associated with an inter-facility patient transfer. Data engineers process this field for NLP-based quality analytics, care coordination audits, and handoff documentation compliance reporting.

transfer numberxfer_nbr

A reference number assigned to an inter-facility patient transfer in EHR, ADT, or utilization management systems, used for tracking, authorization, and communication between facilities. Data engineers use this field as a join key across sending and receiving facility records and to reconcile transfer authorization numbers with claims data.

transfer onset datexfer_onset_dt

Date when the condition or symptoms that prompted an inpatient transfer between units first began. Supports clinical documentation by linking the originating complaint or diagnosis timeline to the transfer event recorded in the EHR.

transfer oxygen saturationxfer_o2sat

Peripheral oxygen saturation (SpO2) percentage recorded at the time of patient transfer between care units. This vital sign documents the patient's respiratory status during handoff and supports clinical continuity and acuity assessment at the receiving unit.

transfer paid amountxfer_pd_amt

Dollar amount reimbursed or paid by the payer for services associated with an inpatient transfer between care units. Used in claims adjudication and hospital billing reconciliation to track financial settlement of transfer-related service charges.

PreviousPage 740 of 806Next