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 created timesurg_crtd_tm

The exact timestamp when the surgeon's record was first created in the clinical or administrative system. Used in audit logging, data lineage tracking, and system reconciliation to establish the origin point of surgeon profile data across healthcare information platforms.

surgeon creatininesurg_cr

The serum creatinine lab value recorded for a patient in the context of surgical risk assessment or perioperative evaluation performed by the surgeon. Used to assess renal function prior to surgery and inform anesthesia planning, medication dosing, and surgical clearance decisions.

surgeon dea numbersurg_dea_nbr

The Drug Enforcement Administration registration number assigned to the operating surgeon, authorizing them to prescribe controlled substances. Required for perioperative pain management prescribing, e-prescribing system validation, and regulatory compliance verification in surgical care settings.

surgeon deleted datesurg_del_dt

The date on which the surgeon's record was marked as inactive or logically deleted in the clinical or administrative system. Used to maintain historical data integrity, support auditing of record lifecycle changes, and prevent use of inactive surgeon profiles in active scheduling or claims workflows.

surgeon due datesurg_due_dt

The date by which a surgeon-related task, documentation requirement, or administrative obligation must be completed. Used in surgical workflow management to track pending operative notes, credentialing renewals, or compliance deadlines associated with the surgeon's record.

surgeon durationsurg_dur

The total elapsed time recorded for a surgical procedure performed by the operating surgeon, typically measured from incision to closure. Used in operative reporting, surgical efficiency analysis, OR scheduling optimization, and benchmarking surgeon performance against specialty-specific time standards.

surgeon emergency indicatorsurg_emerg_ind

A flag indicating whether the surgeon was involved in an emergency surgical case requiring immediate intervention outside of scheduled procedures. Used in OR management systems, trauma reporting, and claims adjudication to differentiate emergent from elective surgical encounters for billing and outcome analysis.

surgeon end timesurg_end_tm

The time at which the operating surgeon completed the surgical procedure or their active participation in the operative case. Used in OR scheduling systems, operative documentation, and surgical duration calculations to support efficiency reporting, staff coordination, and case costing.

surgeon entered bysurg_ent_by

The username or identifier of the staff member who manually entered data related to the surgeon's record or surgical case into the clinical system. Used in data audit trails, quality assurance reviews, and accountability tracking within surgical documentation and scheduling workflows.

surgeon ethnicitysurg_ethn

The self-reported or administratively recorded ethnicity of the operating surgeon. Used in workforce diversity analytics, credentialing databases, and healthcare equity reporting to monitor representation within surgical specialties and meet regulatory diversity data collection requirements.

surgeon external identifiersurg_ext_id

A unique identifier assigned to the surgeon by an external system, such as a health information exchange, referring organization, or payer platform. Used to correlate surgeon records across disparate systems, support interoperability, and enable accurate provider matching during data integration and claims processing.

surgeon faxsurg_fax

The facsimile number associated with the operating surgeon's office or practice location. Used in provider directories, referral coordination, and clinical communications to transmit operative reports, pre-authorization documents, and consultation requests to and from the surgeon's practice.

surgeon feesurg_fee

The professional fee charged by the operating surgeon for performing a surgical procedure. Used in claims billing, physician compensation modeling, fee schedule negotiation with payers, and financial reporting to calculate surgeon-level revenue and compare charges against contracted reimbursement rates.

surgeon first namesurg_first_nm

The legal given name of the operating surgeon as recorded in provider credentialing and clinical systems. Used to identify the surgeon in operative reports, scheduling interfaces, referral documentation, provider directories, and claims submissions requiring accurate physician name attribution.

surgeon full namesurg_full_nm

The complete legal name of the operating surgeon, typically combining prefix, first, middle, last, and suffix components. Used in operative documentation, provider credentialing records, claims submissions, patient-facing communications, and regulatory reporting requiring the surgeon's full formal identification.

surgeon gendersurg_gndr

The biological sex or gender identity of the operating surgeon recorded in surgical case documentation. Used in workforce analytics, credentialing systems, and diversity reporting to track surgeon demographics across surgical service lines and hospital departments.

surgeon glucosesurg_gluc

The blood glucose measurement recorded for the operating surgeon, typically captured during occupational health screenings or pre-procedural fitness evaluations. Used to assess surgeon wellness and ensure patient safety standards are met before high-acuity surgical procedures.

surgeon hemoglobinsurg_hgb

The hemoglobin concentration level recorded for the operating surgeon during occupational health assessments or fitness-for-duty evaluations. Used in surgeon wellness programs to monitor clinical staff health status and ensure procedural safety thresholds are maintained in surgical environments.

surgeon history present illnesssurg_hpi

The structured narrative documenting the chronological account of a surgical patient's current condition as evaluated and recorded by the operating surgeon. Captured in operative notes and surgical assessments to establish clinical context and justify the planned surgical intervention.

surgeon keysurg_key

The unique system-generated lookup reference value assigned to identify an operating surgeon within clinical and administrative data systems. Used as a relational key to link surgical cases, operative records, credentialing data, and claims across hospital information systems and data warehouses.

PreviousPage 690 of 806Next