ClaimTransVoid


Description

Claim transaction void tracking managing void operations for claim transactions with audit trail and user tracking. This table tracks when transactions are voided, who performed the void, and maintains void references to support financial integrity, audit compliance, and transaction reversal management.

Columns

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

Primary key - Unique identifier for each transaction void record
fkTransID int 4 √ null
ClaimTransaction.TransID FK__ClaimTran__fkTra__0393079E C

Transaction reference - Links to ClaimTransaction table for the voided transaction
fkVoidID int 4 √ null

Void reference - Links to void reason or void transaction
DateVoid datetime 16,3 √ (getdate())

Void date - Date and time when the transaction was voided
VoidBy int 4 √ null
AccessUser.UserID FK__ClaimTran__VoidB__04872BD7 R

Voided by user - UserID of the person who voided the transaction

Indexes

Constraint Name Type Sort Column(s)
PK__ClaimTransVoid__029EE365 Primary key Asc TransVoidID
IX_TransID Performance Asc fkTransID
IX_VoidID Performance Asc fkVoidID

Relationships

Close relationships within degrees of separation