member_coverage_basic_view

Materialized: false

Definition

 SELECT mc.member_coverage_id,
    mc.member_eligibility_id,
    c.coverage_id,
    c.insurance_line,
    c.coverage_description,
    c.coverage_level,
    c.is_late_enrollee,
    c.premium_paid_to_date_end,
    c.benefit_begin,
    c.benefit_end,
    c.last_premium_paid_date,
    c.previous_period,
    c.coinsurance,
    c.copay,
    c.deductible,
    c.expected_expenditure_amount,
    c.other_unlisted_amount,
    c.premium_amount,
    c.spend_down,
    c.coverage_client_reporting_category,
    c.group_or_policy_number_global_ref38,
    c.group_or_policy_number_eligibility_ref1l,
    c.group_or_policy_number,
    c.group_name,
    c.medical_plan_identification_code,
    c.medical_plan_name,
    c.bin,
    c.rx_group,
    c.pcn,
    c.rx_plan_identification_code,
    c.rx_plan_name,
    c.payment_category,
    c.class_of_contract_code,
    c.service_contract_coverage_number,
    c.medical_assistance_category,
    c.program_identification_number,
    c.prior_coverage_months,
    c.rate_code_number,
    c.internal_control_number,
    c.issuer_number,
    c.special_program_code,
    c.service_area_code,
    c.county_code,
    c.coverage_mutually_defined_id,
    c.coverage_hash,
    mc.coverage_maintenance_type,
    mc.coverage_maintenance_effective_date,
    mc.coverage_group_or_plan_id
   FROM claims.member_coverage mc
     JOIN claims.coverage c ON c.coverage_id = mc.coverage_id;

Column	Data Type	Indexed
member_coverage_id	bigint	No
member_eligibility_id	bigint	No
coverage_id	bigint	No
insurance_line	insurance_line_type	No
coverage_description	text	No
coverage_level	coverage_level_type	No
is_late_enrollee	boolean	No
premium_paid_to_date_end	date	No
benefit_begin	date	No
benefit_end	date	No
last_premium_paid_date	date	No
previous_period	date	No
coinsurance	numeric	No
copay	numeric	No
deductible	numeric	No
expected_expenditure_amount	numeric	No
other_unlisted_amount	numeric	No
premium_amount	numeric	No
spend_down	numeric	No
coverage_client_reporting_category	text	No
group_or_policy_number_global_ref38	text	No
group_or_policy_number_eligibility_ref1l	text	No
group_or_policy_number	text	No
group_name	text	No
medical_plan_identification_code	text	No
medical_plan_name	text	No
bin	text	No
rx_group	text	No
pcn	text	No
rx_plan_identification_code	text	No
rx_plan_name	text	No
payment_category	text	No
class_of_contract_code	text	No
service_contract_coverage_number	text	No
medical_assistance_category	text	No
program_identification_number	text	No
prior_coverage_months	text	No
rate_code_number	text	No
internal_control_number	text	No
issuer_number	text	No
special_program_code	text	No
service_area_code	text	No
county_code	text	No
coverage_mutually_defined_id	text	No
coverage_hash	uuid	No
coverage_maintenance_type	maintenance_type	No
coverage_maintenance_effective_date	date	No
coverage_group_or_plan_id	bigint	No