raapplication_new


Description

New remittance application processing managing the application of remittance advice to claims using updated processing workflows. This table tracks remittance applications with enhanced processing capabilities including claim associations, transaction links, status tracking, rule error handling, and comprehensive audit trails to support modern remittance processing and automated payment application workflows.

Columns

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

Primary key - Unique identifier for each new remittance application record
fkraid int 4 null

Remittance advice reference - Links to the remittance advice record being applied
fkclaimid int 4 √ null

Claim reference - Links to the claim that this remittance applies to
fktransid int 4 √ null

Transaction reference - Links to the transaction created from this remittance application
fkremitstatusid int 4 √ null

Remit status reference - Links to RemitStatus table for processing status
ruleerrorid varchar 10 √ null

Rule error identifier - Rule error code if business rules were violated during application
comments nvarchar 1000 √ null

Application comments - Comments or notes about the remittance application process
applicationdate smalldatetime 16 null

Application date - Date when the remittance was applied to the claim
updatedby int 4 √ null

Updated by user - UserID of the person who last updated this application
dateupdated datetime 16,3 √ null

Last update date - Date when the application record was last modified
fkinvtransid int 4 √ null

Invoice transaction reference - Links to invoice transaction if applicable

Relationships

Close relationships within degrees of separation