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

The calendar date on which a scheduling record was first entered into the appointment management system. Used to track booking lead time, measure scheduling workflow efficiency, and support audit trails that distinguish when an appointment was created versus when it is scheduled to occur.

schedule created timesched_crtd_tm

The specific time of day at which a scheduling record was first created in the appointment management system, typically stored in conjunction with the created date. Used in audit logging, workflow analysis, and operational reporting to provide precise timestamps for scheduling activity tracking.

schedule creatininesched_cr

The recorded serum or urine creatinine laboratory value associated with a patient at the time of scheduling, used to assess kidney function prior to procedures, contrast administration, or medication dosing. Captured in scheduling workflows to support clinical decision-making and pre-procedure safety screening.

schedule datesched_dt

The specific calendar date on which an appointment, procedure, or service is planned to occur. A foundational element in scheduling systems used to coordinate patient access, provider availability, and resource allocation, and to support downstream reporting of care delivery timelines.

schedule datetimesched_dttm

The combined date and time value representing the precise moment an appointment or scheduled service is set to begin. Used in scheduling and clinical systems to coordinate patient arrivals, provider calendars, and facility resources while supporting accurate reporting of appointment adherence and wait times.

schedule dea numbersched_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing provider linked to a scheduled encounter, particularly relevant for appointments involving controlled substance prescriptions. Used to verify prescriber authorization and support regulatory compliance tracking in scheduling and pharmacy systems.

schedule death datesched_death_dt

The recorded date of death for a patient associated with a scheduling record, used to flag and close open or future appointments following patient mortality. Applied in scheduling and patient management systems to prevent erroneous outreach, update care plans, and maintain accurate patient status for reporting.

schedule deductible amountsched_ded_amt

The dollar amount applied toward a patient's annual insurance deductible that is associated with a scheduled appointment or service. Used in patient access and scheduling systems to inform pre-visit financial counseling, estimate patient out-of-pocket liability, and support eligibility verification workflows.

schedule deleted datesched_del_dt

The date on which a scheduling record was marked as deleted or removed from active scheduling workflows. Used in audit tracking and data governance processes to maintain a complete history of scheduling activity, including cancellations and administrative removals, without permanently purging the underlying record.

schedule deleted indicatorsched_del_ind

A flag indicating whether a scheduling record has been logically deleted or removed from active use within the scheduling system. Enables soft-delete functionality so that historical appointment data is preserved for audit, reporting, and data reconciliation purposes while excluding the record from operational scheduling views.

schedule descriptionsched_desc

A human-readable text field providing a descriptive label or narrative explanation of the scheduled appointment type, service, or event. Used in scheduling systems to communicate the nature of the visit to patients and staff, populate patient notifications, and support reporting and categorization of appointment activity.

schedule detailsched_dtl

Granular information associated with a specific scheduled appointment or service, capturing supplementary attributes such as preparation instructions, equipment requirements, authorization details, or clinical context. Used in scheduling systems to ensure care teams and patients have complete information needed for successful appointment execution.

schedule due datesched_due_dt

The deadline date by which a scheduled appointment, procedure, or clinical activity must occur. Used in care management and patient scheduling systems to trigger follow-up workflows, track overdue appointments, and support compliance with care plan timelines.

schedule durationsched_dur

The total elapsed time allocated for a scheduled appointment or clinical activity, typically expressed in minutes. Used in patient scheduling systems to manage resource availability, prevent appointment overlap, and optimize clinical staff and facility utilization.

schedule effective datesched_eff_dt

The date on which a scheduling template, appointment slot configuration, or recurring schedule becomes active. Used in facility and provider scheduling systems to manage transitions between scheduling periods and control when new availability windows open for patient booking.

schedule emailsched_eml

The electronic mail address associated with a scheduled appointment or scheduling resource, used to send automated appointment confirmations, reminders, and cancellation notices. Supports patient engagement workflows and reduces no-show rates through proactive communication.

schedule emergency indicatorsched_emerg_ind

A flag indicating whether a scheduled appointment or procedure was created or classified as an emergency, requiring expedited handling or prioritized resource allocation. Used in patient scheduling and triage workflows to distinguish routine bookings from urgent clinical interventions.

schedule end datesched_end_dt

The date on which a scheduled appointment, recurring schedule series, or scheduling template becomes inactive or concludes. Used in clinical scheduling systems to define the boundary of a scheduling period and support accurate reporting of appointment timelines and resource availability.

schedule end timesched_end_tm

The clock time at which a scheduled appointment or clinical activity is expected to conclude. Used in patient scheduling systems alongside start time to calculate appointment duration, manage sequential bookings, and prevent conflicts in provider or facility resource allocation.

schedule entered bysched_ent_by

The username or identifier of the staff member who created or entered the scheduled appointment into the scheduling system. Used for audit trail purposes, accountability tracking, and operational reporting on scheduling activity across clinical and administrative workflows.

PreviousPage 220 of 325Next