BIvwCOSDKeyItems


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
Hospital Number varchar 20 null
NHS Number varchar 10 null
Cancer Site varchar 50 null
ICD10 Code varchar 5 null
Diagnosis (SNOMED) bigint 8 null
Date of Diagnosis smalldatetime 16 null
Basis of Diagnosis varchar 50 null
Organisation (Diagnosis) varchar 5 null
Performance Status varchar 183 null
Pre Treatment T Stage varchar 11 null
Pre Treatment N Stage varchar 11 null
Pre Treatment M Stage varchar 11 null
Pre-Treatment Staging varchar 8000 null
Pre Treatment TNM Grouping varchar 20 null
Pre Treatment TNM Date smalldatetime 16 null
Final T Stage varchar 11 null
Final N Stage varchar 11 null
Final M Stage varchar 11 null
Final Staging varchar 8000 null
Final TNM Stage Grouping varchar 20 null
Final TNM Stage Date smalldatetime 16 null
FIGO Stage varchar 3 null
FIGO Letter varchar 3 null
FIGO Number varchar 3 null
Ann Arbor Stage varchar 50 null
Ann Arbor Symptoms varchar 50 null
Ann Arbor Extranodality varchar 50 null
Ann Arbor Bulk varchar 30 null
Binet Stage varchar 50 null
Murphy (St Jude) Stage varchar 50 null
Wilms Tumour Stage varchar 50 null
RMH Stage Grouping varchar 5 null
Barcelona Clinic Liver Cancer Stage varchar 20 null
R-ISS Stage int 4 null
Co-Morbidity Evaluation Score varchar 50 null
CNS Seen by Indicator Code varchar 255 null

View Definition