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

supply admission datesupl_admn_dt

The hospital entry date recorded for a clinical material or supply item in EHR and claims systems. Used by data engineers to reconcile supply utilization timelines with inpatient encounters, enabling accurate cost allocation and inventory tracking across facility billing records.

supply discharge datesupl_dsch_dt

The hospital release date associated with a clinical supply item in EHR and facility claims systems. Data engineers use this field to calculate supply usage duration during inpatient stays and align supply billing records with UB-04 revenue code discharge timelines.

supply labelsupl_lbl

The standardized display name or descriptive text assigned to a clinical supply item used in patient care, surgery, or treatment. Corresponds to catalog descriptions in supply chain management systems and links physical inventory to clinical documentation, charge capture, and procurement workflows.

supply procedure datesupl_proc_dt

The calendar date on which a clinical supply item was utilized during a patient procedure, treatment, or intervention. Used in charge capture, cost allocation, and clinical documentation to associate supply consumption with specific procedural events for billing and outcomes tracking.

supply surgery datesupl_surg_dt

The calendar date on which a clinical supply item was consumed during a surgical procedure. Used in perioperative supply chain management, surgical case costing, and claims billing to associate specific supply usage with the operative event for reimbursement and inventory reconciliation.

surgeon active indicatorsurg_actv_ind

A binary flag indicating whether a surgeon currently holds active operating privileges and is eligible to perform surgical procedures within the facility or network. Used in credentialing systems, surgical scheduling, and claims adjudication to validate surgeon status at the time of service.

surgeon active statussurg_actv_sts

A coded value representing the current operational standing of a surgeon within a facility or payer network, such as active, inactive, suspended, or probationary. Used in credentialing, provider enrollment, surgical scheduling, and claims validation to determine eligibility for surgical case assignment.

surgeon agesurg_age

The calculated age in years of the surgeon at a reference point, such as credentialing date or system enrollment. Used in workforce analytics, demographic reporting, and succession planning within surgical departments and provider network management systems.

surgeon allowed amountsurg_alwd_amt

The maximum dollar amount a payer will reimburse for surgical services rendered by a specific surgeon under a contracted fee schedule or benefit plan. Used in claims adjudication and remittance processing to calculate patient cost-sharing obligations and determine payment to the surgeon.

surgeon approved bysurg_appr_by

The identifier or name of the credentialing officer, medical staff committee member, or system user who formally authorized a surgeon's privileges, case assignment, or documentation within a clinical or administrative workflow. Used in accountability tracking and approval audit trails.

surgeon arrival timesurg_arrv_tm

The recorded time at which the assigned surgeon arrived in the perioperative area, operating suite, or designated staging location. Used in surgical workflow management, on-time start tracking, case delay analysis, and operational efficiency reporting for surgical services departments.

surgeon arrived datesurg_arrv_dt

The calendar date on which the assigned surgeon arrived at the facility or operating suite for a scheduled surgical case. Used in perioperative workflow documentation, case delay tracking, and surgical scheduling compliance reporting to support operational and quality improvement initiatives.

surgeon assessmentsurg_asmt

The surgeon's documented clinical evaluation of a patient's condition, surgical findings, and postoperative status. Recorded in operative notes or preoperative assessments within the clinical record, this narrative or structured content supports care planning, coding, and clinical quality review.

surgeon blood pressuresurg_bp

The recorded systolic and diastolic blood pressure measurement for the patient taken within the perioperative setting and attributed to the surgeon's clinical assessment. Used in anesthesia documentation, preoperative screening, and intraoperative monitoring to evaluate surgical risk and patient safety.

surgeon cancelled datesurg_cncl_dt

The calendar date on which a scheduled surgical case assigned to a specific surgeon was formally cancelled. Used in surgical scheduling systems and operational reporting to track case cancellation patterns, analyze surgeon availability impacts, and measure OR utilization efficiency.

surgeon chief complaintsurg_cc

The primary symptom or reason for visit documented by or about the operating surgeon during a surgical encounter. Captured in clinical records to establish medical necessity, guide operative planning, and support surgical outcome tracking and quality reporting.

surgeon citysurg_city

The city associated with the operating surgeon's practice or facility address. Used in provider credentialing, referral network management, and claims processing to verify surgeon location, validate network participation, and support geographic analysis of surgical services.

surgeon completed datesurg_cmpl_dt

The date on which the surgeon finalized all required documentation, procedures, or assigned tasks related to a surgical case. Used in surgical workflow tracking, operative record completion audits, and compliance monitoring for timely clinical documentation.

surgeon countrysurg_ctry

The country associated with the operating surgeon's practice or licensure address. Used in provider credentialing and claims adjudication to verify jurisdiction, validate international provider records, and support cross-border care coordination and regulatory compliance.

surgeon created bysurg_crtd_by

The system username or user identifier of the individual who originally entered the surgeon's record into the clinical or administrative system. Used in audit trails to track data entry accountability, record ownership, and security compliance across surgical information systems.

PreviousPage 689 of 806Next