subscriber_or_patient_view

Materialized: false

Definition

 SELECT p.subscriber_or_patient_id,
    p.name_last,
    p.name_first,
    p.name_middle,
    p.name_prefix,
    p.name_suffix,
    p.primary_id_qualifier,
    p.address_id,
    p.date_of_birth,
    p.gender_or_sex,
    p.contact_name,
    p.phone_number_id,
    p.phone_extension,
    a.canonical_address_id,
    a.canonical_primary_address_only_id,
    a.is_invalid_address,
    a.address1,
    a.address2,
    a.city,
    a.state_or_province,
    a.postal_code,
    a.country_code,
    a.country_subdivision,
    ph.phone_number
   FROM claims.subscriber_or_patient p
     LEFT JOIN claims.address_seen a ON a.address_id = p.address_id
     LEFT JOIN claims.phone ph ON ph.phone_id = p.phone_number_id;

Column	Data Type	Indexed
subscriber_or_patient_id	bigint	No
name_last	text	No
name_first	text	No
name_middle	text	No
name_prefix	text	No
name_suffix	text	No
primary_id_qualifier	identification_type	No
address_id	bigint	No
date_of_birth	date	No
gender_or_sex	gender_or_sex_type	No
contact_name	text	No
phone_number_id	bigint	No
phone_extension	text	No
canonical_address_id	bigint	No
canonical_primary_address_only_id	bigint	No
is_invalid_address	boolean	No
address1	text	No
address2	text	No
city	text	No
state_or_province	text	No
postal_code	text	No
country_code	text	No
country_subdivision	text	No
phone_number	text	No