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

address urgencyaddr_urg

A flag or classification indicating the priority level associated with processing or updating an address record. Used in member enrollment and care management workflows to prioritize address corrections that may affect timely delivery of clinical correspondence, benefits materials, or urgent notifications.

address valueaddr_val

The actual address data stored for a member, patient, or entity, representing the specific text or structured field content of the location record. Used in member enrollment, claims, and care coordination systems to populate mailing, billing, and service delivery address fields.

address versionaddr_ver

A numeric or alphanumeric indicator identifying which iteration of an address record is current or historical within the healthcare data system. Used in member enrollment and patient demographic management to track changes over time and support point-in-time address lookups for claims and audits.

address zipaddr_zip

The five or nine digit U.S. postal code associated with a member, patient, or facility address. Used across member enrollment, claims adjudication, and network management to determine geographic eligibility, route claims, assign service areas, and support population health analytics.

adjustment scheduled dateadj_sched_dt

The planned calendar date on which a claims or billing adjustment is scheduled to be processed. Used in claims adjudication and financial reconciliation workflows to coordinate timing of payment modifications, reversals, or reprocessing activities between payers and providers.

adjustment scheduled timeadj_sched_tm

The specific time of day at which a claims or billing adjustment is planned to be executed within the payment processing system. Used in claims adjudication and financial operations to coordinate batch processing windows for adjustments, reversals, or payment corrections.

adjustment unitadj_unt

The standard unit of measure associated with a financial modification, such as days, visits, or drug quantity dispensed. Used in EHR billing systems, PBM adjudication platforms, and claims processing engines to quantify the scope of an adjustment and ensure accurate per-unit reimbursement calculations in line with contracted fee schedules.

advance directive addressadvdir_addr

The physical mailing or residential address associated with an advance directive document or its designated contact. Used in clinical and legal documentation workflows to identify where the directive is stored, where the healthcare proxy resides, or where formal notifications should be sent.

advance directive approval statusadvdir_appr_sts

The current authorization or validation state of a patient's advance directive, indicating whether the document has been reviewed, accepted, pending, or rejected. Used in clinical documentation systems to confirm a legally valid directive is on file before care decisions are made.

advance directive charge amountadvdir_chrg_amt

The monetary value associated with processing, notarizing, or administering an advance directive on behalf of a patient. Used in healthcare billing and administrative cost tracking to capture fees related to document preparation, legal review, or related patient services.

advance directive effective dateadvdir_eff_dt

The calendar date on which a patient's advance directive becomes legally valid and clinically enforceable. Used in clinical documentation and care management systems to ensure that patient wishes regarding end-of-life treatment decisions are honored within the correct active period.

advance directive medical record numberadvdir_mrn

The unique patient identifier assigned by a healthcare facility that links an advance directive document to the corresponding medical record. Used in clinical documentation systems to associate end-of-life care instructions with the correct patient across inpatient, outpatient, and longitudinal care settings.

advance directive scheduled dateadvdir_sched_dt

The planned date on which a patient's advance directive is scheduled to be completed, reviewed, or formally executed. Used in care management and clinical documentation workflows to track upcoming directive appointments and ensure timely completion before elective procedures or care transitions.

advance directive scheduled timeadvdir_sched_tm

The specific time of day recorded for a planned advance directive consultation or review appointment. Captures the clock time component used alongside a scheduled date to coordinate end-of-life care planning discussions between patients, families, and clinical staff.

advance directive street addressadvdir_st_addr

The physical street address where an advance directive document was executed, stored, or associated with a care planning event. Used to locate the facility or residence linked to a patient's documented end-of-life care wishes and legal directives.

advance directive unitadvdir_unt

The specific hospital unit, ward, or care setting associated with an advance directive record. Identifies the inpatient or outpatient location where end-of-life care instructions were documented, reviewed, or are intended to be applied during a patient's care episode.

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.

PreviousPage 15 of 320Next