ub04_condition_view

Materialized: false

Definition

 SELECT claim.claim_id,
    t.condition_code_idx AS condition_number,
    t.condition_code
   FROM claims.claim
     CROSS JOIN LATERAL unnest(claim.condition_codes) WITH ORDINALITY t(condition_code, condition_code_idx)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
condition_number	bigint	No
condition_code	text	No