BIvwTertiaryReferrals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 √ null
Cancer Site varchar 50 √ null
NHS Number varchar 10 √ null
Hospital Number varchar 20 √ null
Full Name varchar 111 √ null
Tertiary Type varchar 7 null
Method of Referral varchar 10 null
eTertiary Referral Status varchar 50 √ null
eTertiary Referral Status Detail varchar 200 √ null
Confirmed Cancer varchar 3 √ null
Referring Organisation nvarchar 500 √ null
Referring Clinician varchar 100 √ null
Sending Contact Name varchar 100 √ null
Sending Contact Mobile varchar 50 √ null
Sending Contact Telephone varchar 50 √ null
Sending Contact Email Address varchar 100 √ null
Tertiary Referral Requested Date date 20 √ null
Tertiary Referral Reason varchar 100 √ null
Formal Transfer of Care? varchar 3 √ null
Tertiary Referral Comments varchar 2147483647 √ null
Receiving Organisation nvarchar 500 √ null
Referral Recipients Reason varchar 100 √ null
Receiving Clinician varchar 100 √ null
Recieving Clinician Speciality varchar 150 √ null
Receiving Contact Name varchar 50 √ null
Receiving Contact Telephone varchar 50 √ null
Receiving Contact Email Address varchar 100 √ null
Referral Request Received Date date 20 √ null
Date Tertiary Referral Returned date 20 √ null
Tertiary Return Comments nvarchar 1073741823 √ null

View Definition

Possibly Referenced Tables/Views