SourceType


Description

Source type definitions managing categories of external data sources and referral sources for healthcare services. This lookup table defines source types including descriptions to support source categorization, referral tracking, and external data integration for healthcare service coordination and patient referral management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sourceTypeID int identity 4 √ null
OutsideSource.SourceTypeID FK_OutsideSource_SourceType R

Primary key - Unique identifier for each source type
sourceTypeDesc varchar 50 √ null

Source type description - Descriptive name of the source type (e.g., ‘Hospital’, ‘Physician’, ‘Self-Referral’, ‘School District’)

Indexes

Constraint Name Type Sort Column(s)
PK_SourceType Primary key Asc sourceTypeID

Relationships

Close relationships within degrees of separation