BIvwPalCareReferrals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PALLIATIVE_ID int 4 null
NHS Number varchar 10 √ null
Hospital Number varchar 20 √ null
Full Name varchar 111 √ null
Referral Type varchar 50 √ null
Date of Referral smalldatetime 16 √ null
Consultant varchar 59 √ null
Source of Referral varchar 50 √ null
Other Referral Source varchar 255 √ null
Type of Referrer varchar 50 √ null
Ward(Referred From) varchar 50 √ null
Referral HSN/HST varchar 50 √ null
Referral Reason Old varchar 50 √ null
Referral Reason New nvarchar 1073741823 √ null
Other Referral Reason varchar 255 √ null
Palliative Care Reason varchar 50 √ null
Referral Priority varchar 50 √ null
Previous Specialist Support varchar 70 √ null
Referral Outcome varchar 50 √ null
Date of First Contact smalldatetime 16 √ null
Key Worker varchar 50 √ null
Current 1st Choice of preferred place of death varchar 50 √ null
Other current 1st choice of preferred place of death varchar 255 √ null
Personalised Care Plan Offered varchar 100 √ null
Consent for Secondary use varchar 50 √ null

View Definition

Possibly Referenced Tables/Views