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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

availability noteavail_nt

Free-text annotation associated with an open appointment or scheduling availability record, capturing special instructions, restrictions, or contextual details relevant to the scheduling window within clinical workflow management systems.

availability numberavail_nbr

The unique numeric reference identifier assigned to an open appointment or scheduling availability record, used to track and cross-reference specific availability windows across scheduling platforms and clinical workflow management systems.

availability onset dateavail_onset_dt

The date on which an open appointment or scheduling availability window becomes active or first takes effect, marking the start of a defined schedulable period within clinical workflow and appointment management systems.

availability oxygen saturationavail_o2sat

The recorded peripheral oxygen saturation measurement linked to an availability or scheduling context, typically capturing a clinical threshold or prerequisite vital sign required before scheduling specific procedures or clinical appointments.

availability paid amountavail_pd_amt

The monetary value paid in association with an open appointment or scheduling availability record, capturing financial transactions such as booking fees or deposits linked to specific schedulable time blocks in healthcare systems.

availability paid dateavail_pd_dt

The date on which a payment was processed in association with an open appointment or scheduling availability record, supporting financial reconciliation and tracking of booking-related transactions within healthcare scheduling systems.

availability parentavail_prnt

The reference to a higher-level availability record from which a subordinate open appointment slot or scheduling window is derived, establishing hierarchical relationships within scheduling templates and clinical workflow management systems.

availability percentageavail_pct

The proportional ratio representing the degree of open appointment capacity or scheduling availability relative to total possible slots, used to monitor utilization rates and capacity planning within healthcare scheduling systems.

availability periodavail_prd

The defined duration or recurring time interval during which appointment slots or scheduling windows are considered open and bookable, used to configure scheduling templates and manage capacity in clinical workflow systems.

availability phoneavail_ph

The primary telephone contact number associated with an open appointment or scheduling availability record, used to facilitate communication with patients or staff regarding specific schedulable time blocks in healthcare systems.

availability planavail_pln

The structured scheduling strategy or configuration that defines how open appointment slots are organized, allocated, and managed across providers or departments within clinical workflow and appointment management systems.

availability policy numberavail_pol_nbr

The insurance or operational policy identifier linked to an open appointment or scheduling availability record, used to validate coverage requirements or organizational rules governing specific schedulable time blocks in healthcare systems.

availability preferred nameavail_pref_nm

The preferred or alias display name assigned to an open appointment or scheduling availability record, allowing customized labeling of availability types or templates within scheduling interfaces and clinical workflow management systems.

availability priceavail_prc

The monetary cost assigned to an open appointment or scheduling availability record, representing the charge associated with booking a specific time slot or scheduling window within healthcare scheduling and billing systems.

availability primary indicatoravail_prim_ind

A flag identifying whether an open scheduling slot is the primary available time block for a given provider, resource, or service. Used in scheduling systems to distinguish main availability windows from secondary or overflow slots when coordinating patient appointments.

availability priorityavail_prty

A ranking value that determines the order in which open scheduling slots or resources are offered or filled. Used in scheduling and capacity management systems to ensure urgent appointment needs, high-demand services, or critical resources are allocated before lower-priority openings.

availability procedure dateavail_proc_dt

The calendar date on which a scheduled procedure or clinical service is designated to occur within an open time slot. Used in scheduling systems to align resource availability with procedure bookings and ensure accurate capacity planning and appointment coordination.

availability pulseavail_pulse

The recorded heart rate measurement associated with a patient at the time of a scheduled or open appointment slot. Used in clinical scheduling systems to capture pre-visit or intake vital sign data, supporting triage prioritization and clinical readiness assessments.

availability quantityavail_qty

The numeric count of open time slots, appointment blocks, or schedulable units available for a given resource, provider, or service period. Used in scheduling and capacity management systems to track how many bookings can still be accommodated within a defined availability window.

availability raceavail_race

The patient's self-reported racial classification recorded in association with a scheduling availability record. Used in scheduling and access analytics to monitor health equity metrics, identify disparities in appointment access, and support population health reporting requirements.

PreviousPage 71 of 806Next