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 indicatoravail_ind

Boolean or coded flag denoting whether an appointment slot or scheduling opening is currently active, open, or accessible. Used in scheduling and EHR systems to track the real-time state of appointment availability and support automated slot management workflows.

availability instructionavail_instr

Textual guidance or directives associated with an open appointment slot, such as patient preparation requirements or scheduling rules. Used in clinical scheduling systems to communicate specific conditions or actions required before or during an available appointment time.

availability keyavail_key

Lookup or reference value used to relate an open appointment slot record to associated entities within scheduling, EHR, or clinical data warehouse systems. Serves as a join key linking availability records to patients, providers, locations, or insurance data.

availability labelavail_lbl

Human-readable display text or descriptive tag assigned to an open appointment slot or scheduling availability record. Used in scheduling interfaces and clinical systems to present availability status in a user-friendly format for staff and patient-facing scheduling workflows.

availability languageavail_lang

Preferred spoken or written communication language associated with an open appointment slot or scheduling availability record. Used in scheduling and EHR systems to match patients with appropriately language-equipped providers or interpreter services during appointment planning.

availability last nameavail_last_nm

Family surname of the individual, such as a patient or contact, associated with an open appointment slot or scheduling availability record. Used to identify and display the person linked to the availability in scheduling systems and clinical data workflows.

availability legal nameavail_legal_nm

Official registered full name of the individual associated with an open appointment slot or scheduling availability record. Used in scheduling, enrollment, and EHR systems to ensure accurate legal identification of the person linked to the appointment opening.

availability levelavail_lvl

Hierarchical tier or classification assigned to an open appointment slot, indicating its position within a scheduling or care access structure. Used in scheduling systems and clinical data warehouses to categorize availability by priority, care setting, or organizational hierarchy.

availability license numberavail_lic_nbr

Professional license identifier associated with an open appointment slot, typically referencing the licensed clinician or facility linked to that availability. Used in scheduling and credentialing systems to verify and track licensure for clinical appointments and regulatory compliance reporting.

availability marital statusavail_mar_sts

Marital or relationship status of the individual associated with an open appointment slot or scheduling availability record. Captured in scheduling and EHR systems to support demographic profiling, insurance eligibility verification, and population health reporting workflows.

availability master identifieravail_mstr_id

Enterprise master identifier linking an open appointment slot to a master patient, provider, or entity record across integrated healthcare systems. Used in scheduling and health information systems to ensure consistent cross-system identification of availability records at the enterprise level.

availability maximumavail_max

Upper limit value defining the maximum capacity, count, or threshold allowed for an open appointment slot or scheduling availability record. Used in scheduling systems to enforce slot limits, control patient volume, and manage resource capacity within clinical workflows.

availability medical record numberavail_mrn

Patient medical record number associated with an open appointment slot or scheduling availability record. Used in scheduling and EHR systems to link the availability to a specific patient's longitudinal health record, supporting care coordination and appointment tracking workflows.

availability middle nameavail_mid_nm

Middle name or initial of the individual associated with an open appointment slot or scheduling availability record. Used in scheduling and EHR systems to support full-name identification, reducing patient matching errors and improving demographic accuracy across clinical workflows.

availability minimumavail_min

The lower threshold value defining the minimum open appointment slots or scheduling capacity required before an availability status triggers alerts or workflow actions in scheduling and capacity management systems.

availability mobileavail_mob

The mobile phone number associated with an open appointment slot or scheduling availability record, used to send SMS notifications or reminders to patients or staff regarding scheduled or available appointment times.

availability modified byavail_mod_by

The unique identifier of the user who last updated an open appointment or scheduling availability record, supporting audit trail requirements and accountability tracking within scheduling and clinical workflow management systems.

availability modified dateavail_mod_dt

The calendar date on which an open appointment or scheduling availability record was last updated, used to maintain accurate audit history and track changes to scheduling configurations within clinical workflow systems.

availability modified timeavail_mod_tm

The timestamp indicating when an open appointment or scheduling availability record was last modified, enabling precise audit tracking and chronological sequencing of scheduling changes within clinical workflow management systems.

availability nameavail_nm

The human-readable display label assigned to an open appointment or scheduling availability record, used to identify and distinguish availability types or time blocks within scheduling interfaces and clinical workflow systems.

PreviousPage 70 of 806Next