PatientPreReferral


Description

Patient pre-referral tracking managing pre-referral activities and communications before formal referral processes. This table tracks pre-referral dates, outside source contacts, and comments for patients in the pre-referral phase, supporting early intervention outreach, referral preparation, and comprehensive tracking of patient engagement before formal service initiation.

Columns

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

Primary key - Unique identifier for each pre-referral record
patientID int 4 √ null
Patient.PatientID FK__PatientPr__patie__7F0CB2F5 C

Patient reference - Links to Patient table for the patient in pre-referral status (foreign key to Patient.PatientID)
DatePreReferral smalldatetime 16 √ null

Pre-referral date - Date when pre-referral contact or activity occurred
OutSideSourceID int 4 √ null

Outside source reference - Links to outside source involved in the pre-referral
Comments varchar 1000 √ null

Pre-referral comments - Detailed comments about pre-referral activities, contacts, or observations

Indexes

Constraint Name Type Sort Column(s)
PK__PatientPreReferr__7E188EBC Primary key Asc preRefID

Relationships

Close relationships within degrees of separation