claim_member_validation_view

Provides all the fields from claim_member_view and adds additional claim, trading partner, and solution data for easier data validation

Materialized: false

Definition

 SELECT member.claim_member_id,
    member.payer_responsibility_sequence,
    member.relationship_to_subscriber,
    member.group_or_policy_number,
    member.group_name,
    member.insurance_type,
    member.claim_filing_indicator,
    member.member_subscriber_or_patient_id,
    member.member_ssn,
    member.member_identification_code,
    member.individual_health_identifier,
    member.insurer_payer_id,
    member.patient_subscriber_or_patient_id,
    member.member_canonical_id_chosen,
    member.member_canonical_id_chosen_at,
    member.member_canonical_id_chosen_by,
    member.member_match_status,
    member.member_address_id,
    member.member_date_of_birth,
    member.member_name_prefix,
    member.member_name_first,
    member.member_name_middle,
    member.member_name_last,
    member.member_name_suffix,
    member.member_gender_or_sex,
    member.member_address1,
    member.member_address2,
    member.member_city,
    member.member_state_or_province,
    member.member_postal_code,
    member.member_phone_number,
    member.patient_name_prefix,
    member.patient_name_first,
    member.patient_name_middle,
    member.patient_name_last,
    member.patient_name_suffix,
    member.patient_gender_or_sex,
    member.patient_address1,
    member.patient_address2,
    member.patient_city,
    member.patient_state_or_province,
    member.patient_postal_code,
    member.patient_date_of_birth,
    member.patient_phone_number,
    c.claim_number,
    c.payer_claim_number,
    tp.trading_partner_id,
    s.solution_id,
    s.external_solution_id,
    s.solution_name
   FROM claims.claim c
     JOIN claims.claim_member_view member ON member.claim_member_id = c.claim_member_id
     JOIN claims.trading_partner_submission submission USING (trading_partner_submission_id)
     JOIN claims.trading_partner tp USING (trading_partner_id)
     JOIN claims.solution s USING (solution_id);

Column	Data Type	Indexed
claim_member_id	bigint	No
payer_responsibility_sequence	payer_responsibility_sequence_type	No
relationship_to_subscriber	individual_relationship_type	No
group_or_policy_number	text	No
group_name	text	No
insurance_type	insurance_type	No
claim_filing_indicator	claim_filing_indicator_type	No
member_subscriber_or_patient_id	bigint	No
member_ssn	text	No
member_identification_code	text	No
individual_health_identifier	text	No
insurer_payer_id	bigint	No
patient_subscriber_or_patient_id	bigint	No
member_canonical_id_chosen	bigint	No
member_canonical_id_chosen_at	date	No
member_canonical_id_chosen_by	bigint	No
member_match_status	match_status_type	No
member_address_id	bigint	No
member_date_of_birth	date	No
member_name_prefix	text	No
member_name_first	text	No
member_name_middle	text	No
member_name_last	text	No
member_name_suffix	text	No
member_gender_or_sex	gender_or_sex_type	No
member_address1	text	No
member_address2	text	No
member_city	text	No
member_state_or_province	text	No
member_postal_code	text	No
member_phone_number	text	No
patient_name_prefix	text	No
patient_name_first	text	No
patient_name_middle	text	No
patient_name_last	text	No
patient_name_suffix	text	No
patient_gender_or_sex	gender_or_sex_type	No
patient_address1	text	No
patient_address2	text	No
patient_city	text	No
patient_state_or_province	text	No
patient_postal_code	text	No
patient_date_of_birth	date	No
patient_phone_number	text	No
claim_number	text	No
payer_claim_number	text	No
trading_partner_id	bigint	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No