mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 operations terms

operation titleop_ttl

The formal designation for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation totalop_tot

The sum value for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation total countop_tot_cnt

The sum of occurrences for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation typeop_typ

The category classification for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation unitop_unt

The single item or measure for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation updated dateop_upd_dt

The last change date for a surgical intervention. Used to track temporal information related to operation updated date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation urgencyop_urg

The time sensitivity level for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation versionop_ver

The record version number for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

operation zipop_zip

The postal code for a surgical intervention. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for operation management and reporting.

ophthalmology addressopht_addr

The physical location text for a eye specialty care. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

ophthalmology effective dateopht_eff_dt

The active beginning date for a eye specialty care. Used to track temporal information related to ophthalmology effective date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

ophthalmology scheduled dateopht_sched_dt

The planned appointment date for a eye specialty care. Used to track temporal information related to ophthalmology scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

ophthalmology scheduled timeopht_sched_tm

The planned time for a eye specialty care. Used to track temporal information related to ophthalmology scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

ophthalmology street addressopht_st_addr

The street location for a eye specialty care. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

ophthalmology unitopht_unt

The single item or measure for a eye specialty care. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ophthalmology management and reporting.

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

The authorization state for a clinical service request. Used to track the current state or condition of the order. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for order management and reporting.

order charge amountord_chrg_amt

The service charge value for a clinical service request. Used to capture financial data associated with order transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for order management and reporting.

order effective dateord_eff_dt

The date on which a clinical order becomes active and actionable within EHR and CPOE systems. Used in HL7 ORC/OBR segments and claims adjudication to determine order validity windows, authorization alignment, and care timeline sequencing across Epic, Cerner, and downstream data warehouses.

order medical record numberord_mrn

The patient medical record number for a clinical service request. Used as a unique reference to identify and track the order across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for order management and reporting.

PreviousPage 155 of 320Next