vwCUP_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHS Number varchar 10 √ null
Hospital Number varchar 100 √ null
Surname varchar 100 √ null
Forename varchar 100 √ null
Date of Birth datetime 16,3 √ null
Gender varchar 50 √ null
Source of Referral varchar 100 √ null
Referrer Name varchar 100 √ null
Priority Type varchar 100 √ null
Consultant Upgrade varchar 20 √ null
DateReceiptofReferral datetime 16,3 √ null
Date of Diagnosis datetime 16,3 √ null
Primary Diagnosis varchar 200 √ null
Tumour Status varchar 100 √ null
CUP Category varchar 50 √ null
CUP Category Confirmed Date datetime 16,3 √ null
Transferred to Another Tumour Site varchar 20 √ null
Tumour Site Transferred To varchar 20 √ null
Date Transferred datetime 16,3 √ null
Discussed at MDT varchar 20 √ null
MDT Meeting varchar 20 √ null
MDT Date datetime 16,3 √ null
MDT Comments varchar 2147483647 √ null
Care Plan Agreed varchar 20 √ null
Care Plan Agreed Date datetime 16,3 √ null
Care Plan MDT Performance Status varchar 20 √ null
Cancer Care Plan Intent varchar 20 √ null
Reason Not Curative varchar 8000 √ null
No Treatment Reason varchar 100 √ null
First Treatment varchar 100 √ null
Date of First Treatment datetime 16,3 √ null
Second Treatment varchar 100 √ null
Date of Second Treatment datetime 16,3 √ null
Pathology Report varchar 20 √ null
Date of Discharge datetime 16,3 √ null
Discharge Destination varchar 50 √ null
Follow Up Record Created varchar 20 √ null
Follow Up Date datetime 16,3 √ null
Follow Up Status varchar 100 √ null
Patient Status varchar 20 √ null
Username varchar 50 √ null

View Definition

Possibly Referenced Tables/Views