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 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 status codeappt_sts_cd

A code identifying the current status of a scheduled patient appointment, such as scheduled, confirmed, checked in, completed, cancelled, no-show, or rescheduled. Appointment status codes are used in scheduling analytics to calculate no-show rates, measure provider utilization, and identify patterns of appointment abandonment that affect revenue cycle performance and patient access metrics.

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.

appointment temperatureappt_temp

The patient body temperature reading recorded in association with a scheduled care visit, typically captured at check-in or during triage. Used in clinical documentation, pre-visit screening workflows, infection control monitoring, and vital signs trending within EHR systems.

appointment termination dateappt_term_dt

The date on which a scheduled patient visit record was formally ended, cancelled, or closed in the scheduling system. Used to track appointment lifecycle, calculate no-show lag times, support audit reporting, and manage care gap identification for unresolved visits.

appointment timeappt_tm

The scheduled clock time of a patient visit as recorded in the EHR or practice management system. Used for provider schedule management, patient notification and reminder workflows, wait time analysis, and operational reporting on appointment distribution throughout the care day.

appointment timestampappt_ts

The combined date and time value marking a specific event in the appointment lifecycle, such as when it was created, modified, or completed. Used for audit trails, scheduling system synchronization, workflow trigger sequencing, and longitudinal visit history reconstruction.

appointment titleappt_ttl

The descriptive label or name assigned to a scheduled patient visit in the EHR or scheduling system, such as Annual Wellness Visit or Follow-Up Consultation. Used to communicate visit purpose to patients and staff, support schedule display, and enable visit-type reporting.

appointment totalappt_tot

The complete financial amount associated with a scheduled patient visit after all charges, fees, and adjustments are applied. Used in pre-service cost estimation, patient financial responsibility calculation, revenue cycle forecasting, and episodic cost analysis across visit types.

appointment total countappt_tot_cnt

The aggregate number of scheduled patient visits meeting specified criteria within a defined period or population. Used in capacity planning, provider productivity measurement, no-show rate calculation, access reporting, and population health program engagement tracking.

appointment typeappt_typ

The classification category assigned to a scheduled patient visit, such as new patient, follow-up, preventive, telehealth, or urgent care. Drives scheduling rules, slot duration assignment, billing code selection, resource allocation, and utilization reporting across care settings.

appointment unitappt_unt

The discrete unit of measure associated with a scheduled patient visit, such as the clinical department, care unit, billing unit, or time block increment. Used in scheduling configuration, provider workload distribution, operational reporting, and facility-level capacity management.

appointment updated dateappt_upd_dt

The most recent date on which a scheduled patient visit record was modified in the EHR or scheduling system, including changes to time, provider, location, or status. Used for audit logging, change history tracking, scheduling system reconciliation, and data governance compliance.

appointment urgencyappt_urg

The clinical priority level assigned to a scheduled patient visit indicating how quickly the patient needs to be seen, such as routine, urgent, or emergent. Used to triage scheduling queues, ensure timely access for high-acuity patients, and support access-to-care performance measurement.

appointment versionappt_ver

The sequential version number of a scheduled patient visit record, incremented each time the appointment is modified in the scheduling system. Supports optimistic concurrency control, change history auditing, system integration conflict resolution, and data lineage tracking across EHR platforms.

appointment zipappt_zip

The five or nine-digit postal code for the location where a scheduled patient visit is set to occur. Used to identify care site geography, analyze patient travel burden, support network adequacy reporting, and enable social determinants of health assessments tied to visit location.

PreviousPage 22 of 325Next