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

oncology unitonc_unt

The unit of measurement associated with an oncology clinical data element, such as mg/m² for chemotherapy dosing, Gy for radiation, or mL for infusion volume, captured in EHR and pharmacy systems. Ensures dimensional accuracy in oncology dose calculations and treatment protocol adherence reporting.

operating room case duration minutesor_case_durn_min

The total elapsed time in minutes from patient entry into the operating room to patient exit, encompassing room setup, anesthesia induction, surgical procedure, and room turnover preparation. OR case duration is used in surgical scheduling optimization, block time utilization analysis, and surgeon performance benchmarking against procedure-specific time benchmarks.

operating room utilization rateor_utilztn_rt

The percentage of available scheduled operating room time that is actually used for surgical procedures during a defined period, calculated as actual procedure minutes divided by total available room minutes. OR utilization rates are a critical financial and operational metric because operating rooms represent the highest cost-per-hour resource in a hospital and underutilization directly reduces surgical revenue.

operation addressop_addr

The physical street address of the facility or location where a surgical procedure is performed or scheduled, such as a hospital operating room, ambulatory surgery center, or outpatient surgical suite. Used in surgical records for facility identification, credentialing, and claims processing.

operation ageop_age

The age of the patient in years at the time of a surgical procedure. Used in surgical and perioperative records to support anesthesia risk stratification, surgical outcome analysis, quality reporting, and age-based clinical decision support during operative care planning.

operation allowed amountop_alwd_amt

The maximum dollar amount a payer will reimburse for a specific surgical procedure under the terms of a benefit plan or fee schedule. Used in surgical claims adjudication to determine payment after applying contractual adjustments, deductibles, and coordination of benefits rules.

operation amountop_amt

The total billed or paid dollar amount associated with a surgical procedure, representing charges submitted by the facility or surgeon. Used in surgical claims and financial records to track procedure-level costs, reimbursement, and cost-of-care analytics across operative episodes.

operation approval statusop_appr_sts

The current authorization or approval state of a surgical procedure request, such as pending, approved, denied, or conditionally approved. Used in prior authorization and surgical scheduling workflows to confirm payer or clinical approval before a procedure is performed or a facility resource is reserved.

operation approved byop_appr_by

The name or identifier of the clinician, administrator, or payer representative who granted authorization for a surgical procedure. Used in surgical workflow and prior authorization records to maintain an audit trail of approval decisions for compliance, liability, and care coordination purposes.

operation arrival timeop_arrv_tm

The recorded time at which a patient arrived at the surgical facility or pre-operative area for a scheduled operative procedure. Used in perioperative workflow tracking to measure on-time arrival, calculate pre-op preparation intervals, and support surgical suite throughput and efficiency reporting.

operation arrived dateop_arrv_dt

The calendar date on which a patient arrived at the surgical facility or pre-operative area for a scheduled operative procedure. Used in perioperative records to confirm patient presence, track admission-to-incision timelines, and support surgical scheduling compliance and outcome analysis.

operation assessmentop_asmt

The structured or free-text clinical evaluation documented by a surgeon, anesthesiologist, or perioperative nurse prior to, during, or following a surgical procedure. Captures pre-op risk assessment findings, intraoperative observations, or post-operative condition evaluations to guide surgical care decisions.

operation birth dateop_birth_dt

The date of birth of the patient undergoing a surgical procedure, recorded in operative and perioperative records. Used to verify patient identity, calculate patient age at time of surgery, support anesthesia dosing, and fulfill regulatory and quality reporting requirements for surgical outcomes.

operation blood pressureop_bp

The systolic and diastolic arterial blood pressure measurement recorded in the context of a surgical procedure, typically captured during pre-operative assessment or intraoperative monitoring. Used in perioperative clinical documentation to assess hemodynamic stability and guide anesthesia and surgical management.

operation cancelled dateop_cncl_dt

The calendar date on which a previously scheduled surgical procedure was officially cancelled. Used in surgical scheduling and perioperative systems to track cancellation patterns, document reasons for non-completion, support rescheduling workflows, and measure surgical access and utilization metrics.

operation categoryop_cat

A classification grouping that identifies the type or nature of a surgical procedure, such as elective, urgent, emergent, or by body system or specialty (e.g., cardiovascular, orthopedic, general surgery). Used in operative records for case mix analysis, surgical scheduling prioritization, and quality reporting.

operation charge amountop_chrg_amt

The total billed charge amount associated with a surgical procedure or operative intervention. Captures the gross financial amount before adjustments, contractual allowances, or payer reimbursements are applied. Used in hospital billing and surgical cost tracking workflows.

operation chief complaintop_cc

The primary symptom, condition, or clinical reason documented by the patient or clinician that prompted the surgical intervention. Recorded at the time of surgical intake or pre-operative assessment and used in operative documentation and clinical coding workflows.

operation childop_chld

Identifies a subordinate or dependent surgical procedure record linked to a parent operation in a hierarchical data structure. Used to represent procedure components, sub-procedures, or related operative events nested beneath a primary surgical encounter record.

operation cityop_city

The name of the municipality where the surgical procedure was performed or where the associated facility is located. Used to identify geographic location of the operative site for reporting, credentialing, and facility-level analytics across clinical and administrative systems.

PreviousPage 152 of 325Next