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 death datesurg_death_dt

The date of patient death associated with a surgical or operative procedure record in EHR, mortality registries, and claims systems. Data engineers use this field to calculate post-surgical mortality rates, support outcomes research, and flag deceased patients during surgical cohort analysis and quality measure reporting.

surgery descriptionsurg_desc

The textual explanation describing the nature and scope of a surgical or operative procedure in EHR, claims, and clinical documentation systems. Data engineers use this field to validate procedure code assignments, support NLP-based code suggestion workflows, and enrich surgical data records for clinical analytics and audit purposes.

surgery detailsurg_dtl

The specific granular information associated with a surgical or operative procedure record in EHR, operative notes, and claims systems. Data engineers use this field to capture supplemental procedure attributes such as laterality, approach, or implant details, supporting precise clinical coding, cost modeling, and surgical outcomes analysis.

surgery discharge datesurg_dsch_dt

The hospital release date marking when a patient was discharged following an operative procedure. Used in EHR, claims, and surgical case management systems to calculate length of stay, trigger post-surgical care workflows, and validate inpatient billing timelines.

surgery effective datesurg_eff_dt

The date on which an operative procedure authorization, benefit coverage, or surgical service record becomes active. Used in EHR, claims adjudication, and prior authorization systems to validate that surgical services fall within approved coverage windows and contract terms.

surgery emailsurg_eml

The electronic mail address associated with a surgical provider, surgical center, or operative care team contact. Used in provider directory, EHR, and care coordination systems to route pre-operative instructions, consent forms, and post-surgical follow-up communications to the appropriate surgical contact.

surgery end datesurg_end_dt

The date marking the completion of a surgical episode, authorization period, or operative care record. Used in EHR, surgical case management, and claims systems to define the bounds of a surgical service window and support episode-of-care analytics and reimbursement reconciliation.

surgery expiration datesurg_exp_dt

The date after which a surgical authorization, surgical benefit coverage, or operative service record is no longer valid. Used in prior authorization, claims adjudication, and EHR systems to prevent payment of expired surgical approvals and enforce benefit period boundaries.

surgery flagsurg_flg

A binary indicator denoting whether a claim line, encounter record, or member episode involves an operative procedure. Used in claims processing, EHR, and analytics platforms to filter surgical records, trigger surgical-specific adjudication rules, and support case management identification workflows.

surgery identifiersurg_id

The unique alphanumeric key assigned to an operative procedure record, surgical case, or surgical authorization within a healthcare data system. Used in EHR, claims, and surgical scheduling platforms to link pre-operative, intraoperative, and post-operative records across systems for longitudinal tracking.

surgery indexsurg_idx

The positional sequence number assigned to an operative procedure within a multi-surgery encounter or surgical case record. Used in EHR, claims, and surgical documentation systems to order and differentiate multiple procedures performed during the same operative session for billing and clinical analysis.

surgery indicatorsurg_ind

A boolean or coded value denoting the presence, type, or status of an operative procedure within a claim, encounter, or member record. Used in EHR, claims adjudication, and population health platforms to classify surgical events, apply procedure-specific pricing, and trigger case management workflows.

surgery instructionsurg_instr

Structured or free-text guidance associated with an operative procedure, including pre-operative preparation, consent requirements, or post-surgical care directives. Used in EHR, surgical scheduling, and care coordination systems to standardize patient and provider communications around operative procedure workflows.

surgery levelsurg_lvl

A coded hierarchy value indicating the complexity, acuity, or classification tier of an operative procedure within a surgical coding framework. Used in EHR, claims, and surgical case management systems to apply appropriate reimbursement rates, resource allocation, and anesthesia billing rules based on procedure complexity.

surgery modified datesurg_mod_dt

The timestamp recording the most recent update to a surgical case record, operative procedure authorization, or surgical documentation entry. Used in EHR, claims, and audit systems to track data lineage, support record versioning, and identify post-adjudication changes to surgical service records.

surgery namesurg_nm

The descriptive label assigned to an operative procedure, surgical service type, or surgical program within a healthcare data system. Used in EHR, claims, provider portal, and surgical scheduling platforms to display human-readable procedure descriptions alongside CPT or ICD procedure codes.

surgery notesurg_nt

Free-text or structured annotation attached to a surgical case record, operative procedure authorization, or post-surgical encounter. Used in EHR, claims review, and care management systems to capture clinical nuances, operative complications, anesthesia details, and adjudication remarks not represented in coded fields.

surgery numbersurg_nbr

A numeric reference value assigned to a surgical case, operative procedure claim, or surgical authorization record within a healthcare data system. Used in EHR, claims processing, and surgical scheduling platforms to cross-reference operative records across facilities, billing systems, and payer adjudication workflows.

surgery parentsurg_prnt

The superior hierarchical record linking a surgical sub-procedure or surgical line item to its primary operative procedure or surgical episode. Used in EHR, claims, and surgical case management systems to associate ancillary operative services, assistant surgeon charges, and component procedures to a primary surgery record.

surgery percentagesurg_pct

A ratio value expressing reimbursement allocation, surgical time share, co-surgeon contribution, or procedure complexity weighting for an operative service. Used in claims adjudication, anesthesia billing, and surgical cost analytics systems to calculate proportional payments and resource utilization metrics.

PreviousPage 694 of 806Next