Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EID | int identity | 4 | √ | null |
|
|
Primary key - Auto-incrementing unique identifier for each rule error record |
|
| RuleID | varchar | 10 | null |
|
|
Rule identifier - Unique code identifying the specific business rule |
||
| RuleDescription | varchar | 100 | √ | null |
|
|
Rule description - Brief description of the business rule and its purpose |
|
| RuleTitle | varchar | 15 | √ | null |
|
|
Rule title - Short title or name for the business rule |
|
| RuleAction | varchar | 500 | √ | null |
|
|
Rule action - Action to be taken when the rule is triggered or violated |
|
| display | int | 4 | √ | null |
|
|
Display flag - Numeric indicator controlling whether the rule error is displayed to users |
|
| Instructions | nvarchar | 1073741823 | √ | null |
|
|
Rule instructions - Detailed instructions for resolving the rule error or compliance issue |
|
| AllowCPSEProviderId | bit | 1 | √ | null |
|
|
CPSE provider allowance - Boolean flag indicating if CPSE provider ID is allowed for this rule |
|
| AllowLicense | bit | 1 | √ | null |
|
|
License allowance - Boolean flag indicating if license validation is required for this rule |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the rule was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the rule |
|
| Details | nvarchar | 1073741823 | √ | null |
|
|
Rule details - Additional detailed information about the rule implementation and requirements |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_RuleError | Primary key | Asc | RuleID |
Relationships
Close relationships within degrees of separation
