ub04_occurrence_view

Materialized: false

Definition

 SELECT claim.claim_id,
    occur.claim_occurrence_index AS occurrence_number,
    occur.occurrence_code,
    occur.date
   FROM claims.claim
     JOIN claims.claim_occurrence occur USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
occurrence_number	smallint	No
occurrence_code	text	No
date	date	No