patientStatus_vw


Description

Patient status program view providing patient status information filtered by program type for program-specific status management. This view consolidates data from PatientStatus and StatusInProgramType tables to support program-specific patient status tracking, enrollment management, and status-based reporting for healthcare program administration and patient care coordination.

Columns

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

Status identifier - Unique identifier for the patient status
statusName varchar 50 √ null

Status name - Descriptive name of the patient status
programTypeID int 4 √ null

Program type reference - Links to the program type that uses this status
statusType int 4 √ null

Status type - Numeric identifier for the type or category of status

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views