PatientReferral


Description

Patient referral management tracking referral information, sources, and outcomes for patients entering the healthcare system. This table manages referral data including referral dates, outside sources, declined reasons, referral contact information, and referral outcomes, supporting comprehensive referral tracking, source management, and referral outcome analysis for early intervention and healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Comments Unknown 0 null

Referral comments - Additional comments or notes about the referral
RefID int identity 4 √ null

Primary key - Unique identifier for each patient referral record
DateEIReferral smalldatetime 16 √ null

Early intervention referral date - Date when early intervention referral was made
OutSideSourceID int 4 √ null
OutsideSource.SourceID FK__PatientRe__OutSi__753864A1 R

Outside source reference - Links to OutsideSource table for the referring organization (foreign key to OutsideSource.SourceID)
DeclinedID int 4 √ null
DeclinedReason.DeclinedID FK__PatientRe__Decli__762C88DA R

Declined reason reference - Links to DeclinedReason table if referral was declined (foreign key to DeclinedReason.DeclinedID)
PatientID int 4 √ null

Patient reference - Links to Patient table for the patient being referred
ReferralEmail Unknown 0 null

Referral contact email - Email address of the person making the referral
ReferralLastName varchar 30 √ null

Referral contact last name - Last name of the person making the referral
ReferralFirstName varchar 30 √ null

Referral contact first name - First name of the person making the referral
ReferralNotes varchar 4000 √ null

Referral notes - Detailed notes and comments about the referral circumstances and requirements
ReferralOutcome Unknown 0 null

Referral outcome - Result or outcome of the referral process
ReferralPhone Unknown 0 null

Referral contact phone - Phone number of the person making the referral
referralReason varchar 50 √ null

Referral reason - Reason or justification for the referral to healthcare services
ReferralFosterCare int 4 √ null

Foster care indicator - Numeric indicator if the patient is in foster care system
scheduledIFSPDate datetime 16,3 √ null

Scheduled IFSP date - Date when the Individualized Family Service Plan is scheduled
DateReferral smalldatetime 16 √ null

General referral date - Date when referral was initially made
BillingType int 4 √ null

Billing type reference - Links to billing type for referral-related billing
caseID int 4 √ null
PatientAdministration.AdmitID FK__PatientRe__PatientAdmin C

Case reference - Links to PatientAdministration table for the patient case
DateCreated smalldatetime 16 √ null

Creation date - Date when the referral record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the referral record
DateUpdated smalldatetime 16 √ null

Last update date - Date when the referral record was last modified
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated the referral record
fkSourceID2 int 4 √ null

Secondary source reference - Links to additional referral source if applicable
dateLastEvalCompleted datetime 16,3 √ null

Last evaluation completion date - Date when the most recent evaluation was completed

Indexes

Constraint Name Type Sort Column(s)
PK__PatientReferral__74444068 Primary key Asc RefID

Relationships

Close relationships within degrees of separation