ClaimArchive

Primary key - Unique identifier for the archived claim record

Claim foreign key - Links to the original claim that was archived

Status identifier - Status of the claim at the time of archiving, references iCS2.dbo.StatusType for centralized status management

Archive date - Date when the claim was moved to archive

Amount paid - Total amount paid for this claim

Service date - Date when the healthcare service was provided

Cycle date - Billing cycle date when claim was processed

Billing date - Date when the claim was submitted for payment

Action identifier - Foreign key linking to the action taken on this claim

Procedure identifier - Foreign key linking to the procedure code billed

Modifier identifier - Foreign key linking to billing modifier applied

Clearing house error - Error code from clearing house processing

Updated by user - User ID of the person who last updated the claim

Service type identifier - Foreign key linking to the type of service provided

Amount charged - Original amount charged for the service

Invoice identifier - Reference to the invoice containing this claim

Archive type - Type of archiving (Paid, Denied, Voided, Adjusted, etc.)

Check log foreign key - Links to payment check log if claim was paid

Adjustment date - Date when claim amount was adjusted

Void date - Date when claim was voided

Adjustment amount - Amount of adjustment applied to the claim

Void amount - Amount voided from the original claim

Void identifier - Foreign key linking to void reason

Payment date - Date when payment was received for this claim

Import identifier - Foreign key linking to import batch if claim was imported

Void amount - Duplicate field for amount voided (legacy)

Import claim identifier - Original claim ID from imported data