caseCategory_vw


Description

Case category program view providing a consolidated view of case categories and their associated program types. This view combines case category definitions with program type assignments to support case classification, program-specific workflows, and case management reporting across different healthcare programs.

Columns

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

Case category ID - Unique identifier for the case category
caseDesc varchar 50 √ null

Category description - Descriptive name of the case category
programID int 4 √ null

Program reference - Links to the program type associated with this case category

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views