member_eligibility_basic_view

Materialized: false

Definition

 SELECT me.member_eligibility_id,
    me.subscriber_member_eligibility_id,
    s.trading_partner_submission_id,
    s.trading_partner_id,
    s.reference_number,
    s.submit_time,
    s.receive_time,
    s.file_name,
    e.eligibility_id,
    e.eligibility_plan_sponsor_name,
    e.plan_sponsor_tax_id,
    e.plan_sponsor_other_id,
    e.is_subscriber,
    e.relationship_to_subscriber,
    e.benefit_status,
    e.medicare_plan,
    e.medicare_eligibility_reason,
    e.cobra_qualifying_event,
    e.employment_status,
    e.student_status,
    e.handicap_status,
    e.death_date,
    e.confidential_access,
    e.eligibility_client_reporting_category,
    e.client_number,
    e.case_number,
    e.pin_number,
    e.cross_reference_number,
    e.personal_id_number,
    e.ncpdp_pharmacy_number,
    e.department_or_agency_number,
    e.health_insurance_claim_number,
    e."position",
    e.unit,
    e.eligibility_mutually_defined_id,
    e.enrollment_application_received,
    e.retirement,
    e.initial_disability_period_return_to_work,
    e.initial_disability_period_last_day_worked,
    e.enrollment_signature_date,
    e.cobra_qualifying_event_date,
    e.employment_begin,
    e.employment_end,
    e.medicare_begin,
    e.medicare_end,
    e.cobra_begin,
    e.cobra_end,
    e.education_begin,
    e.education_end,
    e.eligibility_begin,
    e.eligibility_end,
    e.adjusted_hire,
    e.credited_service_begin,
    e.credited_service_end,
    e.plan_participation_suspension,
    e.rehire,
    e.medicaid_begin,
    e.medicaid_end,
    e.marital_status,
    e.citizenship_status,
    e.health_situation,
    e.height,
    e.weight,
    e.disability_status,
    e.disability_begin,
    e.disability_end,
    e.eligibility_hash,
    me.prior_id_number,
    me.eligibility_maintenance_type,
    me.eligibility_maintenance_reason,
    me.eligibility_maintenance_effective_date,
    me.member_seen_id,
    me.prior_incorrect_member_seen_id
   FROM claims.member_eligibility me
     JOIN claims.trading_partner_submission s ON s.trading_partner_submission_id = me.trading_partner_submission_id
     JOIN claims.eligibility e ON e.eligibility_id = me.eligibility_id;

Column	Data Type	Indexed
member_eligibility_id	bigint	No
subscriber_member_eligibility_id	bigint	No
trading_partner_submission_id	bigint	No
trading_partner_id	bigint	No
reference_number	text	No
submit_time	timestamp	No
receive_time	timestamp	No
file_name	text	No
eligibility_id	bigint	No
eligibility_plan_sponsor_name	text	No
plan_sponsor_tax_id	text	No
plan_sponsor_other_id	text	No
is_subscriber	boolean	No
relationship_to_subscriber	individual_relationship_type	No
benefit_status	benefit_status_type	No
medicare_plan	medicare_plan_type	No
medicare_eligibility_reason	medicare_eligibility_reason_type	No
cobra_qualifying_event	cobra_qualifying_event_type	No
employment_status	employment_status_type	No
student_status	student_status_type	No
handicap_status	yes_no_response_type	No
death_date	date	No
confidential_access	confidential_access_type	No
eligibility_client_reporting_category	text	No
client_number	text	No
case_number	text	No
pin_number	text	No
cross_reference_number	text	No
personal_id_number	text	No
ncpdp_pharmacy_number	text	No
department_or_agency_number	text	No
health_insurance_claim_number	text	No
position	text	No
unit	text	No
eligibility_mutually_defined_id	text	No
enrollment_application_received	date	No
retirement	date	No
initial_disability_period_return_to_work	date	No
initial_disability_period_last_day_worked	date	No
enrollment_signature_date	date	No
cobra_qualifying_event_date	date	No
employment_begin	date	No
employment_end	date	No
medicare_begin	date	No
medicare_end	date	No
cobra_begin	date	No
cobra_end	date	No
education_begin	date	No
education_end	date	No
eligibility_begin	date	No
eligibility_end	date	No
adjusted_hire	date	No
credited_service_begin	date	No
credited_service_end	date	No
plan_participation_suspension	date	No
rehire	date	No
medicaid_begin	date	No
medicaid_end	date	No
marital_status	marital_status_type	No
citizenship_status	citizenship_status_type	No
health_situation	health_situation_type	No
height	numeric	No
weight	numeric	No
disability_status	disability_status_type	No
disability_begin	date	No
disability_end	date	No
eligibility_hash	uuid	No
prior_id_number	text	No
eligibility_maintenance_type	maintenance_type	No
eligibility_maintenance_reason	maintenance_reason_type	No
eligibility_maintenance_effective_date	date	No
member_seen_id	bigint	No
prior_incorrect_member_seen_id	bigint	No