claimQueueHistory


Description

Claim queue processing history maintaining historical records of claim queue processing activities. This audit table tracks when claims were processed, checked out, and archived from the processing queue, supporting workflow analysis, processing time tracking, and queue management reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
checkClaimID int 4 √ null

Claim reference - Links to Claim table for the processed claim
checkedOut int 4 √ null

Checked out flag - Indicates if claim was checked out when archived
DateArchived datetime 16,3 √ null

Archive date - Date when the claim queue record was archived

Relationships

Close relationships within degrees of separation