raapplication_EiInsurance


Description

Early Intervention insurance remittance applications tracking the application of insurance remittance advice to claims and transactions. This table manages the processing of insurance remittance data including claim associations, transaction links, status tracking, rule error handling, and audit trails to support automated remittance processing and payment application for Early Intervention insurance claims.

Columns

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

Primary key - Unique identifier for each 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