claim_occurrence

Provides information about the NUBC occurrence and occurrence span codes associated with a claim

Primary Key:

• claim_id
• claim_occurrence_index

Foreign Keys:

• claim_id => claim.claim_id

Indexes:

• claim_occurrence_claim_id_idx - claim_id
• claim_occurrence_occurrence_code_idx - occurrence_code

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
occurrence_code	text	No	Yes	-
start_date	date	Yes	No	-
end_date	date	Yes	No	-
claim_occurrence_index	smallint	No	Yes	-