DisReaInProgramType


Description

Discharge reason program assignments linking discharge reasons to specific program types for program-specific discharge management. This junction table manages which discharge reasons are available for specific program types, enabling program-specific discharge reason configuration and tracking for healthcare service management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DischargedID int 4 √ null
DischargedReason.DischargedID FK__DisReaInP__Disch__2E86BBED C

Discharge reason reference - Links to DischargedReason table
IsDefault Unknown 0 null

Default flag - Boolean indicating if this is the default discharge reason for the program type
ProgramID int 4 √ null

Program reference - Links to program type for this discharge reason

Relationships

Close relationships within degrees of separation