Member

The two-character USPS state abbreviation representing the state of a health plan member primary residential address. Member state code is used in geographic analytics, state-level Medicaid eligibility determination, CMS county-level capitation rate assignments for Medicare Advantage, and state-mandated benefit compliance reporting. Standard values follow USPS two-letter state codes such as CA, TX, FL, and NY plus US territory codes including PR, GU, and VI. Healthcare data teams use mbr_state_cd as a geographic partition key in Snowflake and BigQuery to improve query performance on large member tables and support state-level population health reporting.

Lifecycle status code indicating a member's current standing within pharmacy and health plan processes, such as Active, Terminated, Suspended, or Pending. Used in PBM adjudication, eligibility checks, and downstream analytics to gate claim processing and population health reporting workflows.

The assignment of a health plan member to a risk tier or acuity category based on predicted healthcare cost, clinical complexity, social needs, or care gap burden for the purpose of care management program prioritization and resource allocation. Stratification models segment members into tiers such as high risk, rising risk, moderate risk, and low risk using predictive analytics applied to claims history, pharmacy utilization, clinical assessment scores, and social determinants of health data. High-risk members receive intensive case management while rising-risk members receive targeted disease management outreach. Healthcare data teams build stratification pipelines that apply predictive risk models to member data, assign tier codes, track tier transitions over time, and feed stratification outputs to care management platforms for outreach queue prioritization and intervention tracking.

The primary residential street address of a health plan enrolled member, including house number and street name. Used in enrollment records for correspondence, care gap outreach, geographic risk stratification, and verifying service area eligibility for HMO and regional health plans.

The drug concentration or dosage strength associated with a medication dispensed or prescribed to a health plan member, expressed in units such as mg or mcg. Used in pharmacy benefit management systems to validate formulary compliance, prior authorization requirements, and drug utilization reviews.

The primary policyholder under a health insurance contract in whose name the policy is issued and who is responsible for premium payments. The subscriber is also known as the insured or enrollee. Dependents enrolled under the subscriber policy are linked through family coverage relationships. In X12 EDI 837 transactions, the subscriber is identified in the 2000B loop with the subscriber ID in the NM109 element. Healthcare data teams distinguish between subscriber and dependent records in member enrollment tables to accurately process coordination of benefits, calculate family deductible accumulation, and support CHIP and Medicaid dependent eligibility verification workflows.

The unique identifier of the primary policyholder or subscriber under whose health insurance contract a dependent member is enrolled. The subscriber ID links dependent records to the primary subscriber record and is used in coordination of benefits to establish coverage relationships, in family deductible accumulation to aggregate cost sharing across all dependents, and in claims adjudication to validate dependent eligibility under the subscriber policy. In X12 EDI 837 transactions, the subscriber ID appears in the NM109 element of the 2000B subscriber loop. Healthcare data teams maintain subscriber-dependent linkage tables using mbr_subscr_id as the foreign key connecting dependent enrollment records to primary subscriber records for family coverage analytics and eligibility verification workflows.

A partial sum of costs, utilization counts, or benefit amounts attributed to a health plan member before final adjustments, taxes, or additional line items are applied. Used in claims financial reporting, member cost-sharing calculations, and explanation of benefits statement generation.

The calendar date on which a surgical procedure was performed on a health plan member. Used in claims processing, pre-authorization tracking, post-surgical care management, and longitudinal care coordination to sequence related medical events and validate inpatient or outpatient billing timelines.

A unique system-generated identifier assigned to a health plan member within an enrollment or claims platform. Serves as the primary key for linking member records across eligibility, claims, pharmacy, and care management systems, ensuring accurate cross-platform data reconciliation.

Destination system or reference endpoint to which a member's enrollment record is transmitted or mapped within health plan data integrations. Used to track where member data flows across PBM platforms, payer systems, or data warehouses, supporting ETL validation and interface reconciliation in healthcare pipelines.

A misapplied field label; in the context of a health plan member record, this code may represent a classification grouping such as benefit category or coverage tier. Taxonomy codes standardly classify provider specialty types under NUCC guidelines and should not be applied to member demographic records.

The recorded body temperature measurement of a health plan member, typically captured during a clinical encounter. Used in clinical data integration feeds from EHR systems to support population health monitoring, disease surveillance, and value-based care quality metric tracking.

Date on which a member's health plan enrollment coverage officially ends, recorded in enrollment, claims, and PBM systems. Used by data engineers to define eligibility spans, filter active member populations, and prevent post-termination claim adjudication errors in downstream analytics and reporting.

A standardized code identifying the reason a health plan member coverage was terminated. Common termination reason codes include voluntary disenrollment where the member chose to leave the plan, non-payment of premium resulting in involuntary termination, death of the member, loss of eligibility due to age or income changes, employer group termination, plan exit from a service area, and Medicare or Medicaid eligibility changes. CMS requires specific termination reason codes for Medicare Advantage disenrollment reporting in the MARx system. Healthcare data teams use mbr_term_rsn_cd in member retention analytics to identify involuntary versus voluntary termination patterns, in CMS compliance reporting, and in premium reconciliation workflows to correctly categorize termination events for financial settlement.

Time-of-day value associated with a member-related event or transaction in health plan enrollment and PBM systems. Used in conjunction with date fields to construct full datetime records for audit logging, SLA monitoring, and chronological sequencing of member lifecycle events in healthcare data pipelines.

System-generated datetime value capturing when a member record was created, updated, or processed within compliance-sensitive healthcare workflows. Used in EHR, enrollment, and PBM platforms to support audit trails, change data capture pipelines, regulatory reporting, and data lineage tracking across integrated systems.

The formal honorific or title associated with a health plan member, such as Mr., Mrs., Dr., or similar prefix. Used in member enrollment records to support accurate personalized communications, correspondence formatting, and regulatory compliance for member-facing materials.

Aggregated sum value representing a calculated metric for a health plan member, such as total claims cost, total days of coverage, or total pharmacy fills within a defined period. Used in PBM analytics, payer reporting, and population health dashboards to summarize member-level financial or utilization data.

The aggregate count of health plan members meeting specified criteria within a defined reporting period or population segment. Used in actuarial analysis, network adequacy assessments, utilization management reporting, and population health dashboards to measure enrollment volumes and trends.