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 rangeavail_rng

The defined span of time, dates, or numeric values within which a scheduling slot or resource is considered open and bookable. Used in scheduling systems to set boundaries for when appointments can be offered, supporting accurate calendar management and resource allocation.

availability rateavail_rt

The reimbursement or charge amount associated with a specific open appointment slot or schedulable service. Used in scheduling and revenue cycle systems to link time-slot availability with applicable fee schedules, ensuring accurate cost assignment when appointments are booked and billed.

availability ratingavail_rtg

A scored assessment value applied to an open scheduling slot or resource, reflecting quality, preference, or suitability for specific appointment types. Used in scheduling optimization systems to rank and recommend available times based on clinical needs, patient preferences, or operational criteria.

availability ratioavail_ratio

A proportional measure comparing open appointment slots to total capacity or demand within a scheduling period. Used in healthcare operations and capacity planning to evaluate how well available scheduling resources meet patient demand and identify potential access or throughput bottlenecks.

availability reasonavail_rsn

A descriptive code or text explaining why a scheduling slot is open, blocked, or in a specific availability state. Used in scheduling systems to document causes such as cancellations, provider time-off, facility closures, or newly released capacity, supporting schedule management and audit tracking.

availability received dateavail_rcvd_dt

The date on which an availability record, scheduling request, or open slot notification was received or entered into the scheduling system. Used in scheduling workflows to track turnaround time between availability identification and booking, supporting access performance and appointment lag reporting.

availability referenceavail_ref

An identifier or pointer linking an open scheduling slot to an external record, request, or system entity such as a referral, authorization, or work order. Used in scheduling systems to maintain traceability between available appointment times and the upstream clinical or administrative events that generated them.

availability resolution dateavail_resol_dt

The date on which an open scheduling slot is closed, filled, or otherwise resolved, ending its active availability status. Used in scheduling systems to track the lifecycle of open appointment blocks and measure time-to-fill metrics for capacity planning and access performance reporting.

availability respirationavail_resp

The recorded respiratory rate of a patient associated with a scheduled or open appointment slot. Used in clinical scheduling systems to capture pre-visit or intake vital sign data, supporting triage and acuity assessments when prioritizing or assigning available appointment times.

availability resultavail_rslt

The outcome recorded for an open scheduling slot, such as whether it was filled, cancelled, left open, or converted to a specific appointment type. Used in scheduling analytics to measure booking conversion rates, identify unused capacity, and support scheduling efficiency reporting.

availability review systemsavail_ros

A structured assessment of relevant body systems documented in association with a scheduled or open appointment slot. Used in clinical scheduling systems to capture pre-visit review-of-systems data that informs appointment type assignment, clinical preparation, and appropriate resource allocation.

availability revisionavail_rev

A version or iteration number tracking changes made to an open scheduling slot record over time. Used in scheduling systems to maintain an audit history of modifications to availability windows, time blocks, or slot attributes, supporting data integrity and change management workflows.

availability riskavail_rsk

A classification indicating the level of clinical or operational risk associated with an open scheduling slot or patient awaiting appointment placement. Used in scheduling triage workflows to prioritize high-risk patients for earlier access and ensure appropriate resource allocation based on acuity.

availability routeavail_rte

The designated pathway or channel through which an open appointment slot is made accessible to patients or referring entities, such as online booking, call center, or direct referral. Used in scheduling systems to track how available times are distributed and filled across different access channels.

availability scheduled dateavail_sched_dt

The calendar date on which an open appointment slot is scheduled within a scheduling system. Used to identify when provider time is designated as available for patient booking, enabling capacity planning and appointment utilization tracking across care settings.

availability scheduled timeavail_sched_tm

The specific time of day assigned to an open appointment slot within a scheduling system. Captures the hour and minute at which provider availability begins, supporting precise appointment booking, schedule optimization, and patient flow management across clinical settings.

availability scoreavail_scr

A calculated numeric rating representing the relative accessibility or openness of a scheduling slot or resource. Used in scheduling systems to rank or prioritize available appointment times, providers, or locations based on demand, utilization patterns, or patient matching criteria.

availability sequenceavail_seq

A numeric value that defines the ordering position of an open scheduling slot within a series of availability records. Used to maintain the correct chronological or logical order of available time blocks when processing, displaying, or managing provider schedules in healthcare scheduling systems.

availability service dateavail_svc_dt

The date on which a scheduled open time slot is designated for care delivery within a healthcare scheduling system. Used to align available appointment slots with intended service dates, supporting accurate scheduling, resource allocation, and appointment utilization reporting.

availability severityavail_sev

A classification indicating the urgency or priority level associated with an open scheduling slot, such as slots reserved for acute, urgent, or routine care. Used in scheduling systems to match appointment availability with appropriate patient acuity levels and care prioritization rules.

PreviousPage 72 of 806Next