Category


Description

Service categories and classifications defining categories for organizing services, procedures, and healthcare activities. This table manages category classifications with program-specific assignments and type definitions to support service organization, reporting categorization, and workflow management across different healthcare programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
catID int identity 4 √ null
CategoryGroupAssigned.catID FK__CategoryG__catID__6FFF798F C
CategoryTypeAssigned.catID FK__CategoryT__catID__6E17311D C

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

Category description - Descriptive name of the category
Lock bit 1 √ null

Lock flag - Boolean indicating if the category is locked from editing
ProgramID int 4 √ null

Program reference - Links to iCS2.dbo.ProgramType for centralized program type definitions this category applies to
CatTypeID int 4 √ null

Category type reference - Links to the type classification for this category

Indexes

Constraint Name Type Sort Column(s)
PK_Category Primary key Asc catID

Relationships

Close relationships within degrees of separation