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 classop_cls

The classification tier assigned to a surgical procedure, such as elective, urgent, or emergent, or a wound classification like clean or contaminated. Used in surgical scheduling, risk stratification, quality reporting, and operative outcome analysis workflows.

operation codeop_cd

The standardized procedural code, such as CPT, ICD-10-PCS, or a facility-specific code, assigned to identify a surgical intervention. Used across claims processing, operative documentation, surgical scheduling, and clinical analytics to uniquely identify and categorize the performed procedure.

operation commentop_cmt

Free-text narrative field capturing supplemental notes, clinical observations, or administrative remarks associated with a surgical procedure. Used by clinicians or surgical staff to document details not captured in structured fields, supporting operative documentation and care coordination.

operation completed dateop_cmpl_dt

The calendar date on which a surgical procedure or operative intervention was fully completed. Used to track procedure closure, calculate operative durations, trigger post-operative workflows, and support surgical case reporting and quality measurement.

operation confidential indicatorop_conf_ind

A binary flag designating that a surgical procedure record contains sensitive or restricted information requiring heightened privacy controls. Used to limit access to operative records in compliance with HIPAA, facility policy, or patient-directed confidentiality requests in clinical systems.

operation countop_cnt

The total number of surgical procedures or operative events recorded for a patient, encounter, or reporting period. Used in utilization tracking, surgical volume analytics, quality benchmarking, and population health reporting to quantify operative activity.

operation countryop_ctry

The name or code of the country where the surgical procedure was performed or where the associated facility is located. Used in international patient records, medical tourism tracking, cross-border claims processing, and geographic reporting within clinical data systems.

operation created byop_crtd_by

The unique identifier of the user, clinician, or system that initially created the surgical procedure record in the clinical or administrative system. Used for audit trail purposes, data governance, accountability tracking, and troubleshooting record integrity in operative data workflows.

operation created dateop_crtd_dt

The calendar date on which the surgical procedure record was initially entered or generated in the clinical or administrative system. Used for audit trail purposes, data lineage tracking, and distinguishing record creation time from the actual date of the surgical event.

operation created timeop_crtd_tm

The timestamp indicating the exact time of day when the surgical procedure record was initially created in the system. Used alongside the created date for precise audit trail documentation, data sequencing, and workflow tracking in operative and perioperative systems.

operation creatinineop_cr

The serum creatinine laboratory value documented in association with a surgical procedure, used to assess pre-operative or peri-operative renal function. Critical for surgical risk stratification, anesthesia planning, contrast agent decisions, and post-operative kidney function monitoring.

operation dateop_dt

The calendar date on which a surgical procedure or operative intervention was performed. Serves as a primary temporal reference for the surgical encounter, used in operative documentation, claims adjudication, surgical scheduling, and longitudinal patient history tracking.

operation datetimeop_dttm

The combined date and time value recording when a surgical procedure or operative intervention occurred or was scheduled. Used for precise temporal tracking of surgical events, operating room scheduling, anesthesia timing, case duration calculations, and perioperative workflow coordination.

operation dea numberop_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician or facility involved in the surgical encounter, particularly relevant when controlled substances are administered during anesthesia or post-operative pain management in the operative setting.

operation death dateop_death_dt

The calendar date of patient death recorded in association with a surgical procedure or operative encounter. Used in surgical outcomes reporting, mortality analysis, post-operative complication tracking, and quality improvement programs such as NSQIP and facility-level surgical mortality reviews.

operation deleted dateop_del_dt

The calendar date on which a surgical procedure record was marked as deleted or logically removed from the active dataset in the clinical or administrative system. Used for audit trail documentation, data reconciliation, and maintaining historical record integrity in operative data management.

operation deleted indicatorop_del_ind

Flag indicating whether a surgical operation record has been logically deleted from the clinical system. Supports audit trails and data governance by preserving removed procedure records while excluding them from active reporting, scheduling, and clinical workflows.

operation descriptionop_desc

Human-readable text describing the nature, scope, and purpose of a surgical procedure. Used in operative reports, surgical scheduling systems, and clinical documentation to communicate procedure details to care teams, coders, and billing staff processing surgical claims.

operation detailop_dtl

Granular clinical or administrative information captured for a specific surgical procedure, such as technique notes, instrumentation used, or intraoperative findings. Supports clinical documentation, quality review, and retrospective analysis within surgical information systems.

operation due dateop_due_dt

Target date by which a scheduled surgical procedure must be performed, based on clinical urgency, authorization expiration, or care pathway protocols. Used in surgical scheduling and utilization management to prioritize procedures and ensure timely patient care delivery.

PreviousPage 153 of 325Next