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,390 operations terms

appointment referenceappt_ref

A unique identifier or external cross-reference linking a scheduled visit to related records such as referrals, authorizations, or encounters across clinical and administrative systems, supporting care coordination and longitudinal patient record continuity.

appointment resolution dateappt_resol_dt

The date on which a scheduled appointment issue, cancellation dispute, or outstanding scheduling action was fully resolved, used in operational workflows to track scheduling problem management timelines and administrative follow-up completion rates.

appointment respirationappt_resp

The patient's respiratory rate recorded at or in association with a scheduled visit, captured as a vital sign in pre-visit or intake workflows within EHR systems to support clinical assessment, triage prioritization, and chronic disease monitoring.

appointment revisionappt_rev

A sequential version number tracking changes made to a scheduled visit record, such as time modifications, provider reassignments, or status updates, used in scheduling audit trails to maintain a complete history of appointment alterations over time.

appointment riskappt_rsk

A clinical or operational risk classification assigned to a scheduled visit, reflecting factors such as patient acuity, no-show likelihood, or care complexity, used in scheduling prioritization, care gap outreach, and proactive care management programs.

appointment scheduled dateappt_sched_dt

The confirmed calendar date on which a patient visit is planned to occur, recorded in scheduling and EHR systems as the primary temporal reference for clinical preparation, provider scheduling, and appointment utilization and access reporting.

appointment scheduled timeappt_sched_tm

The confirmed clock time at which a patient visit is planned to begin, used alongside the scheduled date in clinical workflows to manage provider calendars, patient notifications, and operational metrics such as wait time and scheduling density analysis.

appointment scoreappt_scr

A composite or algorithmic value assigned to a scheduled visit based on clinical, behavioral, or operational factors such as patient risk, visit complexity, or care gap priority, used to support scheduling decisions, outreach targeting, and quality reporting.

appointment sequenceappt_seq

A numeric ordering value indicating the relative position of a visit within a series of related appointments, such as follow-up care or treatment protocols, used in care plan management and scheduling systems to coordinate multi-visit clinical workflows.

appointment severityappt_sev

A classification of the clinical seriousness or urgency associated with the presenting condition at the time of scheduling, used to prioritize appointment slot allocation, inform triage decisions, and support acuity-based scheduling across care settings.

appointment sexappt_sex

The biological sex of the patient as recorded at the time of scheduling, used in demographic reporting, clinical screening protocol assignment, and population health analytics to ensure appropriate care delivery and identify sex-based disparities in access.

appointment sourceappt_src

The originating channel or system through which a scheduled visit was initiated, such as patient portal, referral, call center, or provider order, used in access analytics and scheduling operations to evaluate booking patterns and channel effectiveness.

appointment start dateappt_start_dt

The date marking the beginning of a scheduled visit or appointment episode, used in clinical and operational reporting to calculate visit duration, measure scheduling lead times, and establish the temporal anchor for encounter-related documentation and billing workflows.

appointment start timeappt_start_tm

The exact clock time a scheduled patient visit is set to begin, recorded in EHR scheduling systems. Used to manage provider calendars, calculate appointment duration, track patient flow, and measure on-time performance metrics across clinical operations.

appointment stateappt_st

The US state or Canadian province where a scheduled patient visit is set to occur. Captured in scheduling systems to support geographic reporting, multi-state compliance tracking, care coordination across regional networks, and provider licensure verification workflows.

appointment statusappt_sts

The current lifecycle stage of a scheduled patient visit, such as scheduled, confirmed, checked-in, completed, cancelled, or no-show. Drives clinical workflow routing, capacity planning, billing triggers, and population health outreach for missed or pending appointments.

appointment street addressappt_st_addr

The physical street address of the facility or location where a scheduled patient visit is set to take place. Used in scheduling systems to direct patients to the correct care site, support multi-location practice management, and enable geographic access analysis.

appointment subtotalappt_subtot

A partial financial amount associated with a scheduled patient visit, representing charges before taxes, adjustments, or additional fees are applied. Used in patient-facing cost estimates, pre-service financial counseling, and revenue cycle pre-authorization workflows.

appointment targetappt_tgt

The intended goal, outcome, or destination reference associated with a scheduled patient visit, such as a referral target provider, care plan objective, or clinical program enrollment. Used to link scheduling activity to broader care coordination and population health goals.

appointment taxonomy codeappt_tax_cd

The NUCC Health Care Provider Taxonomy code identifying the clinical specialty or provider type associated with a scheduled patient visit. Used to route appointments to appropriately credentialed clinicians, support referral matching, and enable specialty-level utilization reporting.

PreviousPage 21 of 320Next