ReferralAgency


Description

Referral agency definitions managing organizations and agencies that refer patients to healthcare services. This lookup table defines referral agencies with names and identifiers, supporting referral source tracking, agency relationship management, and referral pattern analysis for patient acquisition and service coordination in healthcare organizations.

Columns

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

Primary key - Unique identifier for each referral agency
ReferralAgencyName varchar 50 √ null

Agency name - Name of the organization or agency that makes referrals

Indexes

Constraint Name Type Sort Column(s)
PK_ReferralAgency Primary key Asc ReferralAgencyID

Relationships

Close relationships within degrees of separation