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

surgeon total countsurg_tot_cnt

The aggregated number of surgeons associated with a facility, network, specialty group, or reporting period. Used in workforce analytics, network adequacy assessments, and surgical volume reporting to measure surgical capacity and support operational planning within health systems.

surgeon updated datesurg_upd_dt

The date on which a surgeon's record was most recently modified in the system, including changes to credentials, contact information, or specialty classifications. Used in provider data governance and audit tracking to ensure accuracy and currency of surgeon information across administrative systems.

surgeon urgencysurg_urg

A classification indicating the clinical urgency level of a surgical procedure performed by the surgeon, such as elective, urgent, or emergent. Used in surgical scheduling, operating room prioritization, and outcomes reporting to distinguish planned procedures from time-sensitive or life-threatening interventions.

surgeon versionsurg_ver

A numeric or alphanumeric identifier tracking the iteration of a surgeon's record within the system, incremented with each update to credentials, contract terms, or demographic data. Used in data lineage, audit trails, and change management to maintain historical accuracy of surgeon records.

surgeon zipsurg_zip

The five or nine-digit postal ZIP code associated with a surgeon's primary practice or billing address. Used in provider directory services, geographic access analysis, network mapping, and claims processing to identify service location and support regional healthcare planning and regulatory compliance.

surgery addresssurg_addr

The physical location text identifying where a surgical procedure was performed, stored in EHR, claims, and provider master data systems. Used by data engineers to geocode surgical sites, validate provider network assignments, and support place-of-service audits in claims processing pipelines.

surgery admission datesurg_admn_dt

The hospital entry date for a surgical or operative procedure service in EHR, inpatient claims, and facility billing systems. Data engineers use this field to anchor surgical episode timelines, calculate length-of-stay metrics, and join surgical records to UB-04 inpatient encounter data.

surgery amountsurg_amt

The monetary value associated with a surgical or operative procedure service in claims, EHR, and facility billing systems. Data engineers use this field to aggregate procedure-level costs, validate against allowed amounts, and support surgical episode payment analysis across professional and facility claim types.

surgery balancesurg_bal

The outstanding unpaid amount remaining for a surgical or operative procedure service in claims adjudication and accounts receivable systems. Data engineers use this field to track post-adjudication liability, reconcile member cost-sharing obligations, and monitor surgical claim payment cycle completeness.

surgery birth datesurg_birth_dt

The date of birth of the patient or provider associated with a surgical procedure record in EHR and claims systems. Data engineers use this field to calculate patient age at time of surgery, validate eligibility, and support age-based procedure appropriateness analytics in clinical and claims datasets.

surgery categorysurg_cat

The grouping classification assigned to a surgical or operative procedure service in EHR, claims, and clinical data systems. Data engineers use this field to segment surgical procedures into clinical domains such as cardiovascular or orthopedic, supporting service line reporting and procedure-based cost grouping.

surgery childsurg_chld

The subordinate relationship identifier linking a secondary or component surgical procedure to a parent procedure record in EHR and claims systems. Data engineers use this field to reconstruct hierarchical surgical encounter structures, supporting bundled payment analysis and multi-procedure claim adjudication workflows.

surgery classsurg_cls

The classification tier assigned to a surgical or operative procedure service in EHR, claims, and facility billing systems. Indicates procedure complexity, setting type, or payer-defined category. Data engineers use this field to stratify surgical claims for risk adjustment, reimbursement modeling, and quality reporting pipelines.

surgery codesurg_cd

The standardized classification value identifying a surgical or operative procedure in EHR, professional claims, and facility billing systems, typically a CPT or ICD procedure code. Data engineers use this field to map surgical services to fee schedules, groupers, and clinical quality measures across claims datasets.

surgery commentsurg_cmt

The free-text notation field capturing supplemental clinical or administrative information about a surgical procedure in EHR and claims systems. Data engineers use this field for NLP extraction, audit trail documentation, and flagging records requiring manual review during surgical claim adjudication or clinical data ingestion processes.

surgery contactsurg_cntct

The communication point associated with a surgical or operative procedure service, such as a referring provider or scheduling contact, in EHR and provider data systems. Data engineers use this field to link surgical encounters to provider directories and support care coordination and referral pattern analytics.

surgery countsurg_cnt

The occurrence number representing how many surgical or operative procedure services are recorded within a defined context in EHR, claims, and utilization management systems. Data engineers use this field to aggregate procedure volume, identify repeat surgical events, and support surgical utilization rate calculations across member populations.

surgery created datesurg_crtd_dt

The record creation timestamp for a surgical or operative procedure entry in EHR, claims, and data warehouse systems. Data engineers use this field to establish data lineage, support incremental ETL load strategies, and detect late-arriving surgical records during claims adjudication and clinical data reconciliation processes.

surgery datesurg_dt

The calendar date on which a surgical or operative procedure was performed, recorded in EHR, professional claims, and facility billing systems. Data engineers use this field as the primary event anchor for surgical episode construction, timely filing validation, and longitudinal patient surgical history analysis.

surgery datetimesurg_dttm

The combined date and time value capturing the precise moment a surgical or operative procedure occurred in EHR and perioperative data systems. Data engineers use this field to sequence intraoperative events, calculate procedure duration, and support time-stamped surgical workflow analytics and operating room utilization reporting.

PreviousPage 693 of 806Next