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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

surgery periodsurg_prd

The defined time span covering an operative episode, surgical authorization window, or post-surgical recovery duration. Used in EHR, claims, and care management systems to bound surgical benefit eligibility, track global surgery periods for follow-up visit billing, and measure episode-of-care cost and utilization.

surgery phonesurg_ph

The telephone contact number associated with a surgical provider, operating facility, or surgical care coordination team. Used in provider directory, EHR, and referral management systems to facilitate pre-operative scheduling, intraoperative communication, and post-surgical follow-up coordination across care settings.

surgery prioritysurg_prty

A ranked value indicating the clinical urgency or scheduling precedence of an operative procedure, such as elective, urgent, or emergent classification. Used in EHR, surgical scheduling, and prior authorization systems to allocate OR resources, determine authorization turnaround requirements, and manage surgical queue sequencing.

surgery quantitysurg_qty

Count of operative procedure units billed or performed, captured in EHR and medical claims systems. Used by data engineers to validate procedure unit billing against revenue codes, identify duplicate claims, and reconcile surgical service line items in 837I/837P transactions.

surgery rangesurg_rng

Defined value span representing allowable limits for operative procedure metrics such as duration, units, or cost in claims and EHR systems. Data engineers use this to flag outliers in surgical billing, enforce edit checks, and validate procedure codes against payer-defined thresholds.

surgery ratesurg_rt

Unit price or reimbursement rate assigned to an operative procedure service in claims, fee schedules, or contract management systems. Critical for data engineers reconciling allowed amounts, negotiated rates, and surgical DRG payments across payer contracts and remittance advice files.

surgery reasonsurg_rsn

Explanatory text or coded rationale documenting why an operative procedure was performed, sourced from EHR clinical notes, prior authorization systems, or claims. Data engineers use this field to map ICD-10 diagnosis codes to procedure justification in surgical utilization analytics.

surgery referencesurg_ref

External identifier or pointer linking an operative procedure service to related records such as prior authorizations, referral numbers, or clinical orders in EHR and claims systems. Data engineers use this to join surgical encounters across disparate source systems and audit referral compliance.

surgery resultsurg_rslt

Outcome measurement or finding recorded following an operative procedure, captured in EHR postoperative documentation or quality reporting systems. Data engineers use this field to populate surgical quality metrics, HEDIS outcome measures, and value-based care performance dashboards.

surgery scoresurg_scr

Calculated numeric rating associated with an operative procedure, such as a risk stratification score, quality indicator, or provider performance metric in EHR and analytics platforms. Data engineers use this to support surgical risk models, readmission prediction, and outcomes benchmarking workflows.

surgery sequencesurg_seq

Ordering number indicating the position of an operative procedure among multiple surgeries performed during the same encounter, used in EHR, ASC, and inpatient claims systems. Data engineers rely on this to correctly order procedure codes in 837 transactions and surgical case logs.

surgery service datesurg_svc_dt

Date on which an operative procedure service was delivered to a patient, as recorded in EHR operative reports and medical claims. Data engineers use this field for episode-of-care grouping, claims adjudication timelines, surgical utilization trending, and coordination of benefits validation.

surgery severitysurg_sev

Coded or descriptive measure of the clinical seriousness or complexity of an operative procedure, sourced from EHR acuity scores or APR-DRG severity levels in inpatient claims. Data engineers use this to stratify surgical populations, support case-mix index calculations, and validate DRG assignments.

surgery sourcesurg_src

Origin reference identifying the system, facility, or data feed from which an operative procedure record was received, such as EHR, ASC billing system, or clearinghouse. Data engineers use this to track data lineage, resolve duplicate surgical records, and manage multi-source ingestion pipelines.

surgery start datesurg_start_dt

Beginning date of an operative procedure or surgical episode, recorded in EHR perioperative systems and inpatient claims. Data engineers use this field to calculate procedure duration, define episode boundaries, measure length of stay, and align surgical records with authorization effective date ranges.

surgery statussurg_sts

Current state of an operative procedure record such as scheduled, completed, cancelled, or pending in EHR, OR scheduling, and claims systems. Data engineers use this field to filter active surgical records, track claim adjudication states, and identify incomplete or voided procedure entries.

surgery targetsurg_tgt

Destination reference identifying the anatomical site, organ system, or procedural target associated with an operative service in EHR clinical documentation and procedure coding systems. Data engineers use this to validate CPT-to-body-site alignment, support laterality edits, and populate surgical registry submissions.

surgery timesurg_tm

Time of day at which an operative procedure was initiated or completed, recorded in EHR perioperative systems and OR scheduling platforms. Data engineers use this for procedure duration calculations, resource utilization analytics, anesthesia billing reconciliation, and surgical timestamp auditing.

surgery timestampsurg_ts

Combined date and time value marking a key event in an operative procedure lifecycle, such as incision time or procedure completion, captured in EHR and perioperative systems. Data engineers use this for precise event sequencing, audit trail construction, and surgical duration metric calculations.

surgery totalsurg_tot

Aggregated sum value representing total billed charges, allowed amounts, or procedure units for an operative service in medical claims and EHR billing systems. Data engineers use this field for surgical cost analysis, provider profiling, contract performance reporting, and claims payment reconciliation.

PreviousPage 695 of 806Next