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 amountunt_amt

The monetary value associated with a clinical care unit, representing costs, charges, or reimbursements attributed to a specific hospital department or nursing unit. Found in cost accounting, claims, and EHR financial systems. Data engineers use this field for departmental cost allocation, budget variance reporting, and payer contract analytics.

unit approval statusunt_appr_sts

Indicates the current authorization or approval state of a clinical care unit, such as pending, approved, or denied. Used in facility credentialing, compliance, and operational management systems to track whether a unit has received required internal or regulatory approvals to operate and accept patients.

unit approved byunt_appr_by

Identifies the user, clinician, or administrator who granted approval for a clinical care unit's operational status, policy change, or workflow action. Used in audit trails and governance workflows to maintain accountability and traceability for unit-level decisions within hospital management systems.

unit arrival timeunt_arrv_tm

The recorded time at which a patient physically arrived at or was transferred into a specific clinical care unit. Used in ADT and inpatient care systems to calculate unit throughput metrics, length of stay segments, staffing demand, and compliance with care transition time standards.

unit arrived dateunt_arrv_dt

The calendar date on which a patient was admitted or transferred to a specific clinical care unit. Used in ADT and inpatient management systems to track unit-level census activity, calculate length of stay by unit, and support quality reporting tied to patient flow and care transitions.

unit assessmentunt_asmt

Narrative or structured clinical evaluation text documenting a patient's condition as assessed within a specific care unit. Used in inpatient clinical documentation systems to record nursing or provider observations at the unit level, supporting care planning, handoff communication, and clinical decision-making.

unit balanceunt_bal

The outstanding financial amount attributable to a specific clinical care unit, representing unpaid charges or unreconciled costs within hospital cost accounting and EHR financial systems. Used by data engineers to monitor departmental financial performance, support accounts receivable workflows, and enable unit-level revenue cycle reporting.

unit billed amountunt_bill_amt

The total dollar amount charged by a clinical care unit for services rendered during a patient encounter or admission. Used in hospital revenue cycle systems to represent gross charges submitted to payers before adjustments, contractual allowances, or patient responsibility calculations are applied.

unit birth dateunt_birth_dt

The date a clinical care unit was established or activated within a facility master data or EHR system. Used to determine unit eligibility for historical reporting, track organizational changes, and support temporal joins in data warehouses. Critical for data engineers managing facility hierarchies and longitudinal unit-level analytics.

unit blood pressureunt_bp

Recorded arterial blood pressure measurement associated with a specific inpatient or outpatient care unit encounter. Captures systolic and diastolic values documented during clinical assessment, used in vital signs trending, acuity scoring, and clinical decision support across nursing units and care areas.

unit cancelled dateunt_cncl_dt

The calendar date on which a scheduled service, procedure, order, or care unit activity was officially cancelled. Used in clinical operations tracking to monitor cancellation patterns, reschedule workflows, and analyze service utilization gaps across inpatient units and outpatient departments.

unit categoryunt_cat

A classification grouping assigned to a clinical care unit in EHR, ADT, and facility master data systems, such as critical care, surgical, or behavioral health. Used by data engineers to aggregate unit-level metrics, standardize reporting hierarchies, and segment patient populations across departmental and quality analytics platforms.

unit census countunit_census_cnt

The total number of patients occupying beds in a specific nursing unit or care area at a defined point in time, used in staffing ratio calculations, capacity planning, and operational dashboards. Unit census counts are typically captured at midnight for daily reporting purposes and at multiple points throughout the day for real-time operations management.

unit charge amountunt_chrg_amt

The gross billed charge amount associated with a single service unit or care unit transaction prior to contractual adjustments, discounts, or payer payments. Used in hospital revenue cycle management to calculate expected reimbursement and support charge reconciliation reporting.

unit chief complaintunt_cc

The primary symptom, concern, or reason for care as reported by the patient or documented by clinical staff at the time of presentation to a care unit. Drives initial clinical assessment, triage prioritization, and diagnostic workup documentation in emergency, inpatient, and outpatient settings.

unit childunt_chld

A subordinate unit linked to a parent clinical care area within a facility hierarchy in EHR and ADT data systems. Defines parent-child organizational relationships used for rollup reporting, cost allocation, and staffing analytics. Data engineers rely on unit child relationships to build accurate facility hierarchy models in data warehouses.

unit cityunt_city

The city or municipality associated with a specific care unit's physical location or the patient's address on record for a given unit encounter. Used in geographic reporting, population health analytics, and care coordination workflows to identify service area demographics and access patterns.

unit classunt_cls

A classification tier assigned to a clinical care unit in EHR and facility master data systems, indicating the level or type of care provided, such as intensive, intermediate, or general. Used by data engineers to standardize unit taxonomy, support CMS condition-of-participation reporting, and enable cross-facility benchmarking analytics.

unit codeunt_cd

A standardized alphanumeric identifier assigned to a clinical care unit in EHR, ADT, and facility master data systems. Used to uniquely identify departments such as ICU or Med-Surg across data sources. Data engineers use unit codes as foreign keys to join ADT, staffing, and cost accounting records in enterprise healthcare data warehouses.

unit coinsurance amountunt_coins_amt

The portion of covered healthcare service costs that a member is required to pay after the deductible has been met, calculated as a percentage of the allowed amount for services rendered in a specific care unit. Used in patient billing, claims adjudication, and member cost-sharing analysis.

PreviousPage 282 of 325Next