outsideSrc_vw


Description

Outside source view providing consolidated information about external referral sources and their program associations. This view combines data from OutsideSource, SourceType, and OutsidesourceInProgramType tables to support referral source reporting, program-specific source tracking, and external source management for healthcare referral and coordination workflows.

Columns

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

Source identifier - Unique identifier for the outside source
outsideSrc varchar 103 √ null

Source description - Combined description including source type and company name
programID int 4 √ null

Program reference - Links to program type associated with this outside source

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views