claim_diagnosis_view

Materialized: false

Definition

 SELECT cd.claim_id,
    cd.diagnosis_code,
    cd.icd_version,
    cd.diagnosis_type,
    cd.present_on_admission,
    idl.description AS diagnosis_description,
    hdgl.hcup_diagnosis_group_code AS diagnosis_hcup_group,
    hdgl.description AS diagnosis_hcup_group_description
   FROM claims.claim_diagnosis cd
     LEFT JOIN claims.icd_diagnosis_lookup idl ON idl.icd_diagnosis_id = cd.icd_diagnosis_id
     LEFT JOIN claims.icd_diagnosis_hcup_group h ON h.icd_diagnosis_id = cd.icd_diagnosis_id
     LEFT JOIN claims.hcup_diagnosis_group_lookup hdgl ON hdgl.hcup_diagnosis_group_id = h.hcup_diagnosis_group_id;

Column	Data Type	Indexed
claim_id	bigint	No
diagnosis_code	text	No
icd_version	text	No
diagnosis_type	diagnosis_code_type	No
present_on_admission	yes_no_response_type	No
diagnosis_description	text	No
diagnosis_hcup_group	text	No
diagnosis_hcup_group_description	text	No