ub04_diagnosis_view

Materialized: false

Definition

 SELECT claim.claim_id,
        CASE diag.diagnosis_type
            WHEN 'Principal'::claims.diagnosis_code_type THEN 'Principal'::text
            WHEN 'Admitting'::claims.diagnosis_code_type THEN 'Admitting'::text
            WHEN 'Patient Reason for Visit'::claims.diagnosis_code_type THEN 'PR-'::text || diag.claim_diagnosis_index
            WHEN 'External Cause of Injury'::claims.diagnosis_code_type THEN 'ECI-'::text || diag.claim_diagnosis_index
            WHEN 'Other'::claims.diagnosis_code_type THEN 'OTH-'::text || diag.claim_diagnosis_index
            ELSE NULL::text
        END AS diagnosis_code_qualifier,
    diag.diagnosis_code,
    diag.present_on_admission
   FROM claims.claim
     JOIN claims.claim_diagnosis diag USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
diagnosis_code_qualifier	text	No
diagnosis_code	text	No
present_on_admission	yes_no_response_type	No