Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RAID | int identity | 4 | √ | null |
|
|
Remittance advice primary key - Unique identifier for each remittance advice import record |
|
| ICN | char | 13 | √ | null |
|
|
Internal control number - Internal control number for claim identification |
|
| LineNumber | char | 5 | √ | null |
|
|
Line number - Line number on the remittance advice |
|
| ProcDesc | char | 1 | √ | null |
|
|
Procedure description - Procedure description code |
|
| ServiceLocation | char | 1 | √ | null |
|
|
Service location - Location where service was provided |
|
| MethodDes | char | 1 | √ | null |
|
|
Method description - Method description code |
|
| TransType | int | 4 | √ | null |
|
|
Transaction type - Type of transaction for the remittance |
|
| ClaimType | int | 4 | √ | null |
|
|
Claim type - Type of claim being processed |
|
| ProviderID | int | 4 | √ | null |
|
|
Provider reference - Links to provider information |
|
| AgencyPatientID | char | 7 | √ | null |
|
|
Agency patient ID - Patient identifier used by the agency |
|
| Code | char | 5 | √ | null |
|
|
Procedure code - Procedure or service code |
|
| Units | int | 4 | √ | null |
|
|
Service units - Number of units of service provided |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| DateService2 | nvarchar | 40 | √ | null |
|
|
Alternative service date - Alternative format for service date |
|
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the claim was billed |
|
| DateCycle | datetime | 16,3 | √ | null |
|
|
Cycle date - Billing cycle date for the remittance |
|
| Amountcharged | money | 21,4 | √ | null |
|
|
Amount charged - Total amount charged for the service |
|
| AmountPaid | money | 21,4 | √ | null |
|
|
Amount paid - Amount paid by the insurance payer |
|
| PriorAuth | char | 8 | √ | null |
|
|
Prior authorization - Prior authorization number |
|
| InvoiceID | char | 13 | √ | null |
|
|
Invoice identifier - Invoice number for the claim |
|
| LastName | char | 14 | √ | null |
|
|
Patient last name - Last name of the patient |
|
| FirstName | char | 10 | √ | null |
|
|
Patient first name - First name of the patient |
|
| MidName | char | 1 | √ | null |
|
|
Patient middle name - Middle name or initial of the patient |
|
| RemittIDNumber | char | 5 | √ | null |
|
|
Remittance ID number - Remittance identification number |
|
| CheckNumber | int | 4 | √ | null |
|
|
Check number - Payment check number |
|
| Statusid | int | 4 | √ | null |
|
|
Status reference - Links to status information |
|
| ErrorCode | int | 4 | √ | null |
|
|
Error code 1 - First error code from remittance processing |
|
| ErrorFlag | char | 1 | √ | null |
|
|
Error flag 1 - First error flag indicator |
|
| ErrorLine | char | 2 | √ | null |
|
|
Error line 1 - First error line number |
|
| ErrorCode2 | int | 4 | √ | null |
|
|
Error code 2 - Second error code from remittance processing |
|
| ErrorFlag2 | char | 1 | √ | null |
|
|
Error flag 2 - Second error flag indicator |
|
| ErrorLine2 | char | 2 | √ | null |
|
|
Error line 2 - Second error line number |
|
| ErrorCode3 | int | 4 | √ | null |
|
|
Error code 3 - Third error code from remittance processing |
|
| ErrorFlag3 | char | 1 | √ | null |
|
|
Error flag 3 - Third error flag indicator |
|
| ErrorLine3 | char | 2 | √ | null |
|
|
Error line 3 - Third error line number |
|
| ErrorCode4 | int | 4 | √ | null |
|
|
Error code 4 - Fourth error code from remittance processing |
|
| ErrorFlag4 | char | 1 | √ | null |
|
|
Error flag 4 - Fourth error flag indicator |
|
| ErrorLine4 | char | 2 | √ | null |
|
|
Error line 4 - Fourth error line number |
|
| ErrorCode5 | int | 4 | √ | null |
|
|
Error code 5 - Fifth error code from remittance processing |
|
| ErrorFlag5 | char | 1 | √ | null |
|
|
Error flag 5 - Fifth error flag indicator |
|
| ErrorLine5 | char | 2 | √ | null |
|
|
Error line 5 - Fifth error line number |
|
| ErrorCode6 | int | 4 | √ | null |
|
|
Error code 6 - Sixth error code from remittance processing |
|
| ErrorFlag6 | char | 1 | √ | null |
|
|
Error flag 6 - Sixth error flag indicator |
|
| ErrorLine6 | char | 2 | √ | null |
|
|
Error line 6 - Sixth error line number |
|
| ErrorCode7 | int | 4 | √ | null |
|
|
Error code 7 - Seventh error code from remittance processing |
|
| ErrorFlag7 | char | 1 | √ | null |
|
|
Error flag 7 - Seventh error flag indicator |
|
| ErrorLine7 | char | 2 | √ | null |
|
|
Error line 7 - Seventh error line number |
|
| ErrorCode8 | int | 4 | √ | null |
|
|
Error code 8 - Eighth error code from remittance processing |
|
| ErrorFlag8 | char | 1 | √ | null |
|
|
Error flag 8 - Eighth error flag indicator |
|
| ErrorLine8 | char | 2 | √ | null |
|
|
Error line 8 - Eighth error line number |
|
| ErrorCode9 | int | 4 | √ | null |
|
|
Error code 9 - Ninth error code from remittance processing |
|
| ErrorFlag9 | char | 1 | √ | null |
|
|
Error flag 9 - Ninth error flag indicator |
|
| ErrorLine9 | char | 2 | √ | null |
|
|
Error line 9 - Ninth error line number |
|
| ErrorCode10 | int | 4 | √ | null |
|
|
Error code 10 - Tenth error code from remittance processing |
|
| ErrorFlag10 | char | 1 | √ | null |
|
|
Error flag 10 - Tenth error flag indicator |
|
| ErrorLine10 | char | 2 | √ | null |
|
|
Error line 10 - Tenth error line number |
|
| DateImport | datetime | 16,3 | √ | (getdate()) |
|
|
Import date - Date when the remittance data was imported |
|
| TransMethod | varchar | 10 | √ | null |
|
|
Transmission method - Method used to transmit the remittance data |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_DateCycle | Performance | Asc | DateCycle |
| IX_raimport | Performance | Asc | RAID |
| IX_raimport_1 | Performance | Asc | ProcDesc |
| IX_raimport_2 | Performance | Asc | DateService |
Relationships
Close relationships within degrees of separation
