dischargedReason_vw


Description

Discharge reason program view providing discharge reasons with their associated program types for program-specific discharge tracking. This view combines discharge reasons with program assignments to support program-specific discharge reason management and reporting for healthcare service coordination.

Columns

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

Discharge reason ID - Unique identifier for the discharge reason

DisReason varchar 50 null

Discharge reason - Description of the reason for patient discharge

IsActive Unknown 0 null

Active status - Boolean indicating if the reason is currently available for selection

programID int 4 null

Program reference - Links to program type for this discharge reason

Relationships

View Definition


Possibly Referenced Tables/Views