BIvwCNSInitialReferral


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
Date Decision to Refer datetime 16,3 √ null
Date Referred datetime 16,3 √ null
Key Worker varchar 50 √ null
Key Worker (Other) varchar 255 √ null
Source of Referral varchar 50 √ null
Reason Referred varchar 50 √ null
Contact Made With Patient varchar 3 √ null
Verbal Information Offered varchar 3 √ null
Written Information Offered varchar 3 √ null
CNS Details Offered varchar 3 √ null
GP Informed of Diagnosis varchar 3 √ null
Patient Understands Diagnosis varchar 3 √ null
District Nurse Informed of Diagnosis varchar 3 √ null
District Nurse Name nvarchar 100 √ null
District Nurse Phone Number nvarchar 100 √ null
Prognosis varchar 255 √ null
Bad News Surgeon Present varchar 3 √ null
Bad News CNS Present varchar 3 √ null
Bad News Non-Designated Doctor Present varchar 3 √ null
Bad News Non-Designated Nurse Present varchar 3 √ null
Bad News GP Present varchar 3 √ null
Bad News Consultant Present varchar 3 √ null
Bad News Other Person Present varchar 3 √ null
Bad News Unknown Person Present varchar 3 √ null
Level of Intervention Advice to Professional Colleague varchar 3 √ null
Level of Intervention Short Term Intervention varchar 3 √ null
Level of Intervention Ongoing Regular Assessment varchar 3 √ null
Date Discharged from Care datetime 16,3 √ null

View Definition

Possibly Referenced Tables/Views