claim_drg_view

Materialized: false

Definition

 SELECT claim_drg.claim_id,
    drg.drg_code,
    drg.drg_description,
    drg.mdc,
    drg.mdc_description,
    drg.medical_or_surgical,
    drg.base_drg_description,
    drg.severity,
    drg.version,
    grouped_drg.drg_code AS grouped_drg_code,
    grouped_drg.drg_description AS grouped_drg_description,
    grouped_drg.mdc AS grouped_drg_mdc,
    grouped_drg.mdc_description AS grouped_drg_mdc_description,
    grouped_drg.medical_or_surgical AS grouped_drg_medical_or_surgical,
    grouped_drg.base_drg_description AS grouped_base_drg_description,
    grouped_drg.severity AS grouped_drg_severity,
    grouped_drg.version AS grouped_drg_version
   FROM claims.claim_drg
     LEFT JOIN claims.msdrg_lookup drg ON drg.drg_id = claim_drg.drg_id
     LEFT JOIN claims.msdrg_lookup grouped_drg ON grouped_drg.drg_id = claim_drg.grouped_drg_id;

Column	Data Type	Indexed
claim_id	bigint	No
drg_code	text	No
drg_description	text	No
mdc	smallint	No
mdc_description	text	No
medical_or_surgical	medical_or_surgical_type	No
base_drg_description	text	No
severity	smallint	No
version	text	No
grouped_drg_code	text	No
grouped_drg_description	text	No
grouped_drg_mdc	smallint	No
grouped_drg_mdc_description	text	No
grouped_drg_medical_or_surgical	medical_or_surgical_type	No
grouped_base_drg_description	text	No
grouped_drg_severity	smallint	No
grouped_drg_version	text	No