Back to Glossary

Domain

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

member review systemsmbr_ros

Documents the review of body systems conducted during a clinical encounter for a health plan enrollee, consistent with standard history and physical documentation requirements. Used in clinical coding and quality review to support evaluation and management level determinations and care gap identification.

member revisionmbr_rev

Tracks the version or iteration number of a member's enrollment record, benefit election, or demographic profile following an update or correction. Used in enrollment management systems to maintain an audit trail of changes to member data and ensure the most current record is applied in downstream processing.

member riskmbr_rsk

A composite assessment of a health plan enrollee's clinical, behavioral, or social risk level, often derived from claims history, diagnosis codes, or health risk assessments. Used in care management programs, risk stratification models, and value-based contract reporting to prioritize outreach and intervention.

member risk adjustmentmbr_rsk_adj

The process and associated data elements used to calculate and submit a health plan member predicted cost risk to CMS for Medicare Advantage and ACA marketplace capitation payment purposes. Risk adjustment corrects for differences in member health status across plans by adjusting payments upward for sicker members and downward for healthier members, preventing adverse selection and ensuring plans are fairly compensated for enrolling high-risk populations. The risk adjustment process involves diagnosis code submission through RAPS and EDPS systems, HCC mapping, RAF score calculation, and reconciliation payment settlements. Healthcare data teams build risk adjustment data pipelines that validate ICD-10 diagnosis submissions, map diagnoses to HCC categories using CMS mapping files, calculate preliminary RAF scores, and produce audit-ready data submissions meeting CMS risk adjustment data validation requirements.

member risk scorembr_rsk_scr

A quantitative value predicting a health plan member expected healthcare costs relative to an average population benchmark. Risk scores are calculated from demographic factors and diagnosis history using actuarial models such as CMS-HCC for Medicare Advantage and HHS-HCC for ACA marketplace plans. A risk score of 1.0 represents average expected cost. Scores above 1.0 indicate higher predicted utilization. Healthcare data teams build risk score calculation pipelines that process diagnosis submissions through CMS HCC mapping tables, calculate demographic and condition category coefficients, and produce member-level RAF scores used in capitation payment calculations, care management prioritization, and population health stratification.

member routembr_rte

Specifies the channel or pathway through which a health plan enrollee accesses services or communications, such as mail-order pharmacy, telehealth, or in-network facility. Used in care coordination and pharmacy benefit management systems to direct services appropriately and apply correct cost-sharing rules.

member scheduled datembr_sched_dt

The date on which a health-related appointment, procedure, or care management activity is scheduled for a health plan enrollee. Used in utilization management and care coordination systems to track upcoming services, manage authorization expiration, and monitor gaps in preventive or follow-up care.

member scheduled timembr_sched_tm

The specific time of day at which a health-related appointment or care activity is scheduled for a health plan enrollee. Used alongside the scheduled date in care coordination, outreach, and utilization management systems to manage workflows and ensure timely member engagement and service delivery.

member scorembr_scr

A calculated numeric rating assigned to a health plan enrollee, such as a risk score, health risk assessment score, or quality measure score in analytics and care management systems. Used by data engineers to drive member stratification, predictive modeling, and value-based care reporting.

member sequencembr_seq

An ordering number assigned to a health plan enrollee record, used to distinguish multiple occurrences of member-level data such as multiple coverage spans, addresses, or benefit elections in enrollment systems. Critical for data engineers managing record versioning and temporal data loads.

member service datembr_svc_dt

The calendar date on which a health plan enrollee received a clinical or administrative service, as recorded in claims, EHR, and care management systems. Used by data engineers to anchor episode-of-care analysis, HEDIS measure attribution, and longitudinal utilization reporting.

member severitymbr_sev

A clinical or administrative indicator of the seriousness of a health plan enrollee's condition, used in utilization management, case management, and risk stratification systems. Supports data engineers in building acuity-based segmentation models and prioritizing care intervention workflows.

member sexmbr_sex

Records the biological sex assigned at birth for a health plan enrollee, typically as male, female, or unknown. Used in claims adjudication, clinical editing, eligibility determination, and population health analytics to apply sex-specific benefit rules, screening guidelines, and quality measure criteria.

member snpmbr_snp_typ_cd

A coded value identifying the type of Medicare Advantage Special Needs Plan in which a member is enrolled. CMS authorizes three types of Special Needs Plans: Chronic Condition Special Needs Plans for members with specific severe chronic conditions, Dual Eligible Special Needs Plans for members with both Medicare and Medicaid eligibility, and Institutional Special Needs Plans for members residing in long-term care facilities. Each SNP type has distinct eligibility requirements, benefit structures, and care management obligations. Healthcare data teams use mbr_snp_typ_cd in enrollment validation to confirm members meet SNP eligibility criteria, in care management program assignment to route members to appropriate disease management services, and in CMS bid and enrollment reporting.

member social security numbermbr_ssn

The nine-digit Social Security Number assigned to a health plan member by the Social Security Administration, used historically as a primary identifier in Medicare and Medicaid enrollment systems. The SSN is among the most sensitive categories of Protected Health Information under HIPAA and is subject to strict access controls, encryption requirements, and masking in non-production environments. CMS phased out SSN-based identifiers in Medicare by replacing the Health Insurance Claim Number with the Medicare Beneficiary Identifier in 2019. State Medicaid programs increasingly use alternative identifiers to reduce SSN exposure. Healthcare data teams must implement column-level security, dynamic data masking in Snowflake and BigQuery, and audit logging for any system accessing mbr_ssn to comply with HIPAA minimum necessary standards and reduce identity theft risk.

member sourcembr_src

Originating system or feed that introduced a member record into the health plan enrollment database. Identifies whether the member was loaded via employer group file, exchange enrollment, Medicaid transfer, or manual entry. Essential for ETL lineage tracking and reconciliation across PBM and payer systems.

member special enrollment periodmbr_sep

A defined window outside of regular open enrollment during which a health plan member may enroll in or change coverage due to a qualifying life event. Special enrollment period triggers include loss of other coverage, marriage, divorce, birth or adoption of a child, change in residence, and loss of Medicaid eligibility. CMS mandates specific special enrollment period windows for Medicare Advantage members experiencing qualifying events. Healthcare data teams process special enrollment period transactions with strict effective date logic tied to the qualifying event date, validate supporting documentation requirements, and maintain audit trails for CMS compliance reviews of enrollment outside standard open enrollment periods.

member start datembr_start_dt

Effective start date of a member's enrollment period within a health plan, used in EHR, claims, and PBM systems to determine coverage eligibility windows. Data engineers use this field to filter active membership spans and join eligibility records to claims and pharmacy transactions accurately.

member start timembr_start_tm

The recorded time at which a clinical encounter, care management session, or service delivery event began for a health plan enrollee. Used alongside end time in utilization tracking, provider billing validation, and care management documentation to calculate service duration and support audit requirements.

member statembr_st

The two-letter state or province code recorded in the health plan enrollment record for an insured member. Used in member eligibility files, claims adjudication, and network adequacy analysis to determine applicable state regulations, benefit mandates, and plan jurisdiction.

PreviousPage 89 of 142Next