ReferralCustom


Description

Referral custom fields table for storing extended referral information and outcome rating scale (ORS) data. This table captures custom fields, assessment scores, outcome measurements, and additional referral-specific data that extends beyond the standard referral information. Used for tracking referral outcomes, assessment results, custom workflow data, and specialized reporting requirements in early intervention and healthcare referral management processes.

Columns

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

Primary key - Unique identifier for each referral custom record
fkAdmitID int 4 null

Case reference - Links to PatientAdministration table for the case
DateCreated datetime 16,3 √ null

Creation date - Date when this custom record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this record
DateUpdated datetime 16,3 √ null

Last update date - Date when this record was last updated
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated this record
DeletedDate datetime 16,3 √ null

Deletion date - Date when this record was marked as deleted
ORS45 nvarchar 510 √ null

ORS field 45 - Outcome Rating Scale field 45 for assessment data
ORS44 nvarchar 510 √ null

ORS field 44 - Outcome Rating Scale field 44 for assessment data
ORS43 nvarchar 510 √ null

ORS field 43 - Outcome Rating Scale field 43 for assessment data
ORS42 nvarchar 510 √ null

ORS field 42 - Outcome Rating Scale field 42 for assessment data
ORS41 nvarchar 510 √ null

ORS field 41 - Outcome Rating Scale field 41 for assessment data
ORS40 nvarchar 510 √ null

ORS field 40 - Outcome Rating Scale field 40 for assessment data
ORS39 nvarchar 510 √ null

ORS field 39 - Outcome Rating Scale field 39 for assessment data
ORS38 nvarchar 510 √ null

ORS field 38 - Outcome Rating Scale field 38 for assessment data
ORS37 nvarchar 510 √ null

ORS field 37 - Outcome Rating Scale field 37 for assessment data
ORS36 nvarchar 510 √ null

ORS field 36 - Outcome Rating Scale field 36 for assessment data
ORS35 nvarchar 510 √ null

ORS field 35 - Outcome Rating Scale field 35 for assessment data
ORS34 nvarchar 510 √ null

ORS field 34 - Outcome Rating Scale field 34 for assessment data
ORS33 nvarchar 510 √ null

ORS field 33 - Outcome Rating Scale field 33 for assessment data
ORS32 nvarchar 510 √ null

ORS field 32 - Outcome Rating Scale field 32 for assessment data
ORS31 nvarchar 510 √ null

ORS field 31 - Outcome Rating Scale field 31 for assessment data
ORS30 nvarchar 510 √ null

ORS field 30 - Outcome Rating Scale field 30 for assessment data
ORS29 nvarchar 510 √ null

ORS field 29 - Outcome Rating Scale field 29 for assessment data
ORS28 nvarchar 510 √ null

ORS field 28 - Outcome Rating Scale field 28 for assessment data
ORS27 nvarchar 510 √ null

ORS field 27 - Outcome Rating Scale field 27 for assessment data
ORS26 nvarchar 510 √ null

ORS field 26 - Outcome Rating Scale field 26 for assessment data
ORS25 nvarchar 510 √ null

ORS field 25 - Outcome Rating Scale field 25 for assessment data
ORS24 nvarchar 510 √ null

ORS field 24 - Outcome Rating Scale field 24 for assessment data
ORS23 nvarchar 510 √ null

ORS field 23 - Outcome Rating Scale field 23 for assessment data
ORS22 nvarchar 510 √ null

ORS field 22 - Outcome Rating Scale field 22 for assessment data
ORS20 nvarchar 510 √ null

ORS field 20 - Outcome Rating Scale field 20 for assessment data
ORS19 nvarchar 510 √ null

ORS field 19 - Outcome Rating Scale field 19 for assessment data
ORS18 nvarchar 510 √ null

ORS field 18 - Outcome Rating Scale field 18 for assessment data
ORS17 nvarchar 510 √ null

ORS field 17 - Outcome Rating Scale field 17 for assessment data
ORS16 nvarchar 510 √ null

ORS field 16 - Outcome Rating Scale field 16 for assessment data
ORS15 nvarchar 510 √ null

ORS field 15 - Outcome Rating Scale field 15 for assessment data
ORS14 nvarchar 510 √ null

ORS field 14 - Outcome Rating Scale field 14 for assessment data
ORS13 nvarchar 510 √ null

ORS field 13 - Outcome Rating Scale field 13 for assessment data
ORS12 nvarchar 510 √ null

ORS field 12 - Outcome Rating Scale field 12 for assessment data
ORS11 nvarchar 510 √ null

ORS field 11 - Outcome Rating Scale field 11 for assessment data
ORS10 nvarchar 510 √ null

ORS field 10 - Outcome Rating Scale field 10 for assessment data
ORS9 nvarchar 510 √ null

ORS field 9 - Outcome Rating Scale field 9 for assessment data
ORS8 nvarchar 510 √ null

ORS field 8 - Outcome Rating Scale field 8 for assessment data
ORS7 nvarchar 510 √ null

ORS field 7 - Outcome Rating Scale field 7 for assessment data
ORS6 nvarchar 510 √ null

ORS field 6 - Outcome Rating Scale field 6 for assessment data
ORS5 nvarchar 510 √ null

ORS field 5 - Outcome Rating Scale field 5 for assessment data
ORS4 nvarchar 510 √ null

ORS field 4 - Outcome Rating Scale field 4 for assessment data
ORS3 nvarchar 510 √ null

ORS field 3 - Outcome Rating Scale field 3 for assessment data
ORS2 nvarchar 510 √ null

ORS field 2 - Outcome Rating Scale field 2 for assessment data
ORS1 nvarchar 510 √ null

ORS field 1 - Outcome Rating Scale field 1 for assessment data

Indexes

Constraint Name Type Sort Column(s)
PK_ReferralCustom Primary key Asc pkID

Relationships

Close relationships within degrees of separation