Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ErrorID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| ErrorCode | int | 4 | √ | null |
|
|
Error code - Standardized error code from the clearinghouse |
|
| ErrorDesc | varchar | 100 | √ | null |
|
|
Description field - Detailed description or explanation of Clearinghouseerror information |
|
| ClearingHouseID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| ErrorDate | Unknown | 0 | null |
|
|
Error date - Date and time when the error occurred |
||
| ErrorDescription | Unknown | 0 | null |
|
|
Error description - Detailed description of the error |
||
| FileName | Unknown | 0 | null |
|
|
File name - Name of the file that caused the error |
||
| fkClearingHouseID | Unknown | 0 | null |
|
|
Clearinghouse reference - Reference to the clearinghouse where the error occurred |
||
| Solution | varchar | 4000 | √ | null |
|
|
Text field - Solution text information for Clearinghouseerror records |
|
| Prefix | varchar | 5 | √ | null |
|
|
Text field - Prefix text information for Clearinghouseerror records |
|
| RecordNumber | Unknown | 0 | null |
|
|
Record number - Specific record within the file that had the error |
||
| Resolution | Unknown | 0 | null |
|
|
Resolution - How the error was resolved or corrected |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Clearinghouseerror | Primary key | Asc | ErrorID |
| IX_Clearinghouseerror | Must be unique | Asc | ErrorID |