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 totalunt_tot

The aggregated sum of a measured quantity within a clinical unit context, such as total units of blood administered, total service hours, or total charges for a unit stay. Used in EHR, billing, and pharmacy systems, unt_tot supports cost roll-up calculations, utilization reporting, and claims reconciliation.

unit total countunt_tot_cnt

Represents the aggregate number of records, events, or items associated with a specific clinical care unit over a defined period. Used in hospital operations reporting to measure patient volume, incident frequency, medication usage, or staffing occurrences at the unit level for capacity planning.

unit typeunt_typ

A categorical code identifying the classification of a clinical care unit, such as medical-surgical, intensive care, telemetry, or behavioral health. Captured in ADT and EHR systems, unt_typ is used to segment inpatient data, apply unit-specific billing rules, and benchmark utilization patterns across facility types.

unit unitunt_unt

The standardized measurement unit applied to a clinical quantity recorded within a care unit, such as mg, mL, hours, or days. Used in EHR, pharmacy, and claims systems, unt_unt ensures dimensional consistency when aggregating or comparing clinical metrics across disparate source systems and coding standards.

unit updated dateunt_upd_dt

Captures the most recent date on which a clinical care unit's record was modified in the healthcare information system. Used in audit trails and data governance to track configuration changes, unit attribute updates, or administrative edits that affect downstream reporting and operational workflows.

unit urgencyunt_urg

Indicates the time-sensitivity classification assigned to a clinical care unit or patient transfer request, such as emergent, urgent, or routine. Used in bed management and patient flow systems to prioritize unit assignments, triage decisions, and resource allocation based on acuity and clinical need.

unit valueunt_val

A discrete measured or coded data point associated with a clinical observation, service, or administrative record within a care unit, such as a lab result, dosage amount, or charge figure. Used in EHR and claims systems, unt_val is central to clinical analytics, quality measure calculations, and billing validation logic.

unit versionunt_ver

Tracks the iteration number of a clinical care unit's configuration or record within the healthcare information system. Used in data versioning and change management workflows to maintain historical accuracy, support audit compliance, and differentiate between successive updates to unit attributes or operational parameters.

unit zipunt_zip

The postal ZIP code associated with a clinical care unit's physical location, particularly relevant for satellite facilities, off-campus units, or multi-site health systems. Used in facility management, claims adjudication, and geographic reporting to accurately identify the service location for billing and regulatory purposes.

urology addressuro_addr

The complete mailing or physical address of a urology department, clinic, or practice location. Used in referral management, appointment scheduling systems, and patient communication workflows to direct patients to the correct facility for urological consultations, procedures, or follow-up care within a health system network.

urology effective dateuro_eff_dt

The date on which a urology service agreement, contract, referral authorization, or clinical protocol becomes active. Used in specialty care management and managed care systems to validate service eligibility, coordinate referrals, and ensure urology services rendered are within the authorized coverage period for claims processing.

urology scheduled dateuro_sched_dt

The calendar date on which a patient is scheduled to receive a urology service, procedure, or consultation, such as cystoscopy or nephrectomy planning. Used in appointment management and surgical scheduling systems to coordinate care, manage provider availability, and support pre-procedure authorization workflows.

urology scheduled timeuro_sched_tm

The specific time of day at which a urology appointment, procedure, or consultation is planned to occur. Used in clinic scheduling and surgical coordination systems to manage procedural room utilization, anesthesia planning, and patient preparation timelines for urological services such as TURP or urodynamic studies.

urology street addressuro_st_addr

The street-level address line for a urology clinic, department, or practice site, used to distinguish specific building locations within a larger health system campus. Referenced in patient appointment reminders, referral documentation, and facility directories to ensure patients and referring providers locate the correct urology service site.

urology unituro_unt

Specifies the unit of measure associated with a urology-related service, treatment, or medication, such as dosage units for intravesical therapy or procedure counts for billing. Used in clinical documentation and claims processing to quantify urology services rendered and ensure accurate reimbursement under applicable fee schedules.

utilization management review dateum_rvw_dt

The date on which a utilization management clinical review was conducted for a patient admission, continued stay, or proposed procedure, used to track review timeliness compliance with regulatory and accreditation requirements and to analyze the relationship between review timing and authorization outcomes.

utilization management review type codeum_rvw_type_cd

A code identifying the type of utilization management review conducted, such as prospective review before a service is rendered, concurrent review during an ongoing admission, or retrospective review after service completion. Review type affects authorization requirements, turnaround time standards, and appeal rights under state and federal utilization review regulations.

vaccination scheduled datevacc_sched_dt

The calendar date on which a patient's immunization appointment is planned, covering vaccines such as influenza, MMR, or COVID-19. Used in immunization registries and preventive care management systems to track vaccination schedules, send patient reminders, and ensure adherence to CDC-recommended immunization protocols.

vaccination scheduled timevacc_sched_tm

The specific time of day at which a patient's immunization appointment is planned to occur. Used in clinic scheduling and public health immunization programs to manage patient flow, vaccine inventory thawing schedules, and administration staffing, particularly during high-volume vaccination events or mass immunization campaigns.

vaccination unitvacc_unt

Specifies the unit of measure for a vaccine dose, such as milliliters administered or number of doses in a series. Used in immunization documentation, pharmacy dispensing records, and public health reporting to accurately quantify vaccine administration and support inventory management across immunization programs and clinical sites.

PreviousPage 289 of 325Next