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

authorization instructionauth_instr

Free-text or coded guidance associated with a prior authorization record in utilization management, EHR, and payer systems, specifying clinical protocols, site-of-care requirements, or documentation expectations. Used by data engineers to extract structured directives for care management workflows, build instruction repositories, and support provider-facing authorization communication pipelines.

authorization labelauth_lbl

The descriptive display text assigned to a prior authorization record within a health plan or utilization management system. Used to identify authorization types, categorize approved services, and support reporting, member communication, and claims adjudication workflows across payer platforms.

authorization noteauth_nt

Free-text annotation field capturing clinical justification, reviewer comments, or conditional approval details for a prior authorization record in UM platforms (Utilization Management), EHR systems, and claims adjudication engines. Parsed during downstream audit and appeals processing.

authorization procedure dateauth_proc_dt

The specific calendar date on which an authorized clinical procedure is scheduled or performed. Used by health plans to validate that billed services fall within the approved authorization period, ensuring claims adjudication aligns with utilization management approvals and prevents unauthorized service payment.

authorization rangeauth_rng

Minimum and maximum boundary values defining the approved scope of a prior authorization in UM systems, encompassing allowable quantity ranges, dosage thresholds, or service frequency limits. Used in claims adjudication and PBM systems to validate whether submitted services fall within approved parameters.

authorization resultauth_rslt

Coded outcome value recorded in payer UM systems after evaluation of a prior authorization request, such as approved, denied, pended, or partially approved. Drives downstream claims adjudication logic, member and provider notifications, and appeals workflow initiation in managed care platforms.

authorization surgery dateauth_surg_dt

The calendar date on which an authorized surgical procedure is scheduled or completed. Used by health plan systems to confirm that surgical claims are submitted within the approved authorization window, supporting utilization management compliance and accurate adjudication of surgical benefits.

availability account numberavail_acct_nbr

The unique account reference number associated with a provider or facility scheduling availability record. Used in scheduling and capacity management systems to link open appointment slots to specific billing accounts, enabling coordination between patient access workflows and revenue cycle operations.

availability active indicatoravail_actv_ind

A binary flag indicating whether a scheduling availability slot or resource window is currently open and bookable within a provider scheduling system. Used to control patient appointment booking workflows and ensure care coordination systems reflect real-time provider or facility capacity status.

availability active statusavail_actv_sts

The current operational state of a provider or resource scheduling availability record, indicating whether the time slot is open, reserved, or inactive. Used in scheduling platforms to manage patient access, coordinate care resources, and maintain accurate capacity reporting across clinical operations.

availability addressavail_addr

The physical location associated with a provider or facility scheduling availability record, identifying where care services are available during a given time window. Used in scheduling systems to direct patients to the correct care site and support geographic access reporting for health plan network management.

availability adjustment amountavail_adj_amt

The monetary value representing a financial modification applied to a scheduling or capacity availability transaction. Used in revenue cycle and operational reporting systems to capture changes such as rate corrections or cost reallocations associated with provider or facility availability scheduling records.

availability admission dateavail_admn_dt

The calendar date on which a patient admission is linked to or triggered by a provider or facility availability record. Used in care coordination and scheduling systems to align inpatient capacity planning with actual admission timelines, supporting utilization management and bed management workflows.

availability ageavail_age

The calculated age in years associated with a patient or resource linked to a scheduling availability record. Used in scheduling and care coordination systems to apply age-based eligibility rules, match patients to appropriate care settings, and support population health and access reporting analytics.

availability allowed amountavail_alwd_amt

The maximum dollar amount a payer will reimburse for a scheduled open time slot in scheduling systems. Represents the contracted rate ceiling applied during adjudication of availability-linked transactions, used in financial reconciliation and reporting workflows.

availability amountavail_amt

The monetary value associated with an open time slot in provider scheduling systems. Captures the base financial figure tied to an availability window, used for cost tracking, financial planning, and reconciliation of scheduled versus actual service amounts.

availability approval statusavail_appr_sts

Indicates the current authorization state of an open scheduling slot, such as pending, approved, or denied. Tracks whether the availability record has been reviewed and sanctioned within scheduling or utilization management workflows before a patient encounter is confirmed.

availability approved byavail_appr_by

Records the identifier or name of the user who authorized an open scheduling slot within the scheduling or utilization management system. Supports audit trail requirements and accountability tracking for availability approvals in clinical operations workflows.

availability arrival timeavail_arrv_tm

The recorded clock time at which a patient physically arrived for a scheduled open time slot. Used in scheduling and patient flow systems to calculate wait times, measure operational efficiency, and support throughput reporting in clinical settings.

availability arrived dateavail_arrv_dt

The calendar date on which a patient arrived for a scheduled open time slot. Used in scheduling and patient flow systems to confirm appointment attendance, calculate no-show rates, and support operational and compliance reporting across clinical settings.

PreviousPage 66 of 806Next