BIvwDiagnosis


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
Patient Status varchar 100 √ null
Assessed By varchar 50 √ null
Tumour Status varchar 50 √ null
Date of Diagnosis smalldatetime 16 √ null
Other Reason varchar 50 √ null
Date of New Referral smalldatetime 16 √ null
New Tumour Site varchar 50 √ null
Date Patient Informed smalldatetime 16 √ null
Non-cancer Diagnosis (Chapter) varchar 213 √ null
Non-Cancer Diagnosis (Group) varchar 203 √ null
Primary Diagnosis (ICD) varchar 203 √ null
Primary Diagnosis (SNOMED) nvarchar 566 √ null
Secondary Diagnosis varchar 203 √ null
Laterality varchar 50 √ null
Non-cancer details varchar 255 √ null
Organisation nvarchar 500 √ null
Basis of Diagnosis varchar 50 √ null
Histology varchar 133 √ null
Grade of Differentiation varchar 105 √ null
Date Referred to CNS smalldatetime 16 √ null
Date First Seen by CNS smalldatetime 16 √ null
Other Tumour Site Primary Diagnosis varchar 203 √ null
Other Tumour Site Secondary Diagnosis varchar 203 √ null
Date GP Informed of Diagnosis smalldatetime 16 √ null
GP Informed of Diagnosis varchar 3 √ null
Spec Nurse Present when Pt Informed varchar 3 √ null
Relative/Carer Informed of Diagnosis varchar 3 √ null
Date Referred (Tertiary Centre) smalldatetime 16 √ null
Organisation (Tertiary Centre) nvarchar 500 √ null
Reason for Referral (Tertiary Centre) varchar 100 √ null
Comments text 2147483647 √ null
Topography ICD03 varchar 7 √ null
Primary Diagnosis Subsidiary Comment varchar 50 √ null
Consultant (at diagnosis) varchar 50 √ null
Consultant Age Specialty (at diagnosis) varchar 50 √ null
Pathway End Date (Faster Diagnosis) datetime 16,3 √ null
Pathway End Reason (Faster Diagnosis) nvarchar 50 √ null
Exclusion Reason nvarchar 160 √ null
Faster Diagnosis Organisation nvarchar 500 √ null
Care Professional nvarchar 246 √ null
Method of Communication nvarchar 166 √ null
Delay Reason nvarchar 320 √ null
Delay Reason Comments nvarchar 1073741823 √ null
Primary Cancer Site nvarchar 100 √ null

View Definition

Possibly Referenced Tables/Views