claim_occurrence_span

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

Primary Key:

• claim_id
• claim_occurrence_span_index

Checks:

• claim_occurrence_span_occurrence_span_code_check - (occurrence_span_code <> ''::text)

Foreign Keys:

• claim_id => claim.claim_id

Indexes:

• claim_occurrence_span_claim_id_idx - claim_id
• claim_occurrence_span_occurrence_code_idx - occurrence_span_code

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Link to the associated claim record Generated through expression:
claim_occurrence_span_index	smallint	No	Yes	Order of occurrence span codes found in the claim. Indexes are 0-based so the first occurrence span code in the claim will have an index of 0, second will have an index of 1 and so on. Generated through expression:
occurrence_span_code	text	No	Yes	NUBC occurrence span 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: 71 for Prior stay dates. (Loop 2300, HIxx_01 of BI / UB04 FL35-36). Generated through expression:
start_date	date	Yes	No	Start date of the event or condition indicated by the occurrence span code. (UB04 FL35-36) Generated through expression:
end_date	date	Yes	No	End date of the event or condition indicated by the occurrence span code. (UB04 FL35-36) Generated through expression: