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 effective dateop_eff_dt

Date on which a surgical procedure record, protocol, or associated authorization becomes active and applicable within the clinical or administrative system. Used to manage version-controlled procedure definitions and ensure correct billing codes align with service dates.

operation emailop_eml

Electronic mail address associated with the surgical operation record, typically linked to the responsible surgical team, department, or facility contact. Used for care coordination, procedure notifications, and communication workflows within perioperative management systems.

operation end dateop_end_dt

Date on which a surgical procedure was completed or a related operational record became inactive. Used in perioperative documentation, episode-of-care tracking, and surgical outcomes reporting to establish the full duration of a procedure or authorization period.

operation end timeop_end_tm

Timestamp marking the conclusion of a surgical procedure, recorded when the patient leaves the operative field or anesthesia ends. Used in perioperative systems to calculate total procedure duration, OR utilization metrics, and anesthesia billing calculations.

operation entered byop_ent_by

Identifier of the user or system that created or recorded the surgical operation entry in the clinical information system. Supports accountability, audit logging, and data quality review within perioperative and surgical documentation workflows.

operation ethnicityop_ethn

Ethnicity of the patient undergoing a surgical procedure, captured at the time of operative documentation. Used in surgical outcome studies, health equity reporting, and population health analytics to identify disparities in surgical care access and postoperative results.

operation expiration dateop_exp_dt

Date after which a surgical procedure authorization, protocol definition, or procedural record is no longer valid for clinical or billing use. Used in prior authorization management and surgical scheduling to prevent claims submission for expired procedure approvals.

operation external identifierop_ext_id

Unique identifier assigned to a surgical procedure by an external system, such as a referring facility, clearinghouse, or interoperability platform. Enables cross-system reconciliation of operative records during data exchange, claims adjudication, and care coordination workflows.

operation faxop_fax

Facsimile number associated with the surgical department, facility, or care team responsible for a procedure. Used to transmit operative reports, prior authorization requests, and surgical scheduling confirmations between provider offices and facilities in perioperative workflows.

operation feeop_fee

Monetary charge associated with performing a specific surgical procedure, reflecting the billed or contracted rate for operative services. Used in surgical billing, fee schedule management, and claims adjudication to calculate provider reimbursement and patient cost-sharing amounts.

operation first nameop_first_nm

Given name of the patient or responsible clinician associated with a surgical procedure record. Used in perioperative patient identification, surgical scheduling systems, and operative documentation to ensure accurate matching of procedures to the correct individual.

operation flagop_flg

Binary or coded indicator used to mark a surgical procedure record with a specific status or characteristic, such as high-risk designation, complication occurrence, or audit selection. Supports surgical quality programs, case review workflows, and outcomes tracking systems.

operation full nameop_full_nm

Complete standardized name of a surgical procedure, combining all name components into a single displayable value. Used in operative reports, procedure catalogs, surgical scheduling interfaces, and clinical documentation to unambiguously identify and communicate the procedure performed.

operation genderop_gndr

Recorded gender of the patient undergoing a surgical procedure, captured for clinical documentation and demographic reporting purposes. Used in surgical outcome research, preoperative assessment workflows, and health equity analyses examining gender-based differences in surgical care.

operation glucoseop_gluc

Blood glucose measurement recorded in association with a surgical procedure, typically captured during preoperative assessment or intraoperative monitoring. Used in perioperative diabetes management protocols to guide insulin administration and reduce surgical complications in high-risk patients.

operation group numberop_grp_nbr

Identifier linking a surgical procedure to a specific insurance group plan, used to verify coverage and route claims correctly during surgical billing. Supports eligibility verification, prior authorization submission, and claims adjudication for operative services across payer systems.

operation hemoglobinop_hgb

The hemoglobin level measured in grams per deciliter recorded in association with a surgical procedure. Used in perioperative clinical documentation to assess patient blood oxygen-carrying capacity, inform transfusion decisions, and evaluate surgical risk before, during, or after an operation.

operation identifierop_id

The unique system-generated or facility-assigned identifier for a specific surgical procedure record. Used in clinical and surgical data systems to link operative notes, anesthesia records, pathology specimens, and postoperative outcomes to a single distinct surgical encounter across all clinical workflows.

operation indexop_idx

The sequential position number assigned to a surgical procedure within a series of operations performed on the same patient or within the same encounter. Used in clinical data systems to distinguish and order multiple procedures when a patient undergoes more than one operation during a care episode.

operation indicatorop_ind

A boolean or coded flag that denotes whether a surgical procedure has occurred, is planned, is in progress, or meets a specific clinical criterion. Used in clinical data systems to trigger workflows, filter surgical case records, and support reporting on operative status across patient populations.

PreviousPage 154 of 325Next