ClaimTransaction


Description

Claim financial transactions tracking all financial activities and status changes for individual claims. This table maintains a complete audit trail of claim processing including payments, adjustments, voids, and other financial transactions throughout the claim lifecycle.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransID int identity 4 √ null
ClaimTransCheck.fkTransID FK__ClaimTran__fkTra__0C284D9F C
ClaimTransInvoice.fkTransID FK__ClaimTran__fkTra__0857BCBB C
ClaimTransVoid.fkTransID FK__ClaimTran__fkTra__0393079E C

Primary key - Unique identifier for each claim transaction
fkClaimid int 4 √ null
Claim.ClaimID FK_Claim C

Claim reference - Links to Claim table for the associated claim
DateTransaction datetime 16,3 √ (getdate())

Transaction date - Date when the financial transaction occurred
Amount money 21,4 √ null

Transaction amount - Dollar amount of the transaction (positive or negative)
BillingUnit decimal 6,2 √ null

Billing units - Number of billing units affected by this transaction
TransType varchar 20 √ null

Transaction type - Type of transaction
DateTransType datetime 16,3 √ null

Transaction type date - Date associated with the specific transaction type
InsertBy int 4 √ null
AccessUser.UserID FK_UserID R

Created by user - UserID of the person who created this transaction
Editable int 4 √ null

Editable flag - Indicates if this transaction can be modified
fkInsertID int 4 √ null

Insert reference - Reference to the insertion process or batch
original int 4 √ null

Original transaction - Flag indicating if this is the original transaction
transcomments text 2147483647 √ null

Transaction comments - Detailed notes about the transaction
InvoiceID int 4 √ null

Invoice reference - Links to Invoice table if transaction is part of an invoice
UpdateBy int 4 √ null

Updated by user - UserID of the person who last modified this transaction

Indexes

Constraint Name Type Sort Column(s)
PK_TransID Primary key Desc TransID
IX_ClaimID Performance Asc fkClaimid
IX_DateTrans Performance Asc DateTransaction
IX_DateTransType Performance Asc DateTransType
IX_TransType Performance Asc TransType

Relationships

Close relationships within degrees of separation