claim_occurrence

Provides information about the NUBC occurrence codes associated with a claim

Primary Key:

• claim_id
• claim_occurrence_index

Checks:

• claim_occurrence_occurrence_code_check - (occurrence_code <> ''::text)

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	Link to the associated claim record Generated through expression:
occurrence_code	text	No	Yes	NUBC occurrence codes are specific codes used on the UB-04 claim form to provide additional information about significant events or conditions that affect a patient's care and billing. For example: 01 for Date of Accident or Injury. (Loop 2300, HIxx_01 of BH / UB04 FL31-34). Generated through expression:
date	date	Yes	No	Date of the event or condition indicated by the occurrence code. (UB04 FL31-34) Generated through expression:
claim_occurrence_index	smallint	No	Yes	Order of occurrence codes found in the claim. Indexes are 0-based so the first occurrence code in the claim will have an index of 0, second will have an index of 1 and so on. Generated through expression: