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

appointment death dateappt_death_dt

The recorded date of a patient's death as it relates to a scheduled appointment record. Used in EHR systems to flag and inactivate future appointments for deceased patients, ensure accurate scheduling records, and support mortality tracking and care coordination workflows.

appointment deleted dateappt_del_dt

The calendar date on which a scheduled appointment record was removed or soft-deleted from the scheduling system. Used in EHR audit trails and data governance processes to track when appointments were cancelled and purged, supporting schedule integrity and historical reporting.

appointment deleted indicatorappt_del_ind

A boolean or coded flag that identifies whether a scheduled appointment record has been removed from the active scheduling system. Used in EHR data management to distinguish cancelled or purged appointments from active records, ensuring accurate utilization reporting and preventing deleted visits from appearing in operational workflows.

appointment descriptionappt_desc

A free-text or standardized narrative explaining the purpose or nature of a scheduled patient visit. Used in EHR scheduling systems to communicate the reason for the appointment to clinical staff, support triage decisions, and provide context for pre-visit preparation and resource allocation.

appointment detailappt_dtl

Supplementary clinical or administrative information associated with a specific scheduled patient visit. Captures additional context beyond the primary appointment record, such as special instructions, pre-visit requirements, or referral notes, used in EHR systems to support care coordination and clinical preparation.

appointment due dateappt_due_dt

The target date by which a patient is expected or recommended to complete a scheduled clinical visit. Used in EHR preventive care and chronic disease management workflows to track overdue appointments, trigger patient outreach, and monitor adherence to care plan timelines and clinical guidelines.

appointment effective dateappt_eff_dt

The date on which a scheduled appointment becomes active or valid within the scheduling system. Used in EHR platforms to manage appointment lifecycle, coordinate care timelines, and establish the start of a valid scheduling window for recurring or pre-authorized visits.

appointment emailappt_eml

The electronic mail address associated with a patient or responsible party for a scheduled clinical visit. Used in EHR scheduling systems to deliver appointment confirmations, reminders, and pre-visit instructions, supporting patient engagement and reducing no-show rates through automated communication workflows.

appointment end dateappt_end_dt

The calendar date on which a scheduled appointment or appointment series is set to conclude. Used in EHR systems to define the closing boundary of recurring visits, extended care episodes, or reservation windows, supporting accurate scheduling management and provider availability reporting.

appointment end timeappt_end_tm

The specific time at which a scheduled patient visit is expected to conclude. Used in EHR scheduling systems to allocate provider and facility resources, manage patient throughput, calculate appointment duration, and optimize scheduling efficiency across clinical departments and care settings.

appointment entered byappt_ent_by

The identifier of the user or system that created the scheduled appointment record in the EHR or scheduling platform. Used in audit trail and data governance processes to track scheduling accountability, support workflow analysis, and identify the source of appointment entries for quality and compliance reporting.

appointment ethnicityappt_ethn

The self-reported or recorded ethnic background of the patient associated with a scheduled clinical visit. Used in EHR systems to support health equity reporting, culturally competent care delivery, and population health analytics that identify and address disparities in appointment access and care utilization across demographic groups.

appointment expiration dateappt_exp_dt

The date after which a scheduled appointment authorization, referral, or reservation is no longer valid. Used in EHR and care management systems to ensure appointments are completed within approved timeframes, support referral management workflows, and prevent visits from occurring outside authorized scheduling windows.

appointment external identifierappt_ext_id

A unique reference identifier assigned to a scheduled appointment by an external system, such as a referring facility, health information exchange, or third-party scheduling platform. Used to maintain cross-system appointment traceability, support interoperability workflows, and reconcile scheduling records across disparate EHR environments.

appointment faxappt_fax

The facsimile number associated with a patient, provider, or facility linked to a scheduled clinical visit. Used in EHR scheduling systems to transmit appointment confirmations, referral documentation, and pre-visit clinical records to parties who require fax-based communication in care coordination workflows.

appointment feeappt_fee

The charge amount associated with a scheduled patient visit prior to or at the time of service. Used in EHR revenue cycle and scheduling systems to communicate expected patient cost responsibility, support co-pay collection workflows, and provide financial transparency during the appointment booking and registration process.

appointment first nameappt_first_nm

The given name of the patient or responsible party associated with a scheduled clinical visit. Used in EHR scheduling and registration systems to identify and address patients during appointment confirmation, check-in workflows, and clinical communications, supporting accurate patient matching and identity verification processes.

appointment flagappt_flg

A binary indicator denoting the current status or condition of a scheduled patient visit, such as whether the appointment requires special handling, has been flagged for follow-up, or meets a specific clinical or administrative criterion within the scheduling system.

appointment full nameappt_full_nm

The complete concatenated name of the patient associated with a scheduled visit, combining first, middle, and last name components. Used in scheduling interfaces and clinical workflows to display the patient's identity in a fully human-readable format for staff verification and record matching.

appointment genderappt_gndr

The patient's sex or gender identity recorded at the time of scheduling a clinical visit. Used to support appropriate clinical care planning, resource assignment, and demographic reporting tied to the scheduled encounter in EHR and scheduling systems.

PreviousPage 18 of 325Next