claim_procedure_validation_view

Materialized: false

Definition

 SELECT cp.claim_id,
    cp.procedure_code,
    cp.procedure_date,
    cp.icd_version,
    cp.is_principal,
    cp.procedure_description,
    cp.hcup_procedure_group_code,
    cp.hcup_procedure_group_description,
    tp.trading_partner_id,
    s.solution_id,
    s.external_solution_id,
    s.solution_name
   FROM claims.claim c
     JOIN claims.claim_procedure_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
claim_id	bigint	No
procedure_code	text	No
procedure_date	date	No
icd_version	text	No
is_principal	boolean	No
procedure_description	text	No
hcup_procedure_group_code	smallint	No
hcup_procedure_group_description	text	No
trading_partner_id	bigint	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No