vwAO_DATA


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Patient Name varchar 100 √ null
Gender varchar 100 √ null
NHS Number varchar 10 √ null
Hospital Number varchar 50 √ null
Organisation First Seen varchar 50 √ null
Referral To varchar 50 √ null
Date Referred date 20 √ null
Time Referred time 32 √ null
Route of Referral varchar 50 √ null
Referrer Name varchar 2147483647 √ null
Reason for Referral varchar 50 √ null
Method of Referral varchar 50 √ null
Emergency Admission? varchar 10 √ null
Patient Type varchar 50 √ null
Cancer Complications varchar 2147483647 √ null
Other Cancer Complications varchar 2147483647 √ null
Treatment Complications varchar 2147483647 √ null
Other Treatment Complications varchar 2147483647 √ null
Primary Tumour Site varchar 50 √ null
Tumour Sub Site Type varchar 50 √ null
Reason for Referral to AOS varchar 2147483647 √ null
Additional Cancer Complications Information varchar 2147483647 √ null
Additional Treatment Complications Information varchar 2147483647 √ null
Current Treatment varchar 2147483647 √ null
Current Treatment Intent varchar 50 √ null
Treatment Regimen varchar 50 √ null
Consultant/Haematologist varchar 50 √ null
Primary Treatment Centre varchar 50 √ null
Assessment Date date 20 √ null
Assessment Time time 32 √ null
Assessment Type varchar 2147483647 √ null
Assessment Location varchar 50 √ null
Assessed By CNS varchar 2147483647 √ null
Assessed By Consultant varchar 2147483647 √ null
Contact With varchar 50 √ null
Is Frailty Suspected? varchar 5 √ null
Is a (CGA) required? varchar 10 √ null
Performance Status(WHO) int 4 √ null
UKONS Score int 4 √ null
Significant Medical History varchar 2147483647 √ null
Discussed With varchar 2147483647 √ null
Additional Notes varchar 2147483647 √ null
Record of Assessment varchar 2147483647 √ null
Advice Given varchar 2147483647 √ null
Name of HCP Advice Was Given To varchar 2147483647 √ null
Additional Advice Given varchar 2147483647 √ null
Actions Taken varchar 2147483647 √ null
Additional Action Taken varchar 2147483647 √ null
Name Of Other Service varchar 2147483647 √ null
Tests Cancelled? varchar 100 √ null
Other Tests Cancelled varchar 2147483647 √ null
Date of Discharge from AOS date 20 √ null
Date of Discharge from Hospital date 20 √ null
Length of Stay - day(s) int 4 √ null
Discharge Destination varchar 2147483647 √ null
Early Discharge Recommended? varchar 10 √ null
Admission Avoided? varchar 10 √ null
Outcome varchar 2147483647 √ null
Other Outcome varchar 2147483647 √ null
Discharge/Outcome Comments varchar 2147483647 √ null
Date Neutropenic Sepsis Suspected date 20 √ null
Time Neutropenic Sepsis Suspected time 32 √ null
Date Assessment Neutropenic Sepsis date 20 √ null
Time Assessment Neutropenic Sepsis time 32 √ null
Date Arrival Neutropenic Sepsis date 20 √ null
Time Arrival Neutropenic Sepsis time 32 √ null
Date Antibiotics Prescribed Neutropenic Sepsis date 20 √ null
Time Antibiotics Prescribed Neutropenic Sepsis time 32 √ null
Date Antibiotics Administered Neutropenic Sepsis date 20 √ null
Time Antibiotics Administered Neutropenic Sepsis time 32 √ null
Neutropenic Sepsis Confirmed? varchar 5 √ null
Date Neutropenic Sepsis Confirmed date 20 √ null
Administration Service varchar 2147483647 √ null
Correct Medication Given? varchar 5 √ null
Medication Given Comments varchar 2147483647 √ null
Name of Antibiotic Given varchar 2147483647 √ null
Dose of Antibiotic Given varchar 2147483647 √ null
Contributing factors if antibiotic not administered in first hour varchar 2147483647 √ null
Assessed By CNS (Neutropenic Sepsis) varchar 2147483647 √ null
Assessed By Consultant (Neutropenic Sepsis) varchar 2147483647 √ null
Date MASCC Risk Index Completed date 20 √ null
Time MASCC Risk Index Completed time 32 √ null
Total MASCC Score int 4 √ null
Assessment Date (MSCC) date 20 √ null
Assessment Time (MSCC) time 32 √ null
Assessed By CNS (MSCC) varchar 2147483647 √ null
Assessed By Consultant (MSCC) varchar 2147483647 √ null
Oncologist/Haematologist (MSCC) varchar 100 √ null
Record of Discussions with Treatment Team(s) varchar 2147483647 √ null
Steroids Started? varchar 5 √ null
Date Steroids Started date 20 √ null
Type of Steroids Administered varchar 2147483647 √ null
Nursed Flat Prior to Referral varchar 5 √ null
Type of Imaging Requested varchar 20 √ null
Other Imaging varchar 2147483647 √ null
Date Imaging Requested date 20 √ null
Time Imaging Requested time 32 √ null
Date Imaging Performed date 20 √ null
Time Imaging Performed time 32 √ null
Date Imaging Reported date 20 √ null
Time Imaging Reported time 32 √ null
Reporting Organisation varchar 100 √ null
MSCC Confirmed? varchar 5 √ null
MSCC Confirmed Date date 20 √ null
Date Spinal Surgeons Informed date 20 √ null
Date Radiotherapy Informed date 20 √ null
Diagnosis Delay Reasons varchar 2147483647 √ null
Primary (Definitive) Treatment Type varchar 100 √ null
Other Treatment varchar 2147483647 √ null
Treatment Start Date date 20 √ null
Treatment Start Time time 32 √ null
Primary Treatment Organisation varchar 100 √ null
Treatment Delay Reasons varchar 2147483647 √ null
3 Month Follow Up Complete varchar 5 √ null
3 Month Function Outcome (Pain) varchar 10 √ null
3 Month Function Outcome (Mobility) varchar 10 √ null
3 Month Function Outcome (Continent) varchar 10 √ null
12 Month Follow Up Complete varchar 5 √ null
12 Month Function Outcome (Pain) varchar 10 √ null
12 Month Function Outcome (Mobility) varchar 10 √ null
12 Month Function Outcome (Continent) varchar 10 √ null
24 Month Follow Up Complete varchar 5 √ null
24 Month Function Outcome (Pain) varchar 10 √ null
24 Month Function Outcome (Mobility) varchar 10 √ null
24 Month Function Outcome (Continent) varchar 10 √ null
Date Of Death date 20 √ null
Username varchar 50 √ null

View Definition

Possibly Referenced Tables/Views