Statuses


Description

System status definitions managing standardized status codes and descriptions used throughout the healthcare system for workflow management and state tracking. This lookup table defines status values including names, descriptions, and status codes to support consistent status tracking, workflow automation, and system state management across all healthcare processes and data entities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
StatusID int identity 4 √ null
StatusInLevel.fkStatusID FK_StatusInLevel_Statuses R

Primary key - Unique identifier for each status definition
StatusName varchar 50 null

Status name - Descriptive name of the status (e.g., ‘Active’, ‘Pending’, ‘Completed’, ‘Cancelled’)
StatusDesc varchar 500 √ null

Status description - Detailed description of what the status represents and when it is used
StatusValue varchar 10 √ null

Status value - Short code or value representing the status for system processing

Indexes

Constraint Name Type Sort Column(s)
PK_Statuses Primary key Asc StatusID

Relationships

Close relationships within degrees of separation