Back to Glossary

Domain

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

member faxmbr_fax

The facsimile telephone number associated with an insurance plan enrollee, captured as part of their contact information in the enrollment system. Used for transmitting clinical authorizations, explanation of benefits documents, and plan correspondence when secure fax remains the preferred or required communication method.

member feembr_fee

A specific charge assessed to an insurance plan enrollee for plan participation, administrative services, or supplemental benefits outside of standard premium obligations. Tracked in member billing and financial systems to support accounts receivable reconciliation, fee schedule administration, and member ledger accuracy.

member first namembr_first_nm

The given (first) name of a health plan member as stored in EHR, enrollment, and claims systems. Used by data engineers to match member records across PBM, eligibility, and provider systems where name formatting and case sensitivity may vary.

member flagmbr_flg

A boolean indicator used in utilization management and healthcare analytics systems to mark specific member conditions, program eligibility, or processing rules. Data engineers apply this flag in ETL logic, population segmentation, care management enrollment workflows, and downstream utilization reporting pipelines across payer platforms.

member frequencymbr_freq

The dosing or service frequency interval assigned to an insurance plan enrollee, indicating how often a prescribed treatment, medication, or clinical service is administered. Used in pharmacy benefit management and care management workflows to support adherence monitoring and utilization review.

member full namembr_full_nm

The concatenated complete name of a health plan enrollee, typically combining first, middle, and last name fields stored in enrollment and EHR systems. Used by data engineers for member display records, identity verification during cross-system matching, and generation of member-facing documents within payer reporting platforms.

member gendermbr_gndr

The biological sex or gender identity classification recorded for an insurance plan enrollee in the health plan enrollment system. Used in claims adjudication, clinical decision support, and population health analytics to support gender-specific benefit eligibility, coding rules, and demographic reporting.

member group namembr_grp_nm

The descriptive name of the employer group, union, association, or plan sponsor under whose group health insurance contract a member is enrolled. Member group name is used alongside the group number to identify the sponsoring organization in enrollment and billing systems. Group names appear on member ID cards, explanation of benefits documents, and employer billing statements. In self-funded employer plans, the group name identifies the employer as the plan sponsor and risk-bearing entity. Healthcare data teams use mbr_grp_nm in member enrollment tables as a human-readable reference to the group identifier, in employer group reporting for utilization and cost analytics, and in member communications to correctly identify the sponsoring organization on member-facing documents.

member group numbermbr_grp_nbr

The insurance group identifier assigned to an enrollee that links them to a specific employer-sponsored or sponsored benefits plan. Used in eligibility verification, claims adjudication, and enrollment systems to associate members with the correct benefit group and coverage tier.

member hicnmbr_hicn

The Health Insurance Claim Number previously used as the primary Medicare beneficiary identifier, consisting of the Social Security Number followed by a suffix indicating the type of Medicare entitlement. CMS retired the HICN in 2019 and replaced it with the Medicare Beneficiary Identifier to reduce identity theft risk associated with SSN-based identifiers. However, HICN values remain present in historical claims data and legacy systems predating the MBI transition. Healthcare data teams maintaining historical Medicare data must map between HICN and MBI using CMS crosswalk files, mask HICN values as PHI in non-production environments, and document the transition date in data lineage metadata to avoid confusion between legacy and current identifier formats.

member history present illnessmbr_hpi

A structured narrative describing the chronological development of a health plan enrollee's presenting condition, including symptom onset, duration, and progression. Captured during clinical encounters and stored in medical records to provide clinical context for diagnosis coding and care coordination.

member identifiermbr_id

The member identifier (mbr_id) is the unique identifier assigned to an individual enrolled in a health plan, used to link that member's eligibility, enrollment, claims, pharmacy, laboratory, and care management records across all data systems. The member ID is assigned by the health plan and may differ from the subscriber ID when the covered person is a dependent rather than the primary policyholder. In HIPAA 837 transactions, the member ID appears in the NM109 element of the subscriber and patient NM1 segments. Medicare beneficiaries have a Medicare Beneficiary Identifier (MBI) — an alphanumeric code that replaced the Social Security Number-based Health Insurance Claim Number (HICN) in 2019 as the primary Medicare member identifier. The member identifier is the primary key of the member dimension table and the most critical linkage key in a healthcare data warehouse. Every claim, pharmacy fill, lab result, care gap record, and care management touchpoint must link to a single member record to enable longitudinal member analytics — without reliable member ID linkage, population health management, care gap identification, and risk stratification are impossible. Member ID management is complicated by the fact that members re-enroll after coverage gaps, switch between plans within the same organization, and may receive different IDs from different source systems (payer claims system, care management platform, pharmacy benefit manager). Healthcare data engineers store mbr_id as VARCHAR(50) to handle the full range of member identifier formats, which vary significantly across payers and government programs. When a member appears in multiple source systems with different identifiers, probabilistic matching on demographic attributes (last name, date of birth, sex, zip code) is used to link records to a single master member ID in the member master data management (MDM) layer. Key data quality rules include: mbr_id must be non-null on all claim records, the member must have an active eligibility record on the date of service, and demographic data on the claim must match the eligibility record within defined tolerance thresholds. Enrollment gaps — periods where a member has no active coverage — must be explicitly modeled using effective and termination dates rather than a single status flag, enabling accurate member-months denominators for utilization and cost analytics.

member indexmbr_idx

A positional or sequential numeric value assigned to a health plan enrollee within enrollment and payer administrative systems. Used by data engineers for array-based member record retrieval, batch processing sequencing, and identifying member order within family or group enrollment structures in downstream analytics pipelines.

member indicatormbr_ind

A binary yes/no flag used across payer, EHR, and PBM systems to denote whether a record pertains to an active health plan enrollee or satisfies a specific member condition. Data engineers use this field to filter populations, enforce business rules in ETL processes, and segment members for eligibility and utilization reporting.

member instructionmbr_instr

Free-text or coded guidance associated with a health plan enrollee's care or administrative record, stored in EHR, care management, and payer systems. Used by data engineers to surface special handling directives during claims processing, care coordination workflows, and member communication automation in payer data platforms.

member keymbr_key

A surrogate foreign key used in healthcare data warehouse schemas to reference the member dimension table from fact tables including claims, pharmacy, and utilization records. Assigned during ETL processing, this key enables efficient star schema joins across enrollment, EHR, and PBM data marts without relying on source system natural keys.

member labelmbr_lbl

A human-readable display text or tag associated with an insurance plan enrollee record, used to identify or categorize the member within health plan administration systems. Supports workflow routing, member segmentation, and program assignment in care management and population health platforms.

member languagembr_lang

The preferred spoken or written language recorded for an insurance plan enrollee, used to ensure appropriate communication during clinical encounters, member services interactions, and care coordination. Supports compliance with CMS language access requirements and drives translation service utilization in health plan operations.

member last namembr_last_nm

The family or surname of a health plan enrollee as captured in payer enrollment, EHR, and PBM systems. Data engineers use this field for member identity resolution, probabilistic and deterministic record linkage across claims and eligibility platforms, and compliance with HIPAA demographic data transmission standards in 834 enrollment files.

member legal namembr_legal_nm

The officially registered full name of an insurance plan enrollee as documented on government-issued identification, used in health plan enrollment, claims processing, and eligibility verification. Ensures accurate member matching across systems and supports regulatory compliance in identity verification workflows.

PreviousPage 85 of 142Next