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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

supply scheduled timesupl_sched_tm

The planned time at which a clinical supply or medical material item is scheduled to be delivered or made available for patient care. Used in perioperative and materials management workflows to ensure supplies are staged and available in alignment with scheduled procedures or treatments.

supply unitsupl_unt

The standardized unit of measure for clinical materials and medical supplies (e.g., each, box, case) in EHR charge capture, inventory, and claims systems. Data engineers rely on this field to normalize supply charge data, reconcile facility billing with revenue codes, and validate unit pricing against contract fee schedules.

surgeon approval statussurg_appr_sts

Indicates the credentialing, scheduling, or case assignment approval state for a surgeon associated with a planned or completed surgical procedure. Tracks whether the surgeon has been approved to perform a specific procedure, is credentialed at the facility, or has accepted a scheduled operative case.

surgeon charge amountsurg_chrg_amt

The billed or calculated charge amount attributed specifically to the operating surgeon for a surgical procedure. Used in professional fee billing and claims processing to capture surgeon-level reimbursement separate from facility or anesthesia charges within surgical revenue cycle workflows.

surgeon group numbersurg_grp_nbr

The identifier associated with the surgical group or practice under which a surgeon operates and bills for services. Used in claims processing and provider credentialing to link individual surgeons to their affiliated surgical practice group for reimbursement and contracting purposes.

surgeon medical record numbersurg_mrn

A medical record number linked to a surgeon's patient record or provider profile within a clinical system. Used to cross-reference surgeon-specific encounter data, operative notes, and case histories across clinical documentation and surgical scheduling systems within a facility.

surgeon scheduled datesurg_sched_dt

The calendar date on which a surgeon is scheduled to perform a specific operative procedure. Used in surgical scheduling and perioperative management workflows to coordinate operating room resources, anesthesia, nursing staff, and supplies with the assigned surgeon's availability.

surgeon scheduled timesurg_sched_tm

The specific time of day a surgeon is scheduled to begin or participate in an operative procedure. Used in perioperative and surgical scheduling workflows to coordinate operating room block time, staff assignments, and pre-operative preparations with the surgeon's planned case start.

surgeon street addresssurg_st_addr

The street-level practice or office address of a surgeon, used in provider directory management, claims processing, and referral coordination. Ensures accurate location data for the surgeon is maintained for patient communication, credentialing records, and payer contracting purposes.

surgical case cancellation reason codesurg_cxl_rsn_cd

A code identifying the reason a scheduled surgical procedure was cancelled on or before the day of surgery, such as patient medically unfit, equipment unavailable, surgeon unavailable, patient no-show, or insurance authorization not obtained. Surgical cancellation reason analysis identifies preventable cancellation patterns that reduce OR revenue and patient access.

survey addresssurv_addr

The mailing or contact address used to distribute patient experience or satisfaction surveys following a healthcare encounter. Used in patient engagement and quality measurement workflows to ensure survey instruments are sent to the correct location for CAHPS, HCAHPS, or other standardized feedback programs.

survey approval statussurv_appr_sts

Indicates the current authorization or review state of a patient satisfaction or clinical survey instrument, such as pending, approved, or rejected. Used in quality management workflows to control which surveys are active and eligible for distribution to patients or respondents.

survey charge amountsurv_chrg_amt

The monetary amount associated with administering or processing a healthcare survey, such as a CAHPS or HEDIS-related patient experience survey. Captures costs tied to survey vendor contracts, data collection services, or per-respondent fees tracked in financial reporting systems.

survey effective datesurv_eff_dt

The date on which a specific patient experience or clinical outcomes survey becomes active and eligible for distribution. Used in quality reporting systems to manage survey versioning, compliance windows, and alignment with measurement periods such as annual HEDIS or CMS Star Ratings cycles.

survey group numbersurv_grp_nbr

A numeric identifier that associates a survey record with a specific cohort, program, or population group within a quality measurement or patient experience reporting system. Used to segment survey results by care program, health plan, or clinical department for comparative analysis.

survey medical record numbersurv_mrn

The unique patient medical record number (MRN) linked to a survey response, connecting patient experience or clinical feedback data to the corresponding patient record. Used to correlate survey outcomes with clinical encounters, diagnoses, and care quality metrics in data analytics.

survey scheduled datesurv_sched_dt

The calendar date on which a patient satisfaction, CAHPS, or clinical outcomes survey is planned to be administered or distributed to a respondent. Used in survey operations management to track outreach schedules, follow-up timelines, and compliance with required measurement period windows.

survey scheduled timesurv_sched_tm

The specific time of day at which a healthcare survey is planned for administration or electronic distribution to a patient or respondent. Used alongside the scheduled date to coordinate automated survey delivery, phone interviews, or in-person administration within care quality workflows.

survey street addresssurv_st_addr

The physical street address associated with the location where a survey is administered or the mailing address used to distribute paper-based patient experience surveys. Used in survey logistics management to route mail surveys and track geographic distribution patterns in population health programs.

survey unitsurv_unt

Identifies the specific organizational unit, care setting, or clinical department associated with a survey record, such as an inpatient unit, outpatient clinic, or specialty practice. Used to attribute patient satisfaction scores and quality feedback to the appropriate unit for performance benchmarking.

PreviousPage 264 of 325Next