BIvwCarePlanMDT


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
Care Plan Agreed Date smalldatetime 16 √ null
Organisation nvarchar 500 √ null
Cancer Care Plan Intent varchar 50 √ null
First Treatment varchar 255 √ null
Second Treatment varchar 255 √ null
Third Treatment varchar 255 √ null
Fourth Treatment varchar 255 √ null
To be actioned by varchar 255 √ null
Performance Status varchar 183 √ null
Co-morbidity Index varchar 50 √ null
Was patient discussed at MDT varchar 3 √ null
MDT Meeting Site varchar 50 √ null
Sub Site varchar 50 √ null
MDT Meeting Date smalldatetime 16 √ null
Location varchar 50 √ null
Was Care Plan Agreed at MDT varchar 3 √ null
MDT Comments nvarchar 1073741823 √ null
Referred To varchar 50 √ null
Who Referred To varchar 59 √ null
Reviewed by Pathologist prior to MDT varchar 5 √ null
Reviewed By varchar 50 √ null
No Treatment Reason varchar 50 √ null
Was patient discussed at Network MDT varchar 5 √ null
Date of Network Meeting smalldatetime 16 √ null
Network Decision text 2147483647 √ null
Network To be actioned by varchar 255 √ null
Network Comments text 2147483647 √ null
eGFR Status requested? varchar 3 √ null
Was Resective Pathology Discussed? varchar 3 √ null
Restorative Dentist asked if Restorative Assessment Needed? varchar 18 √ null
Restorative dental assessment necessary? varchar 3 √ null
Discussion Type varchar 50 √ null

View Definition

Possibly Referenced Tables/Views