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

anesthesiologist group numberanes_grp_nbr

The insurance group or practice group identifier associated with the anesthesiologist for billing and claims purposes. Links the individual provider to an anesthesiology practice group, enabling accurate claim submission, remittance matching, and group-level reimbursement tracking.

anesthesiologist medical record numberanes_mrn

The medical record number assigned to a patient encounter in which the identified anesthesiologist provided services. Links the anesthesia care record to the patient's broader clinical history, supporting documentation of perioperative care within the facility's health record system.

anesthesiologist scheduled dateanes_sched_dt

The calendar date on which an anesthesiologist is scheduled to provide services for a surgical or procedural case. Used in operating room scheduling and perioperative workflow management to coordinate anesthesia staffing and ensure appropriate coverage for planned procedures.

anesthesiologist scheduled timeanes_sched_tm

The specific time of day at which an anesthesiologist is assigned to begin services for a scheduled surgical or procedural case. Supports perioperative scheduling workflows and operating room coordination by capturing the planned start time for anesthesia service delivery.

anesthesiologist street addressanes_st_addr

The street-level address of the anesthesiologist's primary practice location or the facility where services are rendered. Used in provider directory maintenance, claims processing, and credentialing records to support accurate identification and correspondence with the anesthesia provider.

anesthesiologist unitanes_unt

The hospital unit or clinical area where an anesthesiologist is assigned or where anesthesia services are delivered, such as an operating room suite or ICU. Used in perioperative documentation and staffing records to associate the anesthesiologist with a specific care location during an encounter.

appointment addressappt_addr

The physical location address where a scheduled patient appointment is to take place. Captures the facility, clinic, or provider office address associated with a care visit, used in patient scheduling systems to communicate visit location details and support care coordination workflows.

appointment ageappt_age

The patient's calculated age at the time of a scheduled appointment. Derived from date of birth and the appointment date, this value supports age-specific clinical decision rules, eligibility checks for age-dependent services, and demographic reporting within scheduling and clinical systems.

appointment allowed amountappt_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered during a scheduled appointment, based on the negotiated fee schedule or plan benefit structure. Used in pre-service financial counseling, cost estimation workflows, and post-visit claims reconciliation processes.

appointment amountappt_amt

The monetary value associated with a scheduled appointment, representing the estimated or actual cost of the visit. Used in patient scheduling, financial counseling, and revenue cycle workflows to communicate expected charges prior to service or to record the total billed amount for the encounter.

appointment approval statusappt_appr_sts

The current authorization or approval state of a scheduled patient appointment, indicating whether the visit has been confirmed, pending review, or denied. Used in referral management and prior authorization workflows to track whether required approvals have been obtained before the appointment occurs.

appointment approved byappt_appr_by

The identifier of the clinician, staff member, or system user who authorized or confirmed a scheduled patient appointment. Used in scheduling workflows and referral management to maintain an audit trail of who granted approval, supporting accountability and compliance with authorization requirements.

appointment arrival timeappt_arrv_tm

The actual clock time at which a patient arrived for a scheduled appointment. Captured at check-in to measure punctuality, calculate wait times, and support operational reporting on patient flow and scheduling efficiency within clinic and ambulatory care settings.

appointment arrived dateappt_arrv_dt

The date a patient physically checked in or arrived at the care site for a scheduled appointment. Used in EHR scheduling workflows to calculate wait times, measure punctuality, and support operational reporting on patient flow and throughput.

appointment birth dateappt_birth_dt

The patient's date of birth as recorded at the time of appointment scheduling or check-in. Used to verify patient identity, confirm age-appropriate care protocols, and support demographic reporting within EHR scheduling and registration systems.

appointment blood pressureappt_bp

The systolic and diastolic arterial pressure reading captured during a scheduled patient visit, typically recorded as mmHg at check-in or during triage. Used to track cardiovascular health trends and inform clinical decision-making within EHR vital signs workflows.

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.

PreviousPage 16 of 320Next