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 ethnicitysched_ethn

The self-reported ethnicity of the patient associated with a scheduled appointment, captured at time of booking. Used to support health equity reporting, demographic analysis of appointment access patterns, and compliance with federal and state healthcare disparity monitoring requirements.

schedule expiration datesched_exp_dt

The date after which a scheduling authorization, referral-based appointment order, or scheduling template is no longer valid for booking. Used in scheduling workflows to enforce authorization time limits and ensure appointments are completed within clinically or administratively approved timeframes.

schedule external identifiersched_ext_id

A unique reference identifier assigned to a scheduled appointment or scheduling record by an external system, such as a health information exchange, referring facility, or third-party scheduling platform. Used to correlate and reconcile scheduling records across disparate healthcare information systems.

schedule faxsched_fax

The facsimile number associated with a scheduling resource, department, or patient record used to transmit appointment confirmations, referral documents, or pre-visit instructions. Supports communication workflows in clinical scheduling environments where electronic fax remains a standard exchange method.

schedule feesched_fee

The charge amount associated with a scheduled appointment or clinical service at the time of booking. Used in patient scheduling and revenue cycle systems to provide cost estimates, support pre-service financial counseling, and align scheduling data with billing and claims processing workflows.

schedule first namesched_first_nm

The given name of the patient or contact person associated with a scheduled appointment. Used in scheduling systems to personalize appointment communications, verify patient identity at check-in, and match scheduling records to the correct member or patient demographic profile.

schedule flagsched_flg

A binary or coded indicator applied to a scheduled appointment to denote a specific condition or status, such as held, confirmed, waitlisted, or requiring special accommodation. Used in scheduling workflows to filter, prioritize, and route appointments through clinical and administrative processing steps.

schedule frequencysched_freq

The recurrence interval at which a scheduled appointment or clinical activity repeats, such as daily, weekly, or monthly. Used in care management and chronic disease scheduling workflows to define recurring visit patterns for ongoing treatment, monitoring programs, and preventive care protocols.

schedule full namesched_full_nm

The complete name of the patient, provider, or scheduling resource associated with an appointment record. Used in scheduling systems for display, search, and patient identity verification purposes, ensuring accurate matching of appointment records to demographic and clinical data.

schedule gendersched_gndr

The gender of the patient associated with a scheduled appointment, captured during booking to support appropriate clinical resource assignment and care delivery. Used in scheduling analytics to monitor demographic access patterns and ensure equitable appointment availability across patient populations.

schedule glucosesched_gluc

The blood glucose value recorded or required in association with a scheduled clinical appointment, such as a pre-procedure lab result or chronic disease monitoring visit. Used in scheduling workflows for diabetes management programs to track patient-reported or lab-confirmed glucose levels tied to appointment dates.

schedule group numbersched_grp_nbr

The insurance group number associated with the patient at the time of appointment scheduling. Used to verify coverage eligibility, route pre-authorizations, and link scheduling records to the correct insurance plan for billing and claims adjudication following the scheduled encounter.

schedule hemoglobinsched_hgb

The hemoglobin lab value recorded in association with a scheduled clinical appointment or procedure. Used in pre-operative or chronic disease management workflows to track whether a patient meets clinical thresholds required before a scheduled intervention can proceed.

schedule history present illnesssched_hpi

The history of present illness narrative documented at the time of a scheduled clinical encounter. Captures the patient's chief complaint, symptom progression, and clinical context to support care coordination and preparation for the upcoming scheduled visit or procedure.

schedule identifiersched_id

The unique system-generated or assigned identifier for a specific scheduling record within an appointment or resource management system. Used to link patient appointments, provider availability, and facility resources across EHR, scheduling, and clinical data warehouse systems.

schedule indexsched_idx

A numeric position or sequence value assigned to a scheduling record within an ordered dataset or scheduling queue. Used to maintain ordering logic for appointment slots, recurring schedule templates, or prioritized scheduling queues in clinical operations systems.

schedule indicatorsched_ind

A flag or boolean value denoting a specific state or condition of a scheduling record, such as whether an appointment slot is active, blocked, or requires special handling. Used in scheduling systems to control availability, trigger workflows, or filter appointment records.

schedule instructionsched_instr

Free-text or coded guidance associated with a scheduled appointment or procedure, such as patient preparation requirements, fasting instructions, or staff setup directions. Used in clinical scheduling systems to communicate pre-visit or procedural requirements to patients and care teams.

schedule keysched_key

A surrogate or natural key value used to uniquely reference a scheduling record within a relational database or data warehouse. Supports joins between scheduling tables and related clinical, patient, or resource records in healthcare information systems and analytics environments.

schedule languagesched_lang

The preferred spoken or written language of the patient associated with a scheduled appointment. Used in scheduling systems to coordinate interpreter services, prepare translated materials, and ensure communication accessibility requirements are met prior to the clinical encounter.

PreviousPage 221 of 325Next