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 cancelled dateappt_cncl_dt

The date on which a previously scheduled patient appointment was formally cancelled by the patient, provider, or scheduling staff. Used to analyze cancellation patterns, manage scheduling capacity, and support no-show and access reporting in clinical operations.

appointment categoryappt_cat

A classification label that groups scheduled patient visits by visit type, clinical service line, or care purpose, such as preventive, follow-up, or urgent care. Used to organize scheduling workflows, allocate resources, and support operational and clinical analytics.

appointment charge amountappt_chrg_amt

The gross billed charge associated with services rendered during a scheduled patient visit, recorded before adjustments, insurance payments, or contractual write-offs. Used in revenue cycle management to support financial reconciliation, billing workflows, and appointment-level cost reporting.

appointment chief complaintappt_cc

The primary symptom, concern, or reason for care as stated by the patient at the time of scheduling or intake for a visit. Used to guide clinical preparation, triage prioritization, and care team workflows, and to support visit-level clinical documentation in EHR systems.

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.

PreviousPage 17 of 325Next