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 childappt_chld

An indicator or reference identifying a subordinate appointment linked to a parent scheduling record, such as a follow-up or ancillary service tied to a primary visit. Used to manage hierarchical appointment relationships within EHR scheduling systems and care coordination workflows.

appointment cityappt_city

The name of the city where the scheduled patient appointment is to take place, associated with the care site or facility address. Used to support location-based scheduling, patient travel logistics, and geographic reporting in healthcare operations and access analytics.

appointment classappt_cls

A tiered classification that categorizes a scheduled visit by care setting or visit type, such as outpatient, inpatient, telehealth, or emergency. Used to drive scheduling rules, resource allocation, billing workflows, and clinical reporting across healthcare information systems.

appointment codeappt_cd

A standardized alphanumeric identifier assigned to a specific appointment type or visit category within a scheduling system. Used to uniquely reference, route, and track appointments across EHR, billing, and operational platforms while enabling consistent reporting and workflow automation.

appointment commentappt_cmt

A free-text field capturing supplemental notes or instructions associated with a scheduled patient visit, entered by scheduling staff, clinicians, or patients. Used to communicate special requirements, patient preferences, or clinical context that supports care preparation and coordination workflows.

appointment completed dateappt_cmpl_dt

The date on which a scheduled patient appointment was fully concluded and all associated clinical activities were finalized. Used to confirm visit closure, trigger downstream billing and documentation workflows, and support scheduling performance and care completion reporting.

appointment confidential indicatorappt_conf_ind

A flag designating that a scheduled patient visit contains sensitive or restricted information requiring heightened privacy protections, such as visits related to behavioral health or reproductive services. Used to enforce access controls and comply with federal and state confidentiality regulations in EHR systems.

appointment countappt_cnt

A numeric value representing the total number of scheduled patient visits within a defined period, patient cohort, or reporting dimension. Used in clinical operations, capacity planning, and population health analytics to measure utilization, care access, and scheduling demand across healthcare settings.

appointment countryappt_ctry

The name or code of the country where the scheduled patient appointment is located, associated with the care site's address. Used to support international care coordination, compliance with country-specific regulations, and geographic stratification in healthcare operations and reporting.

appointment created byappt_crtd_by

The username or system identifier of the individual or automated process that originally created the appointment record in the scheduling system. Used for audit trail purposes, accountability tracking, and operational reporting on scheduling activity within EHR and healthcare information systems.

appointment created dateappt_crtd_dt

The calendar date on which the appointment record was first entered into the scheduling system, regardless of the scheduled visit date. Used to measure scheduling lead time, analyze booking patterns, and support operational and access reporting within EHR and healthcare scheduling platforms.

appointment created timeappt_crtd_tm

The timestamp indicating the precise time of day at which the appointment record was initially created in the scheduling system. Used alongside the created date to support detailed audit logging, scheduling workflow analysis, and capacity management reporting in healthcare operations.

appointment creatinineappt_cr

The serum or urine creatinine value recorded during a scheduled patient visit, used as a key biomarker for assessing renal function and kidney disease progression. Captured in EHR clinical documentation to inform medication dosing decisions, monitor chronic kidney disease, and support lab trend reporting.

appointment dateappt_dt

The calendar date on which a patient's scheduled clinical visit is set to occur. Used in EHR scheduling systems to coordinate care, track utilization patterns, measure no-show rates, and support population health reporting across ambulatory and inpatient settings.

appointment datetimeappt_dttm

The precise date and time at which a patient's scheduled clinical visit is set to begin. Combines date and time into a single timestamp used in EHR scheduling workflows to manage provider calendars, reduce scheduling conflicts, and support operational reporting on appointment utilization.

appointment dea numberappt_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician linked to a scheduled visit. Used in EHR systems to identify controlled substance prescribing authority and ensure regulatory compliance when appointments involve evaluation or management of controlled substance prescriptions.

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.

PreviousPage 17 of 320Next