checkLog


Description

Payment check tracking managing the receipt and processing of payments from insurance companies, government payers, and other payment sources. This table tracks check deposits, payment amounts, adjustments, and financial reconciliation for accounts receivable management and cash flow tracking.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
checkLogID int identity 4 √ null
CheckLogTransaction.fkCheckLogID FK_CheckLogTransaction_checkLog R
ClaimTransCheck.fkCheckID FK__ClaimTran__fkChe__0D1C71D8 R
InvoiceTransCheck.fkCheckLogID FK__InvTransCheckID__CheckLogID R
raFiles.fkCheckLogID FK_raFiles_checkLog R

Primary key - Unique identifier for each payment check record
DateOfCheck datetime 16,3 √ null

Check date - Date on the payment check
ClaimAmtPaid money 21,4 √ null

Claims paid amount - Total amount paid for claims in this check
PosAdjustAmt money 21,4 √ null

Positive adjustment - Amount of positive adjustments included in the payment
NegAdjustAmt money 21,4 √ null

Negative adjustment - Amount of negative adjustments or deductions
CheckAmt money 21,4 √ null

Check amount - Total amount of the payment check
CheckNum varchar 30 √ null

Check number - Check number or electronic payment reference
DateOfDeposit datetime 16,3 √ null

Deposit date - Date when the check was deposited
Comments varchar 500 √ null

Payment comments - Notes about the payment or processing issues
fkSourceID varchar 65 √ null

Payment source - Identifier for the payer or payment source
Type int 4 √ null

Payment type - Type of payment (Insurance, Government, Private pay, etc.)
Category int 4 √ null

Payment category - Category classification for the payment
fkSiteID int 4 √ null

Site reference - Links to AgencySite table for the receiving location
fkCodeID int 4 √ null

Code reference - Links to payment code or classification
manualAdjAmt money 21,4 √ null

Manual adjustment - Amount of manual adjustments made to the payment
DateCreated datetime 16,3 √ (getdate())

Creation date - Timestamp when the payment record was created

Indexes

Constraint Name Type Sort Column(s)
PK__checkLog__3A8349D5 Primary key Asc checkLogID
IX_CheckNum Performance Asc CheckNum
IX_DateofDeposit Performance Asc DateOfDeposit

Relationships

Close relationships within degrees of separation