ub04_procedure_view

Materialized: false

Definition

 SELECT claim.claim_id,
        CASE proc.is_principal
            WHEN true THEN 'Principal'::text
            ELSE 'OTH-'::text || proc.claim_procedure_index
        END AS procedure_type_qualifier,
    proc.procedure_code,
    proc.procedure_date
   FROM claims.claim
     JOIN claims.claim_procedure proc USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
procedure_type_qualifier	text	No
procedure_code	text	No
procedure_date	date	No