claim_member_no_pii_view

A simplified member view that contains no personally identifiable information (PII) for the member. This view is intended for use in reports and other situations where PII should not be exposed.

Materialized: false

Definition

 SELECT claim_member_id,
    payer_responsibility_sequence,
    relationship_to_subscriber AS member_relationship_to_subscriber,
    group_or_policy_number,
    group_name,
    insurance_type
   FROM claims.claim_member member;

Column	Data Type	Indexed
claim_member_id	bigint	No
payer_responsibility_sequence	payer_responsibility_sequence_type	No
member_relationship_to_subscriber	individual_relationship_type	No
group_or_policy_number	text	No
group_name	text	No
insurance_type	insurance_type	No