Member

A classification attribute defining the tier or hierarchy of a health plan enrollee within pharmacy benefit management and healthcare systems, such as individual, family, or group. Used by data engineers to apply benefit plan rules, formulary tiers, cost-sharing logic, and population segmentation in PBM analytics and reporting pipelines.

A professional or state-issued license identifier associated with an insurance plan enrollee record, which may apply in contexts where the member holds a regulated role such as a healthcare professional enrolled in a provider-sponsored plan. Used for credentialing validation and dual-role identity reconciliation.

The Medicare Part D Low Income Subsidy program status for a health plan member, indicating eligibility for federal assistance reducing prescription drug premiums, deductibles, and cost sharing. Also known as Extra Help, the Low Income Subsidy is available to Medicare beneficiaries with limited income and resources. CMS assigns LIS levels including full subsidy and partial subsidy based on income and asset thresholds. LIS status affects pharmacy benefit cost sharing calculations, annual enrollment period rules, and risk adjustment coefficients. Healthcare data teams use mbr_lis in pharmacy benefit management systems to apply correct cost sharing at point of sale, in risk adjustment models, and in health equity analytics targeting medication adherence programs for low-income members.

The legal marital or domestic relationship status of an insurance plan enrollee, such as single, married, divorced, or widowed. Used in health plan enrollment and eligibility systems to determine dependent coverage eligibility, coordinate benefits with spousal plans, and support demographic reporting requirements.

The enterprise-level unique identifier assigned to an insurance plan enrollee across all health plan systems, enabling consistent member matching and longitudinal tracking regardless of plan changes or system migrations. Used as the primary key for cross-system data integration, analytics, and care management workflows.

The upper threshold or benefit limit value associated with an insurance plan enrollee, such as a maximum out-of-pocket amount, benefit cap, or allowable service quantity. Used in claims adjudication and utilization management to enforce plan-level benefit limits and trigger member cost-sharing calculations.

The Medicare Beneficiary Identifier assigned to each Medicare beneficiary by CMS as the primary Medicare identification number, replacing the Social Security Number-based Health Insurance Claim Number in 2019. The MBI is an 11-character alphanumeric code with a defined format: character 1 is a non-SSN digit, characters 2 and 3 are letters, character 4 is a digit, character 5 is a letter, characters 6 and 7 are digits, character 8 is a letter, character 9 is a digit, character 10 is a letter, and character 11 is a digit. The MBI is used in Medicare claims submission, eligibility verification, and CMS enrollment files. Healthcare data teams store mbr_mbi as VARCHAR(11) and validate against the CMS MBI format specification before loading into production systems.

An indicator or coded value identifying a health plan member as eligible for Medicaid benefits based on income, disability, age, or other qualifying criteria. Medicaid eligibility is determined by state agencies based on federal minimum standards and state-specific expansion decisions under the Affordable Care Act. Members who qualify for both Medicare and Medicaid are dual eligible. Medicaid eligibility affects premium assistance, cost-sharing subsidies, and eligibility for Medicaid-specific benefit programs. Healthcare data teams use mbr_mcaid_elig in enrollment data pipelines that receive eligibility files from state Medicaid agencies, in coordination of benefits processing to correctly sequence Medicare and Medicaid as primary and secondary payers, and in care management targeting for high-need populations.

The unique patient identifier assigned to an insurance plan enrollee within a specific healthcare facility or clinical system, used to link health plan enrollment data to clinical encounter records. Supports care coordination, claims reconciliation, and longitudinal patient record matching across payer and provider systems.

The full Medicare Beneficiary Identifier used in CMS administrative systems to uniquely identify Medicare beneficiaries across Part A, Part B, Part C, and Part D enrollment and claims transactions. Introduced in 2018 and fully implemented by January 2020, the Medicare Beneficiary Identifier replaced the Health Insurance Claim Number to eliminate Social Security Numbers from Medicare cards and administrative transactions. The MBI appears on Medicare cards and is required for all Medicare claims submissions and eligibility inquiries. Healthcare data teams use mbr_mbi_id as the primary key for Medicare beneficiary records, validate format compliance using CMS published validation rules, and maintain crosswalk tables linking MBI to legacy HICN values for historical data reconciliation.

The middle name or initial of a health plan enrollee stored in payer enrollment, EHR, and PBM systems. Used by data engineers during member identity resolution and deduplication processes, particularly for disambiguating members with common first and last name combinations across claims, eligibility, and pharmacy data sources.

The lower threshold or minimum required value associated with an insurance plan enrollee's benefit parameters, such as a minimum deductible met or minimum service quantity. Used in claims adjudication and benefit administration to determine when coverage obligations are triggered or cost-sharing requirements are satisfied.

The cellular phone number on file for an insurance plan enrollee, used as a primary or secondary contact channel for appointment reminders, care gap outreach, member services communications, and two-factor authentication in health plan member portals. Supports TCPA-compliant outreach programs in population health initiatives.

The system user or process identifier that last updated an insurance plan enrollee's record in the health plan administration or enrollment system. Used in audit trail tracking and data governance workflows to maintain accountability for record changes and support regulatory compliance reviews.

The timestamp recording the most recent update to a health plan enrollee's record in payer enrollment, EHR, or PBM systems. Used by data engineers to implement incremental ETL load strategies, detect retroactive eligibility changes, and track audit history for member demographic and coverage attribute modifications in data warehouse pipelines.

The date and timestamp recording when an insurance plan enrollee's record was most recently updated in the health plan enrollment or administration system. Used in data governance, audit logging, and system synchronization to track record currency and support downstream data pipeline refresh processes.

Full legal name of the health plan member as recorded in EHR, enrollment, and claims systems. Used for identity matching across PBM, payer, and provider platforms. Critical for deduplication and master patient index alignment in data pipelines.

Free-text annotation associated with a health plan enrollee, captured in care management, utilization review, and member services systems. Used by data engineers to parse unstructured clinical or administrative commentary for downstream analytics and audit trails.

Business-assigned identifier for a health plan member used for operational and external reference purposes in claims, eligibility, and provider portal systems. Distinct from internal surrogate keys; critical for cross-system reconciliation and member lookup workflows.

The date on which an insurance plan enrollee's illness, injury, or medical condition first presented or was first recognized. Used in claims adjudication, prior authorization, and disability management workflows to establish clinical timelines, validate diagnosis coding, and assess benefit eligibility based on condition start date.