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 |