Claimerror


Description

Claim error tracking managing errors and validation issues identified during claim processing and submission. This table tracks claim errors from various sources including clearinghouse rejections, internal validation failures, and business rule violations to support error resolution and claim reprocessing workflows.

Columns

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

Claim error ID - Identifier for the specific error type
claimid int 4 null
Claim.ClaimID FK_claimerror_Claim C

Claim reference - Links to Claim table for the claim with errors
ERID int 4 √ null

Error reference ID - Links to error definition or clearinghouse error code
pkClaimErrorID int identity 4 √ null

Primary key - Unique identifier for each claim error record

Indexes

Constraint Name Type Sort Column(s)
PK_Claimerror Primary key Asc pkClaimErrorID
CLAIMID_INX Performance Asc claimid
IX_claimerror Performance Asc claimerrorid

Relationships

Close relationships within degrees of separation