claim_drg_validation_view

Materialized: false

Definition

 SELECT 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,
    drg.grouped_drg_code,
    drg.grouped_drg_description,
    drg.grouped_drg_mdc,
    drg.grouped_drg_mdc_description,
    drg.grouped_drg_medical_or_surgical,
    drg.grouped_base_drg_description,
    drg.grouped_drg_severity,
    drg.grouped_drg_version,
    tp.trading_partner_id,
    s.solution_id,
    s.external_solution_id,
    s.solution_name
   FROM claims.claim c
     JOIN claims.claim_drg_view drg 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
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
trading_partner_id	bigint	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No