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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

validation service datevalid_svc_dt

Records the date of service that was confirmed or corrected during a claim or clinical record validation process. Ensures the verified service date aligns with encounter documentation, supporting accurate claims adjudication, timely filing compliance, and audit trail integrity across healthcare data systems.

value adjustment amountval_adj_amt

Represents a financial adjustment applied to a claim or payment based on value-based care performance metrics, quality benchmarks, or risk-adjusted calculations. Used in value-based contracting to reflect bonus payments, penalties, or reconciliation amounts tied to provider or plan performance outcomes.

value claim dateval_clm_dt

Captures the date a claim was submitted or processed under a value-based payment arrangement or quality-linked reimbursement program. Used to track the timing of claims within value-based contract performance periods for reconciliation, reporting, and alignment with measurement year boundaries.

value claim statusval_clm_sts

Reflects the adjudication state of a claim processed under a value-based care or alternative payment model, indicating whether it has been approved, denied, pended, or adjusted based on quality or utilization criteria. Supports financial reporting and contract performance tracking for value-based arrangements.

value deductible amountval_ded_amt

Records the deductible amount applied to a claim within a value-based benefit design, such as a high-deductible health plan linked to quality incentives or a value-based insurance design (VBID) waiving cost-sharing for high-value services. Used in member cost-sharing calculations and benefit reconciliation.

value payment amountval_pmt_amt

Records the total dollar amount paid under a value-based reimbursement arrangement, which may include base payments plus quality bonuses, shared savings distributions, or risk-adjusted capitation. Used in alternative payment model financial reporting to track actual disbursements against contracted value-based payment targets.

value payment statusval_pmt_sts

Indicates the current processing state of a payment associated with a value-based care transaction or arrangement. Tracks whether payments tied to quality metrics, outcomes, or shared savings have been initiated, processed, reconciled, or rejected within value-based reimbursement programs.

value review systemsval_ros

Identifies the body systems evaluated during a clinical review conducted under a value-based care assessment framework. Used in quality measurement workflows to document which anatomical or physiological systems were examined when determining care value scores or outcomes-based performance metrics.

value service dateval_svc_dt

Records the specific date on which a healthcare service was delivered and attributed to a value-based care episode or quality measurement period. Used in outcomes reporting and performance scoring to align service delivery dates with contract measurement windows and benchmark calculations.

verification active indicatorverif_actv_ind

A binary flag indicating whether a verification record, such as insurance eligibility, provider credentials, or member identity confirmation, is currently active and valid. Used in enrollment and claims processing to determine if a verification check remains in effect or has expired.

verification active statusverif_actv_sts

Captures the current operational state of a verification process, such as insurance eligibility or credentialing confirmation, indicating whether it is active, inactive, pending, or expired. Used in member enrollment and claims adjudication to validate that verification records remain current and actionable.

verification addressverif_addr

Stores the physical or mailing address confirmed during an eligibility or identity verification process. Used in member enrollment and claims processing to validate that the address on file matches payer or government records, ensuring accurate correspondence and coverage determination for the verified individual.

verification adjustment amountverif_adj_amt

Represents a monetary adjustment applied to a claim or payment record as a result of a verification review, such as eligibility confirmation or coordination of benefits. Used in claims adjudication to document corrections made to billed or allowed amounts following verification findings.

verification ageverif_age

Records the confirmed age of a member or patient at the time of verification, typically derived from the verified date of birth. Used in eligibility and enrollment processing to validate age-dependent coverage rules, pediatric benefits, Medicare eligibility thresholds, or age-rated premium calculations.

verification allowed amountverif_alwd_amt

Captures the maximum reimbursable dollar amount confirmed through a verification process for a specific service or claim. Used in claims adjudication and eligibility verification to establish payment ceilings based on confirmed coverage terms, contracted rates, or benefit plan rules applicable to the verified member.

verification amountverif_amt

Records the total monetary value confirmed or validated during a verification transaction, such as an eligibility check, prior authorization, or benefit confirmation. Used in claims processing and enrollment systems to document the financial scope of coverage or liability established through the verification process.

verification approval statusverif_appr_sts

Indicates whether a verification request, such as prior authorization, eligibility confirmation, or credentialing review, has been approved, denied, pended, or returned. Used in claims adjudication and utilization management to track authorization decisions and determine whether services or payments may proceed.

verification approved byverif_appr_by

Identifies the user, reviewer, or system that granted approval for a verification record such as a prior authorization, eligibility confirmation, or credentialing check. Used in audit trails and compliance workflows to attribute accountability for verification decisions in claims and enrollment processing systems.

verification arrival timeverif_arrv_tm

Records the specific time at which a patient physically arrived at a care facility during an encounter that required identity or eligibility verification. Used in registration and scheduling workflows to timestamp the verification event, supporting accurate tracking of wait times and service delivery sequencing.

verification arrived dateverif_arrv_dt

Captures the calendar date on which a patient arrived at a healthcare facility and eligibility or identity verification was initiated or completed. Used in registration and encounter management systems to establish the precise date of verification for claims submission, billing, and coverage determination purposes.

PreviousPage 168 of 178Next