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 labelsurg_lbl

The standardized display text or formatted name used to represent the operating surgeon in user interfaces, surgical scheduling systems, and clinical reports. Ensures consistent identification of the surgeon across operative documentation, case scheduling, and billing workflows within healthcare information systems.

surgeon languagesurg_lang

The preferred spoken or written communication language of the operating surgeon, recorded in credentialing and provider demographic systems. Used to facilitate patient-surgeon communication, optimize surgical team assignments, and support language concordance in facilities serving diverse patient populations.

surgeon last namesurg_last_nm

The family surname of the operating surgeon as recorded in credentialing, provider directories, and surgical case documentation. Used to identify and display the surgeon across operative reports, claims submissions, scheduling systems, and quality reporting platforms within clinical data environments.

surgeon legal namesurg_legal_nm

The full official registered name of the operating surgeon as it appears on state licensure, DEA registration, and medical board credentials. Used for credentialing verification, claims adjudication, privileging documentation, and regulatory compliance reporting across healthcare administrative systems.

surgeon license numbersurg_lic_nbr

The state-issued professional medical license identifier assigned to the operating surgeon by the relevant medical licensing board. Used to verify active licensure, validate surgical privileges, support credentialing workflows, and ensure regulatory compliance in claims and operative documentation systems.

surgeon marital statussurg_mar_sts

The current marital or domestic relationship status of the operating surgeon as recorded in HR, credentialing, or occupational health systems. Used in benefits administration, workforce demographic reporting, and provider demographic data management within healthcare organizational systems.

surgeon master identifiersurg_mstr_id

The enterprise master person index identifier uniquely assigned to an operating surgeon across all facilities and systems within a health network. Used to reconcile surgeon records, eliminate duplicates, and link credentialing, scheduling, claims, and clinical data across disparate healthcare information systems.

surgeon maximumsurg_max

The upper threshold or maximum permissible value associated with a surgeon-specific metric, such as case volume limits, procedure counts, or scheduling capacity. Used in surgical operations management, quality oversight, and workforce planning to enforce safety and productivity boundaries across surgical service lines.

surgeon middle namesurg_mid_nm

The middle name or initial of the operating surgeon as recorded in credentialing, licensure, and provider demographic systems. Used to disambiguate surgeons with similar names, support identity verification in privileging workflows, and ensure accurate provider attribution in clinical and claims documentation.

surgeon minimumsurg_min

The lower threshold or minimum required value associated with a surgeon-specific metric, such as mandatory case volume requirements, competency thresholds, or procedural quotas. Used in credentialing decisions, privileging reviews, and surgical quality assurance programs to validate clinical competency standards.

surgeon mobilesurg_mob

The mobile or cellular phone number for the operating surgeon recorded in provider contact directories and on-call scheduling systems. Used to facilitate urgent surgical team communications, on-call notifications, care coordination, and emergency contact workflows across hospital and clinical operations systems.

surgeon modified bysurg_mod_by

The system username or user identifier of the individual who last updated the operating surgeon's record in the clinical or administrative data system. Used for audit trail purposes, data governance compliance, and change history tracking within credentialing, scheduling, and surgical data management platforms.

surgeon modified timesurg_mod_tm

The precise date and timestamp recording when the operating surgeon's data record was most recently updated in the clinical or administrative system. Used to maintain audit trail integrity, support data governance requirements, and track record change history across credentialing and surgical information systems.

surgeon onset datesurg_onset_dt

The date on which a surgical patient's presenting symptoms or condition first began, as documented by the operating surgeon in the surgical assessment or operative note. Used to establish clinical timeline, support diagnosis coding accuracy, and provide context for surgical necessity in claims and clinical documentation.

surgeon oxygen saturationsurg_o2sat

The peripheral blood oxygen saturation level recorded for the operating surgeon during occupational health screenings or fitness-for-duty evaluations. Used to assess surgeon respiratory health and clinical readiness, particularly relevant in high-altitude facilities or when evaluating surgeon wellness for prolonged surgical procedures.

surgeon paid amountsurg_pd_amt

The actual dollar amount reimbursed to the operating surgeon for a surgical procedure on a medical claim. Reflects insurer or payer payment after contractual adjustments, copays, and deductibles are applied to the billed surgeon charge.

surgeon paid datesurg_pd_dt

The calendar date on which payment was issued to the operating surgeon for a surgical claim. Used in claims adjudication tracking to reconcile remittance advice, measure payment cycle times, and audit surgeon reimbursement timelines.

surgeon preferred namesurg_pref_nm

The preferred display name of the operating surgeon as it should appear in clinical documentation, patient-facing records, and reporting systems. May differ from legal name and is used to ensure consistent surgeon identification across care team communications.

surgeon pricesurg_prc

The billed or contracted price for surgical services rendered by the operating surgeon on a claim or procedure record. Represents the fee schedule or negotiated rate before payer adjustments, used in cost analysis and contract performance reporting.

surgeon procedure datesurg_proc_dt

The calendar date on which the operating surgeon performed a surgical procedure. Captured on medical claims and operative records to establish the service date for adjudication, clinical timelines, quality measurement, and outcomes reporting.

PreviousPage 691 of 806Next