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

member dual eligiblembr_dual_elig

A Medicare beneficiary who also qualifies for Medicaid benefits, receiving coverage from both programs simultaneously. Dual eligible members represent approximately 20 percent of Medicare beneficiaries but account for over 30 percent of Medicare spending due to higher clinical complexity and social needs. Full dual eligibles receive comprehensive Medicaid benefits while partial duals receive limited Medicaid assistance with Medicare cost-sharing. In CMS-HCC risk adjustment, dual eligibility status affects demographic RAF score coefficients. Healthcare data teams use mbr_dual_elig in risk stratification, care management prioritization, capitation payment calculations, and health equity analytics to identify and address disparities in care for this high-need population.

member due datembr_due_dt

The date by which an insurance plan enrollee's premium payment or member-responsible balance is expected to be received. Used in member billing systems to trigger payment reminders, assess late fees, initiate grace period tracking, and manage potential disenrollment for non-payment per plan rules.

member durationmbr_dur

The calculated length of time an individual has been continuously enrolled in a health insurance plan, measured in days, months, or years. Used in population health analytics, risk stratification, and actuarial modeling to assess utilization patterns and long-term cost trends across member cohorts.

member effectivembr_eff

The date on which a member enrollment, benefit, or coverage record becomes active in a health plan system. Used in eligibility verification, claims adjudication, and enrollment reporting to determine when coverage begins and whether services are covered under the active benefit period.

member effective datembr_eff_dt

The start date on which a health plan enrollee's coverage becomes active, as recorded in enrollment and eligibility systems such as FACETS, HealthRules, or QNXT. Critical for data engineers validating claims eligibility, benefit period logic, and enrollment span calculations in member dimension tables.

member eligibilitymbr_elig

Indicates whether a health plan member is entitled to receive covered benefits on a specific date of service. Member eligibility is the foundation of claims adjudication — before any claim is paid, the payer verifies the member was enrolled and covered on the service date. Eligibility is determined by enrollment effective date, termination date, plan assignment, and benefit period. In Medicare Advantage, CMS transmits eligibility data via the MARx system. Healthcare data teams build eligibility verification pipelines that process 270/271 EDI transactions and maintain point-in-time eligibility snapshots to support claims adjudication, HEDIS measure denominators, and retroactive coverage audits.

member emailmbr_eml

The electronic mail address associated with a health plan enrollee, stored in enrollment and member portal systems. Used by data engineers for member communications integration, identity matching across CRM and EHR platforms, and regulatory outreach compliance reporting in payer data warehouses.

member emergency indicatormbr_emerg_ind

A flag on a member enrollment or claims record designating that a service was accessed or a status was triggered under emergency conditions. Used in claims adjudication to apply emergency benefit provisions, waive prior authorization requirements, and ensure correct application of out-of-network emergency coverage rules.

member end datembr_end_dt

The date marking the close of a health plan enrollee's active coverage period, stored in enrollment and eligibility systems such as FACETS or HealthRules. Data engineers use this field to define member span records, validate claims against active coverage windows, and support retroactive eligibility reconciliation processes.

member end timembr_end_tm

The precise timestamp marking the conclusion of a time-bounded event or coverage period associated with an insurance plan enrollee. Used in eligibility and encounter systems to define the boundary of a coverage segment, authorization window, or enrollment span for accurate benefits determination and claims adjudication.

member enrollmentmbr_enrl

The process and current status of a health plan member being registered in a payer administrative system with active coverage rights. Member enrollment encompasses plan selection, effective date assignment, premium billing setup, and benefit package assignment. In Medicare Advantage, enrollment is managed through CMS MARx and governed by annual enrollment periods. Medicaid enrollment is managed by state agencies and MCO contractors. Healthcare data teams build enrollment pipelines that process 834 EDI transactions, maintain enrollment span tables with effective and termination dates, and support HEDIS continuous enrollment calculations and CMS enrollment reconciliation reporting.

member enrollment datembr_enrl_dt

The date on which a health plan member completed the enrollment process and was formally registered in the payer administrative system. Member enrollment date differs from the coverage effective date — enrollment date captures when the administrative transaction was processed while effective date defines when benefits become active. In Medicare Advantage, CMS processes enrollment transactions and assigns effective dates based on enrollment period rules and the date the election was received. Healthcare data teams use mbr_enrl_dt in enrollment audit trails, processing time analytics, and CMS enrollment submission reconciliation to distinguish between when a member enrolled and when their coverage actually began, supporting retroactive eligibility investigations and enrollment timeline reporting.

member enrollment statusmbr_enrl_sts

The current state of an individual's participation in a health insurance plan, such as active, terminated, suspended, or pending. Used in eligibility systems to determine benefit availability, drive claims adjudication decisions, and support regulatory reporting to CMS, state exchanges, or employer group administrators.

member enrollment typembr_enrl_typ_cd

A coded value identifying the mechanism or circumstance through which a health plan member enrolled in coverage. Common enrollment type codes include open enrollment for annual plan selection periods, special enrollment period for qualifying life events, auto-enrollment for Medicaid and low income subsidy eligible beneficiaries, passive enrollment for CMS-facilitated enrollment in benchmark plans, employer group enrollment for employer-sponsored coverage, and new hire enrollment for employees joining a group plan. Enrollment type drives the effective date logic applied to coverage start dates and determines which eligibility documentation requirements apply. Healthcare data teams use mbr_enrl_typ_cd in enrollment audit reporting, CMS compliance submissions for Medicare Advantage enrollment, and retroactive eligibility investigations when coverage start dates are disputed.

member entered bymbr_ent_by

The identifier of the user, operator, or system that manually keyed or submitted an insurance plan enrollee's record into the enrollment or eligibility platform. Captured for audit trail and data stewardship purposes, enabling traceability of enrollment transactions back to their originating source or responsible party.

member esrdmbr_esrd_ind

An indicator identifying a Medicare beneficiary with End Stage Renal Disease, a condition of permanent kidney failure requiring dialysis or kidney transplantation to sustain life. ESRD is a qualifying condition for Medicare eligibility regardless of age. Members with ESRD have significantly higher predicted healthcare costs and carry higher CMS-HCC demographic risk adjustment coefficients. ESRD status affects eligibility for Special Needs Plans and triggers distinct Medicare payment rules including a transplant coverage period. Healthcare data teams use mbr_esrd_ind in risk adjustment pipelines to apply correct ESRD demographic coefficients in RAF score calculations, in care management stratification to identify members requiring specialized renal care coordination, and in network adequacy analysis to ensure dialysis facility access.

member ethnicitymbr_ethn

The self-reported or administratively assigned ethnicity classification of an insurance plan enrollee, following standard categories such as those defined by OMB. Used in health equity analyses, HEDIS reporting, risk adjustment, and population health programs to identify disparities and stratify outcomes across demographic groups.

member expirationmbr_exp

The date on which a member enrollment, benefit, or coverage record expires or becomes inactive in a health plan system. Used in eligibility verification and claims adjudication to identify terminated coverage and prevent payment for services rendered after coverage end date.

member expiration datembr_exp_dt

The date on which an enrolled health plan member's coverage, authorization, or identification credential ceases to be valid, recorded in payer enrollment and prior authorization systems. Used by data engineers to enforce eligibility business rules, expire member dimension records, and flag claims submitted beyond the coverage validity window.

member external identifiermbr_ext_id

A unique reference code assigned to an insurance plan enrollee by an external system such as an employer HR platform, state Medicaid agency, or federal exchange. Used to link and reconcile member records across disparate systems during eligibility file processing, coordination of benefits, and data integration workflows.

PreviousPage 84 of 142Next