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 sequenceunt_seq

The ordering number defining the positional rank of a clinical care unit within a workflow, list, or hierarchical structure in EHR and hospital administration systems. Data engineers use this field to enforce sort order during ETL transformations, control display sequencing in reporting layers, and maintain data integrity in ordered datasets.

unit service dateunt_svc_dt

The date on which a specific clinical service was rendered within a hospital unit or care area. Captured in EHR and claims systems, unt_svc_dt is critical for aligning billing cycles, validating claim timelines, and reconciling inpatient service records against UB-04 revenue codes.

unit severityunt_sev

A coded indicator representing the clinical seriousness of a patient condition within a specific care unit, such as ICU or step-down. Used in EHR and case management systems, unt_sev informs acuity scoring, DRG assignment, and resource allocation modeling for data engineers building risk stratification pipelines.

unit sexunt_sex

The biological sex designation recorded for a patient or associated entity within a clinical care unit context. Used in clinical documentation, reporting, and unit-level analytics to support sex-disaggregated quality measures, safety checks, and regulatory compliance requirements.

unit sourceunt_src

Identifies the originating system, facility, or department that generated a clinical unit record, such as an ADT feed, nursing station, or ancillary department. Used in EHR integration pipelines, unt_src supports data lineage tracking, deduplication logic, and source-of-truth validation across inpatient data workflows.

unit start dateunt_start_dt

The date on which a patient's stay, service episode, or care assignment within a clinical unit officially began. Captured in ADT and EHR systems, unt_start_dt is used to calculate length-of-stay metrics, validate admission timelines, and join inpatient records across claims and clinical data sources.

unit start timeunt_start_tm

The clock time marking the beginning of a clinical activity, procedure, service, or patient stay within a specific inpatient care unit. Used in clinical operations and time-based reporting to calculate durations, measure throughput, and support billing and compliance documentation.

unit stateunt_st

The U.S. state or territory associated with a clinical care unit's physical location or administrative address. Used in facility management, licensure tracking, and regulatory reporting to identify jurisdictional context for the unit's operations and compliance requirements.

unit statusunt_sts

A coded value representing the current operational or clinical state of a unit record, such as active, discharged, transferred, or closed. Used in ADT and EHR systems, unt_sts drives workflow routing logic, inpatient census reporting, and real-time bed management dashboards for healthcare data engineers.

unit street addressunt_st_addr

The physical street address of a clinical care unit or its associated facility. Used in facility registration, regulatory filings, and operational directories to accurately identify the unit's geographic location for communications, inspections, and administrative correspondence.

unit strengthunt_str

The concentration or dosage strength of a medication administered within a clinical care unit, expressed as the amount of active ingredient per dose or volume. Used in pharmacy dispensing and medication administration records to ensure accurate dosing and patient safety compliance.

unit subtotalunt_subtot

A partial sum of charges, quantities, or counts accumulated at the unit level before final totals are calculated. Used in hospital billing, supply tracking, and financial reporting to aggregate unit-specific costs or usage data as an intermediate step in revenue cycle workflows.

unit system identifierunt_sys_id

A system-generated unique identifier assigned to a clinical care unit within a healthcare information system. Used across EHR, billing, and operational platforms to consistently reference and link unit-level records, enabling accurate data integration and cross-system reporting.

unit targetunt_tgt

The destination unit, department, or system to which a patient, service, or data record is directed, such as a transfer-to unit in ADT workflows. Used in EHR and care coordination systems, unt_tgt supports transfer tracking, throughput analysis, and downstream routing logic in inpatient data pipelines.

unit taxonomy codeunt_tax_cd

A standardized National Uniform Claim Committee (NUCC) taxonomy code assigned to classify the specialty or service type associated with a clinical care unit. Used in claims processing and credentialing to identify the unit's care category for reimbursement and regulatory purposes.

unit temperatureunt_temp

The body temperature measurement recorded for a patient within a specific inpatient care unit, typically expressed in Fahrenheit or Celsius. Used in clinical vital signs documentation to monitor patient health status, detect fever or hypothermia, and inform treatment decisions at the unit level.

unit termination dateunt_term_dt

Records the date a clinical care unit was deactivated or closed within the facility's operational structure. Used in hospital administration systems to manage unit lifecycle, historical reporting, and ensure accurate bed management, staffing assignments, and patient census tracking are maintained.

unit timeunt_tm

The time-of-day value associated with a clinical event or service occurring within a care unit, such as medication administration or vital sign capture. Stored in EHR and nursing documentation systems, unt_tm is used alongside date fields to construct precise event timestamps for longitudinal clinical data analysis.

unit timestampunt_ts

A combined date and time value marking when a specific clinical event, status change, or service occurred within a care unit. Used across EHR, ADT, and ancillary systems, unt_ts is essential for event sequencing, audit trail construction, and time-series analysis in inpatient data engineering workflows.

unit titleunt_ttl

The official name assigned to a clinical care unit within a healthcare facility, such as 'Cardiac Intensive Care Unit' or 'Medical-Surgical Unit 3B'. Used in ADT systems, nursing documentation, and facility management to uniquely identify and reference the unit across clinical and administrative workflows.

PreviousPage 288 of 325Next