claim_provider_validation_view

Materialized: false

Definition

 SELECT c.payer_claim_number,
    c.claim_number,
    cp.claim_id,
    cp.provider_index,
    cp.provider_type,
    cp.tpa_tax_id_suffix,
    cp.tpa_specialty_code,
    cp.taxonomy,
    cp.foreign_currency_identifier,
    cp.provider_seen_id,
    cp.entity_type,
    cp.name_last_or_organization,
    cp.name_first,
    cp.name_middle,
    cp.name_prefix,
    cp.name_suffix,
    cp.primary_id_qualifier,
    cp.address_id,
    cp.npi,
    cp.tax_id,
    cp.state_license_number,
    cp.unique_provider_identification_number,
    cp.provider_commercial_number,
    cp.location_number,
    cp.contact_name,
    cp.email_address_id,
    cp.fax_number_id,
    cp.phone_number_id,
    cp.phone_extension,
    cp.relationship_to_npi,
    cp.corrected_npi,
    cp.canonical_address_id,
    cp.canonical_primary_address_only_id,
    cp.is_invalid_address,
    cp.address1,
    cp.address2,
    cp.city,
    cp.state_or_province,
    cp.postal_code,
    cp.country_code,
    cp.country_subdivision,
    cp.phone_number,
    cp.fax_number,
    cp.email_address,
    s.solution_id,
    s.external_solution_id,
    s.solution_name
   FROM claims.claim c
     JOIN claims.claim_provider_view cp USING (claim_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
payer_claim_number	text	No
claim_number	text	No
claim_id	bigint	No
provider_index	smallint	No
provider_type	entity_identifier_type	No
tpa_tax_id_suffix	text	No
tpa_specialty_code	text	No
taxonomy	text	No
foreign_currency_identifier	text	No
provider_seen_id	bigint	No
entity_type	entity_type	No
name_last_or_organization	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
npi	bigint	No
tax_id	text	No
state_license_number	text	No
unique_provider_identification_number	text	No
provider_commercial_number	text	No
location_number	text	No
contact_name	text	No
email_address_id	bigint	No
fax_number_id	bigint	No
phone_number_id	bigint	No
phone_extension	text	No
relationship_to_npi	provider_relationship_type	No
corrected_npi	bigint	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
fax_number	text	No
email_address	text	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No