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

anesthesiologist addressanes_addr

The full practice or facility address associated with the anesthesiologist responsible for perioperative care. Used in surgical records and claims processing to identify the physical location where the anesthesiologist renders services and to support credentialing and billing workflows.

anesthesiologist approval statusanes_appr_sts

The current credentialing or authorization state of an anesthesiologist within a facility or health system. Indicates whether the anesthesiologist has been approved to perform procedures, reflecting privileging decisions, license verification, or pre-procedure authorization review outcomes.

anesthesiologist charge amountanes_chrg_amt

The billed charge amount submitted by or attributed to the anesthesiologist for services rendered during a surgical or procedural encounter. Used in claims adjudication and revenue cycle management to capture the gross charge before payer-specific adjustments or contractual allowances.

anesthesiologist effective dateanes_eff_dt

The date on which an anesthesiologist's privileges, contract, or association with a facility became active. Used in credentialing systems and surgical scheduling to confirm that the clinician was authorized to provide anesthesia services during a specific care episode or date range.

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.

PreviousPage 16 of 325Next