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 review systemsded_ros

The administrative or adjudication systems involved in evaluating and validating deductible accumulator balances, benefit plan rules, and member cost-sharing records. Referenced during claims audits and benefit coordination workflows to ensure deductible tracking is consistent across payer platforms and clearinghouse systems.

deductible revisionded_rev

The version or iteration number reflecting updates made to a deductible benefit structure within an insurance plan. Tracks amendments to deductible amounts, applicability rules, or accumulator logic over time, supporting audit trails and ensuring claims are adjudicated against the correct benefit plan revision during the coverage period.

deductible riskded_rsk

The actuarial risk level associated with a deductible structure, reflecting the likelihood that enrolled members will meet or exceed their cost-sharing threshold within the plan year. Used in underwriting, plan design analysis, and financial forecasting to model expected claims liability and premium adequacy.

deductible routeded_rte

The pathway or channel through which a deductible payment or accumulator credit is processed within the insurance system. Identifies whether cost-sharing contributions are applied through medical claims, pharmacy claims, or direct member payments, ensuring accurate benefit coordination and accumulator tracking across service types.

deductible scoreded_scr

A calculated numeric rating derived from a member's deductible accumulation progress relative to their plan-defined threshold in claims or PBM systems. Used in risk stratification, benefit analysis, and cost-sharing models to assess member financial liability exposure.

deductible sequenceded_seq

An ordering number that identifies the position of a deductible record within a series of related insurance cost-sharing transactions in claims or PBM systems. Used to maintain processing order across multiple deductible tiers, benefit periods, or accumulator adjustment events.

deductible service dateded_svc_dt

The calendar date on which a covered healthcare service was rendered that contributes to a member's deductible accumulation in claims or EHR systems. Critical for applying cost-sharing correctly within benefit period boundaries and coordinating benefits across payers.

deductible severityded_sev

A classification indicating the relative impact or seriousness of a deductible-related condition or financial obligation within claims or member enrollment systems. Used to prioritize deductible-related alerts, flag high-cost members, and support care management or benefit exception workflows.

deductible sexded_sex

The biological sex of a member enrolled under a deductible-bearing benefit plan. Used in actuarial analysis, health equity reporting, and population-level cost-sharing studies to assess deductible burden distribution and support regulatory reporting requirements across insurance plan demographic datasets.

deductible sourceded_src

Source system or channel for deductible within Billing processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

deductible start dateded_start_dt

The beginning date of the period during which a member's deductible accumulation becomes active in claims, PBM, or member enrollment systems. Defines the open boundary of the benefit window used for applying cost-sharing rules and resetting annual or plan-year accumulators.

deductible start timeded_start_tm

The precise timestamp marking the beginning of a deductible accumulation period or the initiation of a deductible-related transaction within the insurance system. Used in real-time claims adjudication and benefit coordination to sequence cost-sharing events accurately within a member's plan year accumulator records.

deductible stateded_st

The US state or territory associated with a deductible benefit structure, reflecting the jurisdiction under which the insurance plan's cost-sharing terms are governed. Used in plan design administration and regulatory compliance reporting to apply state-mandated deductible rules and benefit requirements to member accounts.

deductible statusded_sts

The current state of a member's deductible accumulation relative to their plan threshold in claims or PBM adjudication systems. Common values include not met, partially met, or satisfied, and directly governs how cost-sharing is applied during claims processing and real-time eligibility checks.

deductible street addressded_st_addr

The physical street address associated with the entity or member record linked to a deductible account in the insurance system. Used in member correspondence, billing, and plan administration to route deductible-related communications, statements, and explanation of benefits documents to the correct mailing location.

deductible strengthded_str

The magnitude or level of the deductible cost-sharing requirement within a benefit plan design, characterizing whether the threshold represents a high, standard, or low deductible plan. Referenced in plan selection analytics, consumer-directed health plan administration, and HSA eligibility determinations based on IRS minimum deductible thresholds.

deductible subtotalded_subtot

The partial accumulated amount applied toward a member's deductible obligation within a defined period or claims subset, before reaching the full deductible threshold. Used in claims adjudication and member cost-sharing reports to display mid-period accumulator balances and project when full deductible satisfaction will occur.

deductible system identifierded_sys_id

The unique system-generated key assigned to a deductible record within the insurance platform, enabling consistent identification and cross-system linkage of deductible structures across claims adjudication, member enrollment, and benefits administration applications throughout the plan year processing lifecycle.

deductible targetded_tgt

The destination reference value representing the plan-defined deductible threshold a member must reach before cost-sharing transitions in claims or PBM systems. Used to benchmark accumulator progress, configure adjudication rules, and generate member-facing benefit utilization reports.

deductible taxonomy codeded_tax_cd

A classification code that categorizes the type of deductible applied within a member's benefit plan, such as individual, family, in-network, or out-of-network. Used in claims adjudication and benefits administration to correctly apply cost-sharing rules during processing.

PreviousPage 51 of 178Next