BIvwPresentation


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 of Assessment smalldatetime 16 √ null
Assessment By varchar 50 √ null
Performance Status varchar 183 √ null
Family History of Cancer varchar 9 √ null
Acute Pancreatitis varchar 3 √ null
Alcohol-Induced Pancreatitis varchar 3 √ null
Anaemia varchar 3 √ null
Angina varchar 3 √ null
On Asprin varchar 3 √ null
Inflammatory Bowel Disease varchar 3 √ null
Cardiovascular Disease varchar 3 √ null
Cerebal Vascular Disease varchar 3 √ null
Chronic Pancreatitis varchar 3 √ null
Cirrhosis/Liver Disease varchar 3 √ null
Blood Clotting Disorder varchar 3 √ null
COPD or other chronic respiratory illness varchar 3 √ null
History of CVA (Stroke) varchar 3 √ null
Type I Diabetes varchar 3 √ null
Type II Diabetes varchar 3 √ null
History of Cardiac Failure varchar 3 √ null
Ischaemic Heart Disease varchar 3 √ null
Hypertension varchar 3 √ null
Liver Disease varchar 3 √ null
Mental Illness varchar 3 √ null
Neurological Disease varchar 3 √ null
Other varchar 3 √ null
Peripheral Vascular Disease varchar 3 √ null
Renal Disease varchar 3 √ null
Respiratory Disease varchar 3 √ null
Creatinine >170mmol/l varchar 3 √ null
On Systemic Steroids varchar 3 √ null
Other Vascular Disease varchar 3 √ null
On Warfarin varchar 3 √ null
On Dipyridamole varchar 3 √ null
On Clopidogrel varchar 3 √ null
Pacemaker varchar 3 √ null
Other Co-morbidities varchar 255 √ null
History of Smoking varchar 80 √ null
History of Alcohol (Current) varchar 100 √ null
History of Alcohol (Past) varchar 100 √ null
Social History text 2147483647 √ null
Medication text 2147483647 √ null
Allergies text 2147483647 √ null
Past Medical History text 2147483647 √ null
Height real 4 √ null
Weight real 4 √ null
BMI float 8 √ null
ClinicalFrailtyScale varchar 54 √ null
Date Family History Taken smalldatetime 16 √ null
Relationship to Patient varchar 50 √ null
Primary Diagnosis of Relation varchar 203 √ null
Primary Diagnosis of Relation 2 varchar 203 √ null
Year Symptoms First Noted int 4 √ null
Month Symptoms First Noted int 4 √ null
Day Symptoms First Noted int 4 √ null
Date of Pre Treatment Dental Assessment smalldatetime 16 √ null
Organisation Site nvarchar 500 √ null
Clinical Assessment Result (Left breast) varchar 50 √ null
Clinical Assessment Result (Right breast) varchar 50 √ null
Comments (Other Family History) text 2147483647 √ null
Haematuria varchar 3 null
Raised PSA varchar 3 null
Menstrual Status varchar 50 √ null
Age at Menopause (years) int 4 √ null
HRT varchar 50 √ null
HRT - Length of Usage (Years) varchar 255 √ null

View Definition

Possibly Referenced Tables/Views