Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ErrorID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each error code |
||||
| ErrorCode | varchar | 5 | √ | null |
|
|
Error code - Clearing house specific error code |
||||
| ErrorDesc | varchar | 200 | √ | null |
|
|
Error description - Description of what the error means |
||||
| Solution | varchar | 4000 | √ | null |
|
|
Error solution - Detailed guidance on how to resolve the error |
||||
| ClearingHouseID | int | 4 | √ | null |
|
|
Clearing house reference - Links to ClearingHouse table for the source of this error |
||||
| Active | bit | 1 | √ | null |
|
|
Active flag - Boolean indicating if this error code is currently active |
||||
| Prefix | varchar | 5 | √ | null |
|
|
Error prefix - Prefix used with the error code |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClearingHouseError | Primary key | Asc | ErrorID |
Relationships
Close relationships within degrees of separation
