Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RAID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each imported remittance advice record |
|
| Authorization | char | 8 | √ | null |
|
|
Authorization number - Prior authorization number or reference for the service |
|
| Amountcharged | money | 21,4 | √ | null |
|
|
Charged amount - Total amount charged for the service or claim |
|
| Units | int | 4 | √ | null |
|
|
Service units - Number of units of service provided |
|
| InvoiceID | char | 12 | √ | null |
|
|
Invoice identifier - Invoice number or reference associated with this RA import |
|
| DateStart | datetime | 16,3 | √ | null |
|
|
Service start date - Date when the service period began |
|
| DateEnd | datetime | 16,3 | √ | null |
|
|
Service end date - Date when the service period ended |
|
| Datebilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the claim was submitted for billing |
|
| Datecycle | datetime | 16,3 | √ | null |
|
|
Cycle date - Processing cycle date for the remittance advice |
|
| Status | char | 1 | √ | null |
|
|
Processing status - Single character status code for the RA import processing |
|
| AmountPaid | money | 21,4 | √ | null |
|
|
Paid amount - Amount actually paid by the payer for this service |
|
| Errorcode | char | 8 | √ | null |
|
|
Error code - Error or adjustment code from the remittance advice processing |
|
| DateImport | datetime | 16,3 | √ | (getdate()) |
|
|
Import timestamp - Date and time when this RA data was imported into the system |
Relationships
Close relationships within degrees of separation
