BIvwCNSContacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
CNS Contact 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 Contact datetime 16,3 √ null
CNS/Support Worker varchar 50 √ null
Role nvarchar 30 √ null
Clinical Nurse Specialist Type varchar 50 √ null
CNS Telephone Number nvarchar 100 √ null
Patient Status varchar 50 √ null
Contact with Patient varchar 3 null
Contact with Relative varchar 3 null
Contact with Carer varchar 3 null
Contact with HCP varchar 3 null
Contact with Other Person varchar 3 null
Contact Type nvarchar 1073741823 √ null
Time Spent (mins) nvarchar 1073741823 √ null
Other Contact Type nvarchar 1073741823 √ null
Contact Location varchar 50 √ null
Privacy Available for Contact varchar 3 √ null
Intervention Level 1 varchar 3 √ null
Intervention Level 2 varchar 3 √ null
Intervention Level 3 varchar 3 √ null
Intervention Level 4 varchar 3 √ null
Information and Advice nvarchar 1073741823 √ null
Clinical Activity nvarchar 1073741823 √ null
Referrals (Primary) varchar 50 √ null
Referrals (Secondary) varchar 50 √ null
Referrals (Third) varchar 50 √ null
Performance Status varchar 154 √ null
HNA Point of Pathway varchar 50 √ null
Treatment Summary Completed varchar 3 √ null
Treatment Summary Shared With nvarchar 40 √ null
When was Treatment Summary Completed nvarchar 200 √ null
Date HNA Completed datetime 16,3 √ null
HNA Completed varchar 50 √ null
HNA Completed by Other nvarchar 100 √ null
HNA Status varchar 75 √ null
Reason HNA Not Offered nvarchar 100 √ null
Reason HNA Declined nvarchar 100 √ null
Reason HNA Unable To Complete nvarchar 100 √ null
Type Offered? varchar 50 √ null
Date Care Plan Completed datetime 16,3 √ null
Care Plan Status varchar 100 √ null
Reason Care Plan Declined nvarchar 100 √ null
Reason Care Plan Not Offered nvarchar 100 √ null
Reason Care Plan Unable To Complete nvarchar 100 √ null
Care Plan Point Of Pathway varchar 50 √ null
Care Plan Point Of Pathway Other nvarchar 100 √ null
Care Plan Completed By varchar 50 √ null
Care Plan Completed By Other nvarchar 100 √ null
Planned Contact varchar 50 √ null
Date HNA Offered datetime 16,3 √ null
Date HNA Declined datetime 16,3 √ null
Permission to talk to varchar 150 √ null
Date Care Plan Declined datetime 16,3 √ null
Date Care Plan Offered datetime 16,3 √ null

View Definition

Possibly Referenced Tables/Views