StatusInLevel


Description

Status level associations linking status definitions to specific application levels for hierarchical status management. This junction table manages the relationship between statuses and application levels to support level-specific status tracking, hierarchical workflow management, and context-appropriate status options for different areas of the healthcare system.

Columns

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

Primary key - Unique identifier for each status-level association
fkStatusID int 4 √ null
Statuses.StatusID FK_StatusInLevel_Statuses R

Status reference - Links to Statuses table for the status definition
fkLevelID int 4 √ null
AppLevels.LevelID FK_StatusInLevel_AppLevels R

Level reference - Links to AppLevels table for the application level that uses this status

Indexes

Constraint Name Type Sort Column(s)
PK_StatusInLevel Primary key Asc StatusLevelID

Relationships

Close relationships within degrees of separation