claim_occurrence_view

Materialized: false

Definition

 SELECT o.claim_id,
    o.claim_occurrence_index,
    o.occurrence_code,
    o.date,
    n.title
   FROM claims.claim_occurrence o
     LEFT JOIN claims.nubc_occurrence_lookup n ON n.occurrence_code = o.occurrence_code;

Column	Data Type	Indexed
claim_id	bigint	No
claim_occurrence_index	smallint	No
occurrence_code	text	No
date	date	No
title	text	No