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

unit detailunt_dtl

Granular attribute data associated with a specific clinical care unit record in EHR and ADT systems, encompassing capacity, staffing ratios, specialization, or operational attributes. Data engineers reference this field when building unit-level dimension tables to support census, throughput, and utilization analytics in healthcare data warehouses.

unit due dateunt_due_dt

The target date by which a payment, clinical task, order completion, or administrative action associated with a care unit is expected to be fulfilled. Used in accounts receivable management, workflow scheduling, and operational oversight to monitor timely completion of financial obligations and clinical service requirements.

unit durationunt_dur

The total elapsed time associated with a care unit service, patient stay, procedure, or clinical episode from initiation to completion. Used in capacity planning, length-of-stay analysis, staffing models, and payer reporting to evaluate throughput efficiency and resource utilization across inpatient and ambulatory care settings.

unit effective dateunt_eff_dt

The date on which a clinical care unit record or configuration becomes active in EHR, ADT, or facility master systems. Data engineers use this field to implement slowly changing dimension logic, filter active unit records in reporting datasets, and support time-bounded analyses of unit-level operational changes across health systems.

unit emailunt_eml

The electronic mail address associated with a clinical care unit in EHR and facility directory systems, used for operational communications and automated system notifications. Data engineers validate and standardize this field during master data management to ensure accurate routing in integration layers and care coordination platforms.

unit emergency indicatorunt_emerg_ind

A binary flag designating whether a clinical care unit operates under emergency or urgent care protocols. Used in hospital information systems to classify units such as ICUs or EDs, enabling appropriate resource allocation, staffing decisions, and priority-based patient routing workflows.

unit end dateunt_end_dt

The date on which a clinical care unit record, configuration, or patient association is terminated in EHR and ADT systems. Data engineers use this field alongside effective dates to implement SCD Type 2 logic, filter expired unit records, and build accurate historical snapshots in healthcare data warehouse dimension tables.

unit end timeunt_end_tm

The timestamp recording when a clinical care unit's operational period, shift assignment, or patient care episode concluded. Used in inpatient and outpatient settings to calculate unit utilization duration, staffing intervals, and throughput metrics for capacity planning and reporting.

unit entered byunt_ent_by

The identifier of the user or system account responsible for creating or initially recording a clinical care unit record in the healthcare information system. Used for data governance, audit trail maintenance, and accountability tracking in EHR and hospital administrative workflows.

unit ethnicityunt_ethn

An ethnicity classification associated with a clinical care unit record, typically reflecting the predominant patient population served or demographic attributes tied to unit-level reporting. Used in population health analytics and health equity reporting within hospital data systems.

unit expiration dateunt_exp_dt

The date after which a clinical care unit record or associated configuration is no longer considered valid in EHR, ADT, or facility master systems. Data engineers use this field to exclude stale records from active reporting datasets and enforce data retention policies during ETL processing and master data governance workflows.

unit external identifierunt_ext_id

A reference code assigned to a clinical care unit by an external system, such as a payer, regional health network, or interoperability platform. Used to reconcile unit records across disparate healthcare systems, supporting data exchange, claims processing, and cross-organizational reporting.

unit faxunt_fax

The facsimile telephone number associated with a specific clinical care unit, such as a nursing floor, department, or specialty ward. Used in hospital communication workflows to route referral documents, lab results, orders, and patient records to the appropriate care team location.

unit feeunt_fee

The charge amount associated with services rendered within a specific clinical care unit, such as a room and board rate for an inpatient ward or procedure fee for a specialty unit. Used in hospital billing, cost accounting, and revenue cycle management systems.

unit first nameunt_first_nm

The primary or shortened given name used to identify a clinical care unit in display contexts within healthcare information systems. Used to distinguish units in scheduling, census reporting, and patient assignment screens where abbreviated unit identifiers improve staff navigation and workflow efficiency.

unit flagunt_flg

A binary or enumerated indicator field assigned to a clinical care unit record in EHR and ADT systems, signaling special operational states such as isolation protocols, surge capacity, or data suppression rules. Data engineers evaluate unit flags during ETL to apply conditional logic, filter records, or trigger downstream alerting workflows.

unit frequencyunt_freq

The rate or recurring schedule associated with a clinical care unit's operational cycles, service intervals, or care delivery patterns. Used in hospital scheduling and resource planning systems to manage staffing rotations, equipment maintenance cycles, and unit-based treatment protocol frequencies.

unit full nameunt_full_nm

The complete formal name assigned to a clinical care unit, such as Cardiac Intensive Care Unit or Pediatric Medical-Surgical Ward. Used across EHR, billing, and administrative systems to uniquely identify the unit in census reports, patient assignments, and facility management documentation.

unit genderunt_gndr

A gender classification attribute associated with a clinical care unit record, typically indicating whether the unit serves a gender-specific patient population such as a women's health ward or men's behavioral health unit. Used in patient placement, reporting, and compliance documentation.

unit glucoseunt_gluc

A blood glucose measurement captured at the clinical care unit level, often representing an aggregated or representative value for unit-level metabolic monitoring. Used in inpatient clinical data systems to track glycemic control trends across patient populations within a specific care unit.

PreviousPage 284 of 325Next