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

triage group numbertriage_grp_nbr

The insurance group identifier associated with a patient's health coverage at the time of a triage assessment. Used in emergency department billing and registration systems to link the triage encounter to the correct insurance group plan for claims processing and eligibility verification.

triage level codetriage_lvl_cd

A code assigned by an emergency department triage nurse indicating the clinical acuity and urgency of a patient presentation, typically using the Emergency Severity Index scale of 1 through 5 where 1 is immediately life-threatening and 5 is non-urgent. Triage level codes drive patient prioritization, staffing allocation, and are used in ED analytics to benchmark case mix, wait times, and resource utilization by acuity.

triage medical record numbertriage_mrn

The unique medical record number assigned to a patient at the time of triage assessment in an emergency or urgent care setting. Used in emergency clinical systems to link triage documentation to the patient's broader medical record for continuity of care and outcome tracking.

triage scheduled datetriage_sched_dt

The calendar date on which a triage assessment or related care event is planned to occur. Used in emergency department and urgent care scheduling systems to track anticipated patient arrivals and coordinate clinical staffing resources for timely initial patient priority evaluation.

triage scheduled timetriage_sched_tm

The planned clock time at which a triage assessment is scheduled to be performed in an emergency or urgent care setting. Used in emergency department systems to track patient flow timeliness, measure door-to-triage intervals, and support staffing and capacity planning workflows.

triage street addresstriage_st_addr

The street-level address of the facility or location where patient triage assessments are conducted. Used in emergency and urgent care workflows to document the physical site of initial patient priority evaluations, supporting care coordination and incident reporting.

triage unittriage_unt

Identifies the specific clinical unit or care area responsible for conducting patient triage assessments. Used in emergency department and urgent care systems to associate triage encounters with the appropriate nursing unit, department, or care zone for staffing and workflow tracking.

ultrasound addressus_addr

The full physical address of the facility or department where sonographic imaging services are performed. Used in radiology and diagnostic imaging systems to identify the service location for scheduling, results routing, and claims billing of ultrasound procedures.

ultrasound effective dateus_eff_dt

The date on which an ultrasound order, authorization, or imaging protocol becomes clinically active and valid for use. Used in diagnostic imaging systems to manage the validity period of ultrasound-related authorizations, referrals, or standing orders for sonographic procedures.

ultrasound scheduled dateus_sched_dt

The calendar date on which a patient's sonographic imaging procedure is formally scheduled to occur. Used in radiology and diagnostic imaging systems to coordinate appointments, manage equipment availability, and track completion status of ordered ultrasound procedures.

ultrasound scheduled timeus_sched_tm

The specific time of day at which a patient's sonographic imaging appointment is scheduled to begin. Used in radiology scheduling systems to allocate equipment, technologist resources, and exam room availability for ordered ultrasound procedures at a precise daily time slot.

ultrasound street addressus_st_addr

The street-level address component of the facility where sonographic imaging is performed. Used in diagnostic imaging and radiology systems to capture the specific physical location for ultrasound services, supporting patient directions, claims submission, and provider directory accuracy.

ultrasound unitus_unt

The specific clinical unit, department, or imaging suite where sonographic procedures are performed. Used in radiology and diagnostic imaging systems to associate ultrasound exams with the correct organizational unit for scheduling, billing, and operational reporting purposes.

unit account numberunt_acct_nbr

The unique account identifier assigned to a specific clinical care unit within a healthcare facility. Used in hospital information systems to link financial transactions, patient admissions, and departmental billing activity to the correct inpatient unit or nursing station for revenue cycle tracking.

unit active indicatorunt_actv_ind

A binary flag indicating whether a specific clinical care unit is currently active and available for patient admissions or assignments. Used in facility management and ADT systems to control unit visibility in scheduling workflows and prevent assignment to decommissioned or temporarily closed care areas.

unit active statusunt_actv_sts

Describes the current operational status of a clinical care unit, indicating whether it is open, closed, or temporarily inactive for patient care. Used in hospital information systems to manage bed availability, staffing assignments, and admission workflows based on real-time unit operational state.

unit addressunt_addr

The physical location text identifying a specific clinical care unit within a facility, as recorded in EHR, ADT, and facility master data systems. Used to route patient assignments, support HL7 ADT message processing, and enable geographic or departmental analysis in hospital operations and quality reporting data pipelines.

unit adjustment amountunt_adj_amt

The dollar value of a financial adjustment applied at the clinical unit level, representing modifications such as contractual write-offs, billing corrections, or charge adjustments. Used in hospital revenue cycle systems to reconcile unit-level charges against payments and ensure accurate financial reporting.

unit ageunt_age

Represents the calculated age of a patient at the time of assignment or admission to a specific clinical care unit. Used in inpatient clinical systems to support age-appropriate care protocols, staffing decisions, and population health reporting tied to unit-level patient demographics.

unit allowed amountunt_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered within a specific clinical care unit, based on contract rates or fee schedules. Used in hospital revenue cycle and claims processing systems to calculate expected reimbursement and identify variance from billed charges.

PreviousPage 281 of 325Next