raapplication_EiMedicaid


Description

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

Columns

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

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

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

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

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

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

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

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

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

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

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

Invoice transaction reference - Links to invoice transaction if applicable

Indexes

Constraint Name Type Sort Column(s)
IX_Raid Performance Asc fkraid

Relationships

Close relationships within degrees of separation