Member

The date on which a healthcare claim was submitted to the health plan on behalf of an enrolled member for services rendered. Used in claims adjudication systems to establish filing timeliness, apply timely filing edits, and sequence claim processing within the member's benefit period.

Indicates the current processing state of a healthcare claim submitted for an enrolled member, such as received, in adjudication, paid, denied, or pended for additional information. Used in claims management systems to track workflow progression and communicate adjudication outcomes to members and providers.

The classification tier assigned to an insurance plan enrollee indicating their benefit plan structure, coverage level, or eligibility group within payer and enrollment systems. Sourced from 834 transactions and group master files, data engineers use this field to apply correct benefit rules, route claims adjudication logic, and support tiered premium and cost-sharing calculations.

An indicator identifying a health plan member enrolled under the Consolidated Omnibus Budget Reconciliation Act continuation coverage provision, which allows employees and their dependents to temporarily continue group health coverage after qualifying events such as job loss, reduction in work hours, divorce, or death of the covered employee. COBRA coverage is identical to the prior employer group coverage but the member pays the full premium including the employer contribution plus a two percent administrative fee. COBRA coverage duration is typically 18 months for employment termination or reduction in hours and up to 36 months for other qualifying events. Healthcare data teams use mbr_cobra_ind to correctly classify premium billing as member-paid rather than employer-subsidized, apply COBRA-specific enrollment period rules, and track COBRA election and premium payment status for coverage continuity management.

A unique alphanumeric identifier assigned to an insurance plan enrollee within the payer's administrative system, referenced in Loop 2010BA of the 837 transaction set and eligibility files. Data engineers use this field as a primary key for member-level joins across claims, enrollment, pharmacy, and care management datasets to ensure accurate longitudinal member record linkage.

The percentage of covered healthcare costs a health plan member pays after meeting the deductible, with the insurance plan paying the remaining share. For example, an 80/20 coinsurance split means the plan pays 80 percent and the member pays 20 percent of the allowed amount. Coinsurance rates vary by service type, network status, and benefit tier. Unlike copays, coinsurance is percentage-based and therefore varies with the cost of the service. Healthcare data teams use mbr_coins in claims adjudication to calculate member liability after deductible application, generate accurate explanation of benefits statements, and model the financial impact of benefit design changes on member cost-sharing obligations.

The dollar amount representing the member's percentage-based share of costs for a covered healthcare service after the deductible has been met, calculated from the plan's allowed amount. Recorded during claims adjudication to determine member financial liability and populate explanation of benefits documents.

A free-text notation field associated with an insurance plan enrollee's record in payer, EHR, or care management systems, capturing administrative notes, exceptions, or case-specific context. Data engineers must handle this field carefully during ETL due to unstructured content, applying NLP or exclusion logic to prevent PHI exposure in downstream analytics and reporting pipelines.

The date on which a healthcare service, care management activity, authorization, or enrollment transaction was fully completed for a health plan member. Used across utilization management, care coordination, and enrollment systems to close workflow items and measure time-to-completion against service standards.

A privacy protection flag in member enrollment systems that identifies enrollees requiring restricted access to their demographic, claims, or clinical data. Commonly set for sensitive conditions such as behavioral health, substance abuse, or reproductive care per HIPAA and state privacy regulations.

The communication point — phone number, email, or preferred contact method — associated with an insurance plan enrollee, sourced from 834 enrollment files or member portal registrations in payer and EHR systems. Data engineers use this field to support outreach program integration, care gap notification workflows, and member engagement analytics across population health platforms.

A general indicator or coded value identifying a health plan member whose coverage is being maintained through a continuation of coverage provision following a qualifying event that would otherwise terminate insurance. Continuation coverage includes federal COBRA provisions, state mini-COBRA laws for smaller employers not subject to federal COBRA, conversion policies allowing group-to-individual plan conversion, and portability provisions under HIPAA. Continuation coverage ensures members maintain access to healthcare benefits during transitions between employment or life circumstances. Healthcare data teams use mbr_cont_cov in enrollment systems to flag members with non-standard premium billing arrangements, apply correct termination date logic for continuation periods, and ensure claims adjudication systems recognize continuation coverage members as eligible for benefits despite no active employer group sponsorship.

The fixed dollar amount a health plan member pays out-of-pocket at the point of service for covered healthcare encounters such as primary care visits, specialist visits, emergency room visits, or prescription fills. Copays are defined in the plan benefit design and vary by service type and network tier. In most plan structures copays do not count toward the deductible but do count toward the annual out-of-pocket maximum. CMS regulates maximum copay amounts for certain Medicare Advantage services. Healthcare data teams use mbr_cpay in claims adjudication to calculate member cost-sharing liability, explanation of benefits generation, and benefit design analytics to model utilization impact of copay structure changes.

The fixed out-of-pocket dollar amount an insurance plan enrollee is required to pay at the point of service for a covered benefit. Captured on medical and pharmacy claims to calculate member cost-sharing obligations and reconcile against plan benefit design and Explanation of Benefits.

The total financial responsibility attributed to an insurance plan enrollee for healthcare services rendered, including copays, coinsurance, and deductible contributions. Used in claims adjudication and member billing to determine net amounts owed after plan payment calculations are applied.

The total out-of-pocket cost obligation a health plan member is responsible for paying for covered healthcare services, encompassing all forms of cost sharing including deductibles, copayments, and coinsurance. Member cost sharing is a core benefit design element that affects healthcare utilization patterns, member financial burden, and plan actuarial value calculations under ACA metal tier requirements. CMS sets maximum out-of-pocket limits for Medicare Advantage plans annually. Healthcare data teams build cost sharing accumulator pipelines that track deductible, copay, and coinsurance payments chronologically throughout the plan year to determine member liability at each point of service and identify when members reach their out-of-pocket maximum.

An aggregate numeric value representing the total number of insurance plan enrollees within a defined cohort, plan, employer group, or time period in payer and enrollment systems. Data engineers use this field for premium reconciliation, capitation payment calculations, CMS reporting submissions, and actuarial trend analysis across membership and claims data warehouses.

The country of residence or citizenship associated with an insurance plan enrollee, captured during enrollment or demographic updates. Used in eligibility management to determine coverage jurisdiction, apply international benefit rules, and support coordination of benefits for globally mobile members.

The county or county-equivalent geographic area associated with a health plan member primary residential address. Member county is a critical geographic unit in Medicare Advantage because CMS sets capitation base payment rates at the county level through annual rate announcements. County-level data also supports network adequacy analysis, geographic access to care studies, and social determinants of health analytics by linking to county-level census and deprivation index data. Healthcare data teams store mbr_cnty using FIPS county codes as VARCHAR(5) to support standardized geographic joins across CMS rate files, census data, and member enrollment tables.

The scope of healthcare benefits and services a member is entitled to receive under their health plan contract. Member coverage defines which services are covered, applicable cost-sharing, network restrictions, and prior authorization requirements. Coverage details are stored in benefit plan tables linked to member enrollment records. Healthcare data teams use mbr_cov in claims adjudication to validate that billed services fall within covered benefits, in care gap analytics to identify missing preventive services, and in member communication systems to generate accurate explanation of benefits statements and plan comparison reports.