BIvwTreatmentAntiCancerDrugs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
Consultant varchar 59 null
Cancer Site varchar 50 null
NHS Number varchar 10 null
Hospital Number varchar 20 null
Full Name varchar 111 null
Date Decision to Treat smalldatetime 16 null
Organisation (DTT) nvarchar 500 null
Date Start of Treatment smalldatetime 16 null
Organisation (Treatment) Site Code varchar 5 null
Organisation (Treatment) Name nvarchar 500 null
Planned Cycles/Courses varchar 10 null
Chemo-Radiotherapy varchar 3 null
Treatment Event Type varchar 100 null
Treatment Setting varchar 50 null
Clinical Trial varchar 3 null
Drug Therapy Type varchar 50 null
Treatment Intent varchar 50 null
Adjunctive Therapy varchar 50 null
Route of Administration varchar 50 null
Drug Regimen Acronym varchar 255 null
TACE Performed Indicator varchar 9 null
Chemotherapy Consultant Age Specialty varchar 50 null
Comments text 2147483647 null
Review/End Date smalldatetime 16 null

View Definition