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

deductible cancelled dateded_cncl_dt

The calendar date on which a deductible accumulator, plan benefit, or deductible-related transaction was voided or cancelled within the benefits administration system. Used in enrollment and claims systems to track mid-year plan terminations, retroactive cancellations, or administrative corrections affecting member cost-sharing obligations.

deductible categoryded_cat

Categorization label for deductible within Provider processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

deductible charge amountded_chrg_amt

The dollar amount of a healthcare service charge designated as the member's responsibility toward satisfying their annual deductible under their insurance benefit plan. Used in claims adjudication to calculate how much of an allowed amount is applied to the deductible accumulator before coinsurance or copayment obligations begin.

deductible chief complaintded_cc

The primary diagnosis or service category associated with a claim or encounter used to determine deductible applicability under a member's benefit plan. Used in benefits administration to evaluate whether specific services are subject to the standard deductible or qualify for deductible waivers under preventive care or specialty carve-out provisions.

deductible childded_chld

A dependent or subordinate entity record associated with a parent deductible configuration in member enrollment and claims systems. Used by payers to manage family deductible structures, linking individual child accumulations to aggregate family deductible thresholds in benefits administration platforms.

deductible cityded_city

The municipality associated with the mailing or billing address used to establish or administer a member's deductible under a geographically defined health insurance plan. Used in benefits administration and regional plan management to support location-based benefit structure assignments and market-specific deductible threshold configurations.

deductible claim dateded_clm_dt

The date a healthcare claim was submitted or received by the payer, used to determine which benefit plan year's deductible accumulator should be credited when processing member cost-sharing obligations. Used in claims adjudication to correctly allocate charges to the appropriate annual or plan-year deductible threshold.

deductible claim statusded_clm_sts

The current processing state of a claim as it relates to deductible adjudication, indicating whether the deductible portion has been calculated, pended, applied, or denied. Used in claims management systems to track where a claim is in the adjudication lifecycle for member cost-sharing determination and remittance processing.

deductible classded_cls

A classification tier assigned to a deductible record that categorizes the type or level of cost-sharing obligation within a health plan. Used in EHR, claims adjudication, and enrollment systems to differentiate in-network, out-of-network, medical, or pharmacy deductible tiers for benefit calculations.

deductible codeded_cd

A standardized alphanumeric identifier representing a specific deductible type or configuration within clinical and claims processing workflows. Used in EHR, payer adjudication, and PBM systems to classify deductible rules for reporting, cross-system integration, and downstream benefits analytics.

deductible coinsurance amountded_coins_amt

The dollar value representing the member's coinsurance obligation that applies after the deductible threshold has been satisfied under their health insurance benefit plan. Used in claims adjudication to calculate post-deductible member cost-sharing, distinguishing between amounts applied to the deductible versus ongoing percentage-based coinsurance responsibilities.

deductible commentded_cmt

Free-text annotation field attached to a deductible record in claims, enrollment, or EHR systems. Used by data engineers and plan administrators to capture exceptions, manual adjustments, or supplemental context that cannot be expressed through structured deductible codes or amounts in healthcare data platforms.

deductible completed dateded_cmpl_dt

The date on which a member fully satisfied their annual deductible threshold, triggering transition to coinsurance or full plan coverage for subsequent covered services. Used in benefits administration and claims adjudication systems to update accumulator status and adjust downstream cost-sharing calculations for remaining claims in the benefit period.

deductible confidential indicatorded_conf_ind

Privacy protection flag identifying whether a member's deductible information is subject to restricted access due to sensitive benefit categories such as behavioral health, substance use treatment, or family plan separation requirements. Used in benefits administration to enforce confidentiality rules governing disclosure of cost-sharing details on explanation of benefits documents.

deductible contactded_cntct

The designated communication point, such as a phone number, fax, or contact person, associated with a deductible record in payer or enrollment systems. Used to facilitate member inquiries, deductible dispute resolution, and plan administration communications across healthcare data platforms.

deductible countded_cnt

A numeric aggregation of deductible-related records or events within utilization management and claims reporting workflows. Used by data engineers in healthcare analytics platforms to measure frequency of deductible applications, track accumulation events, and support population-level cost-sharing trend reporting.

deductible countryded_ctry

The country associated with a member's deductible record in the benefits administration system. Used in member enrollment and plan configuration to apply country-specific deductible rules, thresholds, and accumulator logic for international or multi-national health plan coverage.

deductible created byded_crtd_by

The username or system identifier of the user who created the deductible record in the benefits administration or claims system. Used in audit trails to track who established the deductible configuration, threshold amount, or accumulator rule for a member's health plan benefit period.

deductible created dateded_crtd_dt

The system-generated or manually entered date when a deductible record was first created in a payer, EHR, or enrollment platform. Used in audit trails, data lineage tracking, and downstream analytics to establish record provenance and support change management in healthcare data pipelines.

deductible created timeded_crtd_tm

The timestamp recording when a deductible record was first created in the benefits administration or claims system. Used for audit logging and change management to track the initial setup of deductible thresholds, accumulator rules, or member-specific benefit configuration entries.

PreviousPage 46 of 178Next