ErrorCodeInPaySourceInPrgType


Description

Error code payment source associations - Junction table linking clearing house error codes to specific payment source and program type combinations. This table manages error code applicability, enabling targeted error handling and resolution workflows based on payment source and program type contexts for billing operations.

Columns

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

Association primary key - Unique identifier for each error code-payment source association
fkErrorID int 4 √ null
ClearingHouseError.ErrorID FK_ErrorCodeInPaySourceInPrgType_ClearingHouseError R

Error code reference - Links to ClearingHouseError table for the error code
fkPrgSrcID int 4 √ null

Program source reference - Links to program source and payment source combination

Indexes

Constraint Name Type Sort Column(s)
PK_ErrorCodeInPaySourceInPrgType Primary key Asc ErrSrcID

Relationships

Close relationships within degrees of separation