CheckListCaseTypes


Description

Checklist case type associations linking checklists to specific case types and program types. This table manages which checklists are applicable to different case types and programs, enabling program-specific checklist workflows and ensuring appropriate checklists are applied based on case characteristics.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkCaseTypeID Unknown 0 null

Case type reference - Links to the case type that should use this checklist
fkChecklistID int 4 √ null

Checklist reference - Links to CheckList table for the associated checklist
IsRequired Unknown 0 null

Required flag - Boolean indicating if this checklist is mandatory for the case type
pkChecklistCaseTypeID int identity 4 √ null

Primary key - Unique identifier for each case type association
ProgramID int 4 √ null

Program reference - Links to program type this checklist applies to

Indexes

Constraint Name Type Sort Column(s)
PK_CheckListCaseType Primary key Asc pkChecklistCaseTypeID

Relationships

Close relationships within degrees of separation