Member

The timestamp recording when the subscriber's, the primary insurance policy holder's, record was initially created in the member enrollment or claims system. Used to establish data lineage, support audit logging, and sequence enrollment or eligibility record processing.

A generic calendar date field associated with the primary insurance policyholder record in enrollment, claims, or billing systems. Context-dependent; may reference effective, termination, or transaction dates. Data engineers must validate this field's semantic meaning within source system documentation before use in ETL pipelines.

A combined date and timestamp field associated with the primary insurance policyholder in enrollment or claims systems. Captures precise transaction or event timing including time zone. Data engineers use this field for event sequencing, audit trail construction, and real-time eligibility processing across payer and EHR integration pipelines.

The Drug Enforcement Administration registration number associated with the subscriber, the primary insurance policy holder, when the subscriber is also a licensed prescriber. Used in pharmacy and credentialing systems to validate prescribing authority and controlled substance dispensing eligibility.

The recorded date of death for the primary insurance policyholder stored in enrollment, claims, and EHR systems. Triggers coverage termination workflows and survivor benefit processes. Data engineers use this field to suppress deceased members from active eligibility feeds and reconcile mortality data with Social Security death index sources.

The dollar amount the subscriber, the primary insurance policy holder, must pay out-of-pocket for covered services before the health plan begins sharing costs. Tracked in claims adjudication and member benefit systems to monitor accumulator balances throughout the plan year.

The date the subscriber's, the primary insurance policy holder's, record was marked as deleted within the member enrollment or claims system. Used for audit tracking, data retention compliance, and determining effective removal of the member from active eligibility records.

A flag indicating whether the subscriber's, the primary insurance policy holder's, record has been logically deleted from the member enrollment or claims system. Prevents the record from appearing in active eligibility queries while preserving historical data for audit and reporting purposes.

A text-based descriptive field associated with the primary insurance policyholder record in enrollment or claims systems. May capture plan type labels, group names, or classification narratives. Data engineers use this field for display purposes and cross-reference validation against coded subscriber attributes in payer and PBM databases.

Granular information associated with the primary insurance policyholder record in enrollment, claims, or billing systems. May encompass plan specifics, coverage tiers, or demographic attributes. Data engineers use subscriber detail tables to support member-level joins, benefits configuration lookups, and eligibility validation across payer and EHR platforms.

The inpatient discharge date associated with the primary insurance policyholder in hospital billing and claims systems. Used by data engineers to calculate length of stay, validate claim timelines, and support DRG-based reimbursement reconciliation across facility, payer, and EHR adjudication data pipelines.

The date by which a premium payment or financial obligation is due from the subscriber, the primary insurance policy holder. Used in member billing and premium collection systems to enforce payment deadlines, trigger grace period rules, and manage policy lapse processing.

The length of time spanning a subscriber's, the primary insurance policy holder's, enrollment period, benefit authorization, or coverage interval. Used in member analytics, utilization reporting, and actuarial modeling to assess plan engagement and continuity of coverage.

The date on which the primary insurance policyholder's coverage becomes active within enrollment and claims systems. Critical for eligibility validation, claims adjudication timelines, and coordination of benefits logic. Data engineers use this field to filter active members and establish coverage windows across payer, PBM, and EHR datasets.

Electronic mail address for the primary insurance holder (subscriber) stored in member enrollment and EHR systems. Used by data engineers to support member communications, portal authentication, and eligibility file exchanges with payers and PBM platforms.

A flag designating that a claim or service associated with the subscriber, the primary insurance policy holder, qualifies as an emergency under plan benefit rules. Triggers expedited claims adjudication, waived prior authorization requirements, and application of emergency cost-sharing provisions.

The date on which a subscriber's active enrollment period terminates within member eligibility systems. Critical for data engineers processing 834 EDI transactions, calculating coverage gaps, and ensuring downstream claims adjudication systems reflect accurate enrollment windows.

The precise time at which a service encounter, authorization period, or enrollment transaction concluded for the subscriber, the primary insurance policy holder. Used in member management and claims systems to calculate service duration and establish exact coverage or transaction boundaries.

The current membership state of the subscriber, the primary insurance policy holder, within the health plan. Indicates whether the subscriber is actively enrolled, terminated, suspended, or pending, and governs eligibility determinations for claims adjudication and benefit access.

The username or identifier of the individual who manually entered the subscriber's, the primary insurance policy holder's, data into the member enrollment or claims system. Supports audit trail requirements, data quality review, and accountability tracking for enrollment record creation.