Referral


Description

Referral source management storing information about individuals and organizations that refer patients to healthcare services. This table manages referral source contacts including names, agency associations, and notes, supporting referral tracking, source management, and relationship building for patient acquisition and service coordination in healthcare organizations.

Columns

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

Primary key - Unique identifier for each referral source
referralFName varchar 50 √ null

Referral first name - First name of the person making referrals
referralLName varchar 50 √ null

Referral last name - Last name of the person making referrals
referralAgencyID int 4 √ null

Agency reference - Links to the agency or organization associated with this referral source
referralNotes varchar 5000 √ null

Referral notes - Additional notes and information about the referral source

Indexes

Constraint Name Type Sort Column(s)
PK_Referral Primary key Asc referralID

Relationships

Close relationships within degrees of separation