Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| caseRuleDesc | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of CaseRule information |
||||
| CaseRuleID | Unknown | 0 | null |
|
|
Primary key - CaseRule unique identifier for each business rule |
|||||
| caseRuleName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for CaseRule records |
||||
| ErrorMessage | Unknown | 0 | null |
|
|
Error message - Message displayed when the rule is violated |
|||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this rule is currently enforced |
|||||
| pkCaseRuleID | int identity | 4 | √ | null |
|
|
Primary key - CaseRule unique identifier for each record |
||||
| levelOrder | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for CaseRule records |
||||
| RuleDescription | Unknown | 0 | null |
|
|
Rule description - Detailed explanation of what the rule validates or enforces |
|||||
| RuleExpression | Unknown | 0 | null |
|
|
Rule expression - Logical expression or formula that defines the rule |
|||||
| RuleName | Unknown | 0 | null |
|
|
Rule name - Descriptive name of the business rule |
|||||
| RuleType | Unknown | 0 | null |
|
|
Rule type - Classification of the rule (Validation, Calculation, Workflow, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CaseRule | Primary key | Asc | pkCaseRuleID |