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

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

beneficiary death datebenf_death_dt

The recorded date of death for an insurance coverage recipient, used to terminate eligibility, close active claims, and update enrollment records within health plan systems. Critical for coordination of benefits, estate claim processing, and compliance with CMS reporting requirements for deceased members.

beneficiary deductible amountbenf_ded_amt

The dollar threshold an insurance coverage recipient must pay out-of-pocket for covered healthcare services before the health plan begins sharing costs. Tracked in claims adjudication systems to accumulate member spending, apply benefit triggers, and calculate remaining deductible liability across the coverage period.

beneficiary deleted datebenf_del_dt

The date on which a beneficiary record was logically removed from the health plan enrollment system. Used in member management to maintain audit history, support retroactive eligibility reconciliation, and track when coverage recipients were purged from active enrollment files.

beneficiary deleted indicatorbenf_del_ind

A flag denoting whether a beneficiary record has been logically removed from active health plan enrollment. Supports eligibility verification, claims adjudication, and retroactive coverage audits by distinguishing inactive or purged member records from currently enrolled beneficiaries.

beneficiary descriptionbenf_desc

A human-readable text field that describes or labels a beneficiary record within health plan enrollment systems. Typically captures narrative details about the coverage recipient's plan category, relationship to subscriber, or special program designation for administrative and reporting purposes.

beneficiary detailbenf_dtl

Granular enrollment and demographic data associated with a health plan beneficiary, including coverage tier, plan assignment, and relationship to the primary subscriber. Used in member management systems to support claims processing, eligibility verification, and benefits administration workflows.

beneficiary due datebenf_due_dt

The date by which a required action, payment, or document submission must be completed for a health plan beneficiary. Used in enrollment and billing systems to track premium payment deadlines, enrollment form submissions, or open enrollment compliance timelines for coverage recipients.

beneficiary durationbenf_dur

The total length of time a beneficiary has been or was enrolled in a health plan, calculated between enrollment effective and termination dates. Used in member analytics, risk stratification, and population health reporting to measure continuity of coverage across plan years.

beneficiary effective datebenf_eff_dt

The date on which a beneficiary's health plan coverage becomes active and benefits are accessible. This date governs claims eligibility adjudication, coordinates benefits across payers, and establishes the start of the coverage period used in enrollment and premium billing systems.

beneficiary emailbenf_eml

The electronic mail address on file for a health plan beneficiary, used for member communications including enrollment confirmations, Explanation of Benefits notices, open enrollment alerts, and care management outreach within health plan member engagement systems.

beneficiary emergency indicatorbenf_emerg_ind

A flag identifying a health plan beneficiary who requires urgent attention, such as those with critical coverage gaps, active emergency Medicaid enrollment, or flagged medical conditions requiring expedited plan coordination. Used in member management and care management escalation workflows.

beneficiary end datebenf_end_dt

The date on which a beneficiary's health plan enrollment or specific coverage period terminates. Used in eligibility systems to determine claims payability, coordinate COBRA or continuation coverage timelines, and reconcile retroactive disenrollment events with premium billing records.

beneficiary end timebenf_end_tm

The specific timestamp marking the end of a beneficiary's coverage period or enrollment transaction, recorded at the time-of-day level. Used in real-time eligibility systems and enrollment platforms to precisely sequence coverage terminations and resolve same-day enrollment conflicts.

beneficiary enrollment statusbenf_enrl_sts

The current state of a beneficiary's participation in a health plan, such as active, pending, terminated, or suspended. Drives eligibility determination in claims adjudication, pharmacy benefit management, and member services systems to confirm whether a coverage recipient may access plan benefits.

beneficiary entered bybenf_ent_by

The identifier of the user or system that created or submitted a beneficiary's enrollment record in the health plan administration system. Used for audit trail purposes, data governance, and troubleshooting enrollment discrepancies tied to manual entry, EDI transactions, or automated eligibility feeds.

beneficiary ethnicitybenf_ethn

The self-reported or administratively assigned ethnic classification of a health plan beneficiary, captured in compliance with HEDIS, CMS, and ACA demographic reporting requirements. Used in health equity analytics, population health stratification, and disparity reporting across member populations.

beneficiary expiration datebenf_exp_dt

The date after which a beneficiary's enrollment record, identification card, or specific plan benefit authorization is no longer considered valid. Used in eligibility verification, pharmacy claims adjudication, and referral management systems to prevent payment of claims for lapsed coverage periods.

beneficiary external identifierbenf_ext_id

A unique reference number assigned to a beneficiary by an external system such as a state Medicaid agency, CMS, or third-party administrator. Used to link member records across disparate health plan platforms, facilitate data exchange via EDI 834 transactions, and support cross-system eligibility reconciliation.

beneficiary faxbenf_fax

The facsimile telephone number associated with a health plan beneficiary, used for transmitting enrollment documents, prior authorization forms, and coordination of benefits correspondence. Retained in member contact records to support administrative workflows requiring physical document exchange.

beneficiary feebenf_fee

A charge assessed directly to a health plan beneficiary, such as a premium contribution, copayment obligation, or enrollment fee associated with a specific plan tier. Used in member billing systems, premium reconciliation workflows, and financial reporting for cost-sharing arrangement tracking.

PreviousPage 7 of 142Next