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 countryavail_ctry

The country associated with a scheduling availability record, identifying the geographic jurisdiction in which the open appointment slot or care resource is located. Used in multi-national healthcare systems and global scheduling platforms to filter and report availability by country of service.

availability created byavail_crtd_by

The username or system identifier of the user or automated process that originally generated an open appointment slot or scheduling availability record. Used in scheduling audit trails to establish accountability and support troubleshooting of scheduling system data integrity issues.

availability created dateavail_crtd_dt

The calendar date on which an open appointment slot or scheduling availability record was first entered into the scheduling system. Used in operational reporting and audit workflows to track when availability was established and to measure lead time between slot creation and booking.

availability created timeavail_crtd_tm

The timestamp indicating the precise time of day at which an open appointment slot or scheduling availability record was created in the scheduling system. Used alongside the created date to support detailed audit trails and scheduling workflow performance analysis.

availability creatinineavail_cr

The creatinine laboratory value recorded in the context of a scheduling availability record, typically used to document renal function status relevant to determining a patient's eligibility or readiness for a specific procedure or treatment appointment within clinical scheduling workflows.

availability dateavail_dt

The specific calendar date on which an appointment slot or scheduling resource is open and accessible for booking. Used in scheduling systems to identify when providers, rooms, or equipment are available to deliver patient care services across ambulatory, inpatient, and ancillary settings.

availability datetimeavail_dttm

The combined date and time value pinpointing the exact moment an appointment slot or scheduling resource becomes open for booking. Used in real-time scheduling systems to manage precise slot allocation, prevent double-booking, and support appointment reminder and notification workflows.

availability dea numberavail_dea_nbr

The Drug Enforcement Administration registration number associated with a scheduling availability record, typically identifying a licensed prescriber whose controlled substance prescribing authority is relevant to the type of appointment slot being offered, such as pain management or addiction treatment services.

availability death dateavail_death_dt

The recorded date of death associated with a patient or individual linked to a scheduling availability record. Used to close out open appointment slots, cancel future bookings, and update scheduling system records when a patient is deceased, ensuring accurate capacity reporting.

availability deductible amountavail_ded_amt

The dollar amount representing the portion of a patient's insurance deductible applicable to an appointment associated with an open scheduling slot. Used in pre-service financial counseling and scheduling workflows to inform patients of their estimated out-of-pocket responsibility before the visit.

availability deleted dateavail_del_dt

The date on which an open appointment slot or scheduling availability record was removed or soft-deleted from the scheduling system. Used in audit and data governance workflows to maintain a historical record of when availability was withdrawn and to support slot utilization reconciliation reporting.

availability deleted indicatoravail_del_ind

A flag indicating whether an open appointment slot or scheduling availability record has been logically removed from active use in the scheduling system. Enables soft-delete functionality so historical availability data is retained for audit, reporting, and capacity analysis without appearing in active scheduling queues.

availability descriptionavail_desc

A human-readable text explanation describing the nature, purpose, or characteristics of an open appointment slot or scheduling availability window. Used in scheduling systems to communicate slot details to staff and patients, such as visit type, service line, or special instructions associated with the available time.

availability detailavail_dtl

Granular information captured about a specific open appointment slot or scheduling availability record, including attributes such as slot type, duration, service restrictions, or resource requirements. Used in scheduling systems to ensure appropriate matching of patient appointment needs to the correct available time and resource.

availability discharge dateavail_dsch_dt

The date a patient or resource is released from an open time slot or scheduled availability block. Used in scheduling systems to mark when a reserved availability window closes due to discharge, enabling capacity tracking and future slot planning.

availability due dateavail_due_dt

The deadline by which an open scheduling availability slot must be acted upon, confirmed, or filled. Used in appointment scheduling and care coordination systems to ensure timely booking of open time blocks and prevent scheduling gaps in clinical workflows.

availability durationavail_dur

The total length of time an open scheduling slot remains active and bookable within a scheduling or care coordination system. Calculated as the difference between start and end times, used to allocate appropriate resources and match patient appointment needs to open time blocks.

availability effective dateavail_eff_dt

The date on which an open scheduling time slot becomes active and eligible for appointment booking. Used in scheduling systems to control when a provider or resource availability window opens, supporting accurate calendar management and appointment assignment workflows.

availability emailavail_eml

The electronic mail address associated with an open scheduling availability slot or the contact responsible for managing it. Used in scheduling and care coordination systems to route booking confirmations, cancellations, and slot-related communications to the appropriate recipient.

availability emergency indicatoravail_emerg_ind

A flag designating whether an open scheduling slot is reserved for urgent or emergency use only. Used in scheduling systems to prioritize access to specific time blocks for acute care needs, preventing routine bookings from consuming capacity designated for emergent patient situations.

PreviousPage 68 of 806Next