Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RaAppID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each remittance advice application record |
|
| PaySourceID | varchar | 20 | √ | null |
|
|
Payment source identifier - Identifier for the payment source or payer associated with this RA application |
|
| fkRAID | int | 4 | null |
|
|
RA reference - Links to the main remittance advice record for this application |
||
| fkClaimID | int | 4 | √ | null |
|
|
Claim reference - Links to the specific claim associated with this RA application |
|
| fkTransID | int | 4 | √ | null |
|
|
Transaction reference - Links to the financial transaction associated with this RA application |
|
| fkRemitStatusID | int | 4 | √ | null |
|
|
Remit status reference - Links to RemitStatus table for the current processing status |
|
| RuleErrorID | varchar | 10 | √ | null |
|
|
Rule error identifier - Error code or identifier for any business rule violations during RA processing |
|
| Comments | nvarchar | 1000 | √ | null |
|
|
Application comments - Notes and comments about the RA application processing |
|
| ApplicationDate | smalldatetime | 16 | (getdate()) |
|
|
Application date - Date when the RA application was submitted or processed |
||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - Links to AccessUser table for the user who last updated this RA application |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when the RA application was last modified |
|
| fkInvTransID | int | 4 | √ | null |
|
|
Invoice transaction reference - Links to invoice transaction associated with this RA application |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_RaApplication | Primary key | Asc | RaAppID |
Relationships
Close relationships within degrees of separation
