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

schedule last namesched_last_nm

The patient's or contact person's family surname recorded on a scheduling record. Used to identify and match individuals to appointments in scheduling and EHR systems, supporting patient lookup, confirmation workflows, and demographic verification at time of service.

schedule legal namesched_legal_nm

The patient's full legal name as recorded on a scheduling record, used for identity verification, insurance eligibility checks, and regulatory compliance. Ensures alignment between scheduling data and official identification documents presented at the time of the clinical encounter.

schedule levelsched_lvl

A value indicating the hierarchical tier or classification of a scheduling record, such as department, unit, or resource level within a scheduling template hierarchy. Used to organize and manage scheduling configurations across facilities, departments, and individual provider calendars.

schedule license numbersched_lic_nbr

The professional license number of the clinician or resource associated with a scheduled appointment or service. Used to validate that scheduled providers hold required credentials for the planned procedure or care type, supporting compliance and credentialing verification workflows.

schedule marital statussched_mar_sts

The marital status of the patient recorded at the time of scheduling. Captured as a demographic attribute to support insurance coordination of benefits determination, eligibility verification, and social history documentation associated with the scheduled clinical encounter.

schedule master identifiersched_mstr_id

The enterprise master patient or record identifier linked to a scheduling entry, used to reconcile scheduling records with a master patient index across multiple facilities or systems. Supports accurate patient matching and longitudinal record continuity in enterprise scheduling environments.

schedule maximumsched_max

The upper limit value defined within a scheduling context, such as the maximum number of appointments allowed in a time slot, the maximum patient capacity for a scheduling template, or the maximum allowable value for a clinically relevant scheduling parameter or threshold.

schedule medical record numbersched_mrn

The patient's medical record number captured on a scheduling record, used to link the appointment to the patient's clinical record in the EHR. Ensures accurate association between scheduled encounters and existing patient history, orders, and documentation in the clinical system.

schedule middle namesched_mid_nm

The patient's middle name or initial recorded on a scheduling entry. Used alongside first and last name for identity verification, duplicate record prevention, and accurate patient matching during appointment registration and check-in workflows in scheduling and EHR systems.

schedule minimumsched_min

The lower limit value defined within a scheduling context, such as the minimum notice required to book an appointment, the minimum staffing level required for a schedule template, or a minimum clinical threshold that must be met before a scheduled procedure can be confirmed.

schedule mobilesched_mob

The mobile phone number of the patient or contact person associated with a scheduled appointment. Used in scheduling systems to send appointment reminders, cancellation notifications, and pre-visit instructions via SMS or automated outreach to reduce no-show rates.

schedule modified bysched_mod_by

The identifier of the user or system process that last updated a scheduling record. Used in audit trail and data governance workflows to track changes to appointment details, slot availability, or scheduling configurations, supporting accountability and compliance in scheduling systems.

schedule modified datesched_mod_dt

The calendar date when a scheduling record was last updated or changed in the healthcare scheduling system. Tracks audit history for appointment templates, resource availability blocks, or recurring schedule configurations to support change management and compliance reporting.

schedule modified timesched_mod_tm

The timestamp indicating when a scheduling record was last altered in the healthcare scheduling system. Used alongside the modified date to provide precise audit trail details for appointment templates, staff availability configurations, or recurring schedule pattern changes.

schedule namesched_nm

The human-readable label assigned to a scheduling template or resource availability plan in the healthcare scheduling system. Used to identify appointment blocks, provider availability templates, or departmental scheduling configurations across clinical operations and scheduling workflows.

schedule notesched_nt

Free-text annotation attached to a scheduling record to capture special instructions, exceptions, or contextual details about an appointment block or resource availability window. Used by scheduling staff to communicate relevant operational details that affect how a schedule is managed or interpreted.

schedule numbersched_nbr

A unique numeric or alphanumeric identifier assigned to a specific scheduling template or resource availability plan. Used to reference and track scheduling configurations across healthcare information systems, ensuring consistent identification during reporting, audits, and cross-system scheduling integrations.

schedule onset datesched_onset_dt

The calendar date when a scheduling template, resource availability plan, or recurring appointment block becomes active and begins governing time slot allocation. Used in healthcare scheduling systems to manage the effective start of new scheduling configurations or staff availability windows.

schedule oxygen saturationsched_o2sat

The blood oxygen saturation level recorded at the time of a scheduled clinical encounter or pre-procedure assessment. Captured within scheduling workflows to document baseline vital sign measurements that inform care preparation, clinical triage prioritization, or procedural readiness evaluations.

schedule paid amountsched_pd_amt

The monetary value remitted as payment for services rendered during a scheduled healthcare encounter. Recorded in scheduling or billing systems to reconcile expected reimbursement against actual payments received, supporting revenue cycle management and financial reporting tied to appointment activity.

PreviousPage 222 of 325Next