CaseCategory


Description

Case type classifications defining the different categories or types of cases that can be managed in the system. This lookup table provides standardized case classifications for organizing and reporting on different types of healthcare service cases.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CaseID int identity 4 √ null
CaseCategoryInProgramType.caseid FK__CaseCateg__casei__0E8400AF C
PatientAdministration.groupingID FK__PatientAdmin__CaseCat R

Primary key - Unique identifier for each case category
CaseDesc varchar 50 √ null

Category description - Descriptive name of the case category type

Indexes

Constraint Name Type Sort Column(s)
PK__CaseCategory__640DD89F Primary key Asc CaseID

Relationships

Close relationships within degrees of separation