claim_diagnosis_validation_view

Materialized: false

Definition

 SELECT cd.claim_id,
    cd.diagnosis_code,
    cd.icd_version,
    cd.diagnosis_type,
    cd.present_on_admission,
    cd.diagnosis_description,
    cd.diagnosis_hcup_group,
    cd.diagnosis_hcup_group_description,
    tp.trading_partner_id,
    s.solution_id,
    s.external_solution_id,
    s.solution_name
   FROM claims.claim c
     JOIN claims.claim_diagnosis_view cd 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
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
trading_partner_id	bigint	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No