ClientCaseRules


Description

Client case rule assignments linking clients to specific case rules and rule values for business logic enforcement. This table manages the assignment of case rules to clients, enabling client-specific business rule enforcement, validation logic, and workflow customization for healthcare case management and compliance requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkClientRule int identity 4 √ null

Primary key - Unique identifier for each client rule assignment
fkCaseRuleID int 4 √ null

Case rule reference - Links to case rule definition
fkCaseRuleValID int 4 √ null

Rule value reference - Links to specific rule value or parameter

Indexes

Constraint Name Type Sort Column(s)
PK_ClientCaseRules Primary key Asc pkClientRule

Relationships

Close relationships within degrees of separation