BIvwAHPContacts


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
Date Referred to AHP smalldatetime 16 √ null
Date of Contact smalldatetime 16 √ null
AHP Type varchar 50 √ null
AHP Name varchar 50 √ null
Other AHP Name varchar 255 √ null
Other Sub Role varchar 100 √ null
HCP Role varchar 50 √ null
HCP Name varchar 255 √ 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 Type varchar 50 √ null
Duration (mins) int 4 √ null
Contact Location varchar 50 √ null
Privacy Available for Contact varchar 3 √ null
Information and Advice text 2147483647 √ null
Clinical Activity text 2147483647 √ null
Height real 4 √ null
Weight real 4 √ null
Communication varchar 50 √ null
Notes text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views