PatientStatus


Description

Patient status definitions providing standardized status classifications for patient management and case tracking. This lookup table defines patient status options including status names, open/closed classifications, and archival settings, supporting consistent patient status management, case workflow control, and reporting for healthcare service delivery and patient care coordination.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
statusID int identity 4 √ null
StatusInProgramType.statusID FK__StatusInP__statu__71B2B7D7 C

Primary key - Unique identifier for each patient status
statusName varchar 50 √ null

Status name - Descriptive name of the patient status (e.g., ‘Active’, ‘Discharged’, ‘On Hold’)
OpenClosed nvarchar 40 √ null

Open/closed classification - Indicates whether this status represents an open or closed case
Archived bit 1 √ null

Archive flag - Boolean indicator whether this status is archived or active

Indexes

Constraint Name Type Sort Column(s)
PK_PatientStatus Primary key Asc statusID

Relationships

Close relationships within degrees of separation