ub04_occurrence_span_view

Materialized: false

Definition

 SELECT claim.claim_id,
    span.claim_occurrence_span_index AS occurrence_span_number,
    span.occurrence_span_code,
    span.start_date,
    span.end_date
   FROM claims.claim
     JOIN claims.claim_occurrence_span span USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
occurrence_span_number	smallint	No
occurrence_span_code	text	No
start_date	date	No
end_date	date	No