StatusInProgramType


Description

Status program type associations linking patient status definitions to specific program types for program-specific status management. This junction table manages the relationship between patient statuses and program types including status types to support program-specific status tracking, enrollment management, and program-appropriate status workflows for healthcare and early intervention services.

Columns

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

Primary key - Unique identifier for each status-program association
statusID int 4 √ null
PatientStatus.statusID FK__StatusInP__statu__71B2B7D7 C

Status reference - Links to PatientStatus table for the patient status
ProgramTypeID int 4 √ null

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

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

Indexes

Constraint Name Type Sort Column(s)
PK__StatusInProgramT__70BE939E Primary key Asc statProgID

Relationships

Close relationships within degrees of separation