claim_procedure_view

Materialized: false

Definition

 SELECT cp.claim_id,
    cp.procedure_code,
    cp.procedure_date,
    cp.icd_version,
    cp.is_principal,
    ipl.description AS procedure_description,
    hpgl.hcup_procedure_group_code,
    hpgl.description AS hcup_procedure_group_description
   FROM claims.claim_procedure cp
     LEFT JOIN claims.icd_procedure_lookup ipl ON ipl.icd_procedure_id = cp.icd_procedure_id
     LEFT JOIN claims.icd_procedure_hcup_group hpg ON hpg.icd_procedure_id = cp.icd_procedure_id
     LEFT JOIN claims.hcup_procedure_group_lookup hpgl ON hpgl.hcup_procedure_group_id = hpg.hcup_procedure_group_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