Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RuleCPID | int | 4 | √ | null |
|
|
Rule claim procedure ID - Identifier for the rule-claim procedure association |
|
| fkCPID | int | 4 | √ | null |
|
|
Claim procedure reference - Links to ClaimProcedure table for the procedure subject to this rule |
|
| RuleError | varchar | 15 | √ | null |
|
|
Rule error code - Code identifying the specific business rule applied to this claim procedure |
|
| Lock | int | 4 | √ | null |
|
|
Lock status - Numeric indicator for locking status of the rule application |
|
| fieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the specific field that this rule validates or controls |
|
| defaultValue | varchar | 100 | √ | null |
|
|
Default value - Default value to be applied when the rule is triggered |
|
| checkOrder | int | 4 | √ | null |
|
|
Check order - Numeric order in which this rule should be evaluated relative to other rules |
|
| AppliedStatus | varchar | 100 | √ | null |
|
|
Applied status - Status indicating how or when this rule has been applied |
Relationships
Close relationships within degrees of separation
