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

operation timeop_tm

The clock time at which a surgical procedure began, concluded, or reached a defined milestone such as incision or closure. Used in operative scheduling and clinical documentation systems to track procedure duration, OR utilization, and perioperative sequencing for quality and efficiency reporting.

operation timestampop_ts

The combined date and time value marking a specific event within a surgical procedure's lifecycle, such as procedure start, end, or a critical intraoperative action. Used in operative records and audit logs to establish precise chronological sequencing for clinical, billing, and compliance purposes.

operation titleop_ttl

The official or standardized name assigned to a surgical procedure as documented in operative reports and surgical scheduling systems. Used to identify the procedure in clinical records, consent documentation, and coding workflows, ensuring consistent terminology across surgical teams and administrative systems.

operation totalop_tot

The aggregate numeric value associated with a surgical intervention, such as total operative time in minutes, total units of anesthesia, or total billed charges. Used in surgical records and claims processing to summarize quantitative measures for billing reconciliation, cost analysis, and resource utilization reporting.

operation total countop_tot_cnt

The cumulative number of occurrences of a specific surgical procedure performed within a defined period or for a specific patient, case, or facility. Used in surgical analytics and quality reporting to measure procedure volume, track repeat interventions, and support population-level outcomes analysis.

operation typeop_typ

A categorical classification that describes the nature or approach of a surgical intervention, such as elective, emergent, diagnostic, therapeutic, laparoscopic, or open. Used in operative documentation and clinical data systems to stratify procedures for outcomes research, scheduling prioritization, and surgical quality benchmarking.

operation unitop_unt

The defined unit of measure applied to a surgical procedure or associated resource, such as anesthesia base units, surgical supply quantities, or time increments. Used in operative billing and resource management systems to quantify procedure components for accurate claims submission and cost accounting.

operation updated dateop_upd_dt

The most recent calendar date on which a surgical procedure record, operative note, or associated documentation was modified in the clinical or administrative system. Used in audit trails and data governance workflows to track record changes, support version control, and ensure data integrity in surgical documentation.

operation urgencyop_urg

Indicates the clinical time-sensitivity classification assigned to a surgical procedure, such as elective, urgent, or emergent. Used in surgical scheduling and triage systems to prioritize OR access and resource allocation based on the patient's medical condition and the risk of delaying the intervention.

operation versionop_ver

A numeric or alphanumeric identifier tracking the iteration of a surgical procedure record, operative protocol, or documentation entry within a clinical data system. Used in version control and audit workflows to distinguish successive updates to operative records, supporting data accuracy and regulatory compliance.

operation zipop_zip

The five- or nine-digit US postal code associated with the facility or location where a surgical procedure was performed. Used in surgical records and geographic analysis systems to identify the care delivery site, support facility-level reporting, and enable regional utilization and outcomes comparisons.

ophthalmology addressopht_addr

The full physical address of a clinical facility or practice where ophthalmology services are delivered, including eye exams, vision correction procedures, and treatment for ocular conditions. Used in provider directory systems and referral workflows to route patients to the appropriate eye care location.

ophthalmology effective dateopht_eff_dt

The date on which an ophthalmology-related record, service authorization, or clinical finding becomes active and clinically applicable. Used in eye care management systems to establish the valid start date for vision benefits, diagnoses such as glaucoma or macular degeneration, or treatment plans.

ophthalmology scheduled dateopht_sched_dt

The calendar date on which a patient's ophthalmology appointment is planned, including routine eye exams, specialist consultations, or procedures such as cataract surgery or retinal treatments. Used in eye care scheduling systems to manage appointment coordination, referral tracking, and care gap identification for vision health programs.

ophthalmology scheduled timeopht_sched_tm

The clock time at which a patient's ophthalmology appointment is planned to begin, including visits for routine vision screening, diagnostic imaging, or surgical procedures such as LASIK or intravitreal injections. Used in eye care scheduling systems to coordinate clinical resources and manage appointment slot utilization.

ophthalmology street addressopht_st_addr

The street-level address line for a facility or practice providing ophthalmology services, such as an eye clinic, surgical center, or hospital-based eye department. Used in provider directory and patient navigation systems to direct patients to the correct eye care delivery site for appointments and procedures.

ophthalmology unitopht_unt

The standardized unit of measure used to quantify services, procedures, or supplies within eye care clinical workflows. Used in billing, clinical documentation, and claims processing to capture the quantity of ophthalmology services rendered, such as exam units, treatment sessions, or surgical procedure counts.

order addressord_addr

The physical location text associated with a clinical service request in EHR and order management systems. Captures the facility, department, or delivery site where the ordered service is to be performed or fulfilled, supporting routing and fulfillment workflows.

order approval statusord_appr_sts

Indicates the current authorization state of a clinical order, such as pending, approved, denied, or cancelled. Tracked in order management workflows to ensure clinical services, medications, or procedures have received required sign-off before fulfillment, supporting compliance and care coordination across departments.

order charge amountord_chrg_amt

The gross charge amount billed for a clinical order prior to adjustments, contractual allowances, or insurance payments. Captured in revenue cycle and clinical data systems to support cost tracking, charge reconciliation, and financial reporting at the individual order transaction level.

PreviousPage 158 of 325Next