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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

validation levelvalid_lvl

A hierarchical classification indicating the scope or tier of a validation process, such as member-level, group-level, or plan-level eligibility checks. Determines the granularity of verification applied in payer enrollment, claims adjudication, and quality audit workflows.

validation license numbervalid_lic_nbr

The professional license identifier verified during a credentialing or provider validation process. Used to confirm that a clinician holds an active, valid license in the appropriate state and specialty, supporting payer enrollment, network participation, and compliance requirements.

validation marital statusvalid_mar_sts

The recorded marital or relationship status of an individual captured during a validation process, such as member eligibility verification. Used to confirm dependent coverage eligibility, coordinate benefits between spouses, and maintain accurate demographic data in enrollment systems.

validation master identifiervalid_mstr_id

The enterprise-level master identifier assigned to a data validation record, enabling consistent cross-system tracking. Used in clinical data warehouses and health information systems to link validation events to a single authoritative reference across platforms and audit workflows.

validation maximumvalid_max

The upper boundary value defined for a data validation rule, used to flag clinical or administrative data exceeding acceptable thresholds. Applied in quality checks for lab results, vital signs, claim amounts, or enrollment data to enforce business and clinical rules.

validation medical record numbervalid_mrn

The patient medical record number associated with a data validation event, linking the validation process to a specific patient record. Used in clinical data quality workflows to trace validation failures or confirmations back to the source patient encounter or registration.

validation middle namevalid_mid_nm

The middle name or initial captured as part of identity validation for a patient, member, or provider record. Used during demographic matching and deduplication processes in enrollment systems, member registries, and clinical data integration to improve identity resolution accuracy.

validation minimumvalid_min

The lower boundary value defined for a data validation rule, used to detect clinical or administrative data falling below acceptable thresholds. Applied in quality checks for lab results, vital signs, claim amounts, or enrollment data to enforce business and clinical data integrity rules.

validation mobilevalid_mob

The mobile phone number recorded as part of a contact information validation process for a patient, member, or caregiver. Used in outreach, appointment reminders, and member engagement systems to verify and confirm contactability during enrollment or care management workflows.

validation modified byvalid_mod_by

The user identifier of the individual who last updated a validation record, supporting audit trail and accountability requirements. Used in clinical data governance and compliance workflows to track changes to validation rules, thresholds, or results across health information systems.

validation modified datevalid_mod_dt

The calendar date on which a validation record was last updated, providing an audit timestamp for data governance purposes. Used in clinical and administrative data quality workflows to track the recency of validation rule changes and support regulatory compliance reporting.

validation modified timevalid_mod_tm

The timestamp recording the exact time a validation record was last modified, complementing the modified date for precise audit trail documentation. Used in clinical data warehouses and health information systems to support change tracking and compliance with data governance standards.

validation namevalid_nm

The descriptive label assigned to a validation rule or validation record, providing a human-readable identifier for use in reporting and configuration interfaces. Used in clinical data quality tools and administrative systems to distinguish between validation types, rules, and outcomes.

validation numbervalid_nbr

A numeric reference assigned to uniquely identify a validation record or rule within a healthcare data system. Used in claims processing, clinical data quality management, and health information systems to track, retrieve, and audit specific validation instances across workflows.

validation onset datevalid_onset_dt

The date on which a condition, symptom, or clinical event began, captured as part of clinical data validation for diagnosis accuracy. Used in care management, chronic disease registries, and clinical documentation workflows to verify that onset dates align with encounter and claims data.

validation oxygen saturationvalid_o2sat

The blood oxygen saturation percentage captured as a validated clinical observation, typically recorded as SpO2. Used in inpatient, emergency, and remote monitoring workflows to verify that oxygen saturation values fall within clinically acceptable ranges and meet documentation quality standards.

validation paid amountvalid_pd_amt

The dollar amount confirmed as paid during a validation check on a healthcare claim or financial transaction. Used in claims adjudication and payment reconciliation workflows to verify that remittance amounts match expected payments based on contract terms, benefit rules, and fee schedules.

validation paid datevalid_pd_dt

The date on which a validated payment was issued for a healthcare claim or financial transaction. Used in claims processing and accounts receivable workflows to confirm payment timeliness, support remittance reconciliation, and meet regulatory prompt payment compliance requirements.

validation parentvalid_prnt

The reference to a parent record or hierarchical entity to which a validation record belongs, enabling nested validation structures. Used in clinical data governance and administrative systems to associate child validation rules or events with overarching rule sets, programs, or organizational hierarchies.

validation percentagevalid_pct

A ratio or percentage value used as a threshold or result within a data validation rule, expressed as a proportion of a defined total. Used in claims auditing, quality measure scoring, and clinical data governance workflows to assess compliance rates, error frequencies, or financial accuracy.

PreviousPage 293 of 325Next