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 glucoseappt_gluc

The blood glucose measurement recorded in association with a scheduled patient visit, typically captured during check-in or pre-visit screening. Used to support clinical decision-making for patients managing diabetes or other metabolic conditions requiring glucose monitoring at each encounter.

appointment group numberappt_grp_nbr

The insurance group number associated with the patient's health plan coverage at the time of scheduling. Used to verify eligibility, route billing, and link the scheduled visit to the correct payer group for claims processing and prior authorization workflows.

appointment hemoglobinappt_hgb

The hemoglobin level recorded in association with a scheduled patient visit, typically captured during pre-visit labs or point-of-care testing. Used to inform clinical decisions for patients with anemia, chronic kidney disease, or other conditions requiring hemoglobin monitoring at each encounter.

appointment identifierappt_id

The unique alphanumeric key assigned to a specific scheduled patient visit within the scheduling or EHR system. Used to track, reference, and link the appointment record across clinical, billing, and operational workflows throughout the patient visit lifecycle.

appointment indexappt_idx

A sequential or positional number assigned to a scheduled patient visit, used to order or rank appointments within a series, provider schedule, or patient encounter history. Supports sorting and retrieval of appointment records in scheduling and clinical data systems.

appointment indicatorappt_ind

A coded value or boolean field that signals a specific condition or characteristic of a scheduled patient visit, such as whether it is a new patient visit, a telehealth encounter, or requires interpreter services. Used to drive workflow routing and reporting in scheduling systems.

appointment keyappt_key

A surrogate or natural key used to uniquely identify and join appointment records across clinical and operational data systems. Serves as the primary lookup reference linking scheduling data to related encounter, billing, and clinical documentation tables in the data warehouse.

appointment languageappt_lang

The preferred spoken or written language of the patient associated with a scheduled visit. Used to arrange interpreter services, prepare language-appropriate materials, and ensure effective communication during the clinical encounter, supporting health equity and compliance requirements.

appointment last nameappt_last_nm

The patient's family surname recorded at the time of scheduling a clinical visit. Used for patient identification, record matching, and display in scheduling interfaces, and combined with other name fields to confirm patient identity during check-in and clinical workflows.

appointment lead time daysappt_lead_time_days

The number of calendar days between when a patient requested or was referred for an appointment and the date the appointment was scheduled, a key access-to-care metric used to measure scheduling efficiency and compliance with regulatory and accreditation standards requiring timely access to primary and specialty care services.

appointment legal nameappt_legal_nm

The patient's official government-registered name associated with a scheduled clinical visit. Used to ensure identity verification aligns with insurance records, legal documents, and payer eligibility data, particularly important for claims processing and compliance with identification requirements.

appointment levelappt_lvl

A hierarchical classification assigned to a scheduled patient visit, indicating its position within a care program, visit series, or organizational structure. Used to distinguish between initial, follow-up, or escalated appointments and to support tiered scheduling and reporting workflows.

appointment license numberappt_lic_nbr

The professional license number of the clinician or provider assigned to a scheduled patient visit. Used to verify credentialing compliance, support claims submission with accurate rendering provider information, and maintain regulatory documentation tied to the clinical encounter.

appointment marital statusappt_mar_sts

The patient's marital or domestic relationship status recorded at the time of scheduling. Used for demographic reporting, insurance coordination of benefits determinations, and social history documentation associated with the scheduled clinical encounter in EHR and scheduling systems.

appointment master identifierappt_mstr_id

The enterprise-level master patient or appointment identifier that uniquely links a scheduled visit to the organization's master person index. Used to reconcile appointment records across multiple facilities, EHR instances, or health system mergers to ensure accurate patient identity matching.

appointment maximumappt_max

The upper limit value associated with a scheduled patient visit, such as the maximum number of appointments allowed in a scheduling slot, the maximum patient capacity for a clinic session, or an upper bound on a clinical measurement captured at the time of scheduling.

appointment medical record numberappt_mrn

The facility-assigned medical record number of the patient associated with a scheduled visit. Used to link the appointment to the patient's longitudinal clinical record, enabling retrieval of prior encounter history, clinical documentation, and care plans relevant to the upcoming visit.

appointment middle nameappt_mid_nm

The patient's middle name or initial recorded at the time of scheduling a clinical visit. Used alongside first and last name fields to improve patient identity matching accuracy, reduce duplicate records, and support full legal name display in scheduling and registration workflows.

appointment minimumappt_min

The lower threshold value associated with a scheduled patient care visit, used to enforce business rules such as minimum booking duration, minimum patient age, or minimum lead time required when scheduling appointments in clinical workflow systems.

appointment mobileappt_mob

The mobile phone number associated with a patient or contact person linked to a scheduled care visit. Used in scheduling systems to send SMS reminders, appointment confirmations, and cancellation alerts to reduce no-show rates and improve patient communication.

PreviousPage 19 of 325Next